Configuring MySQL with ODBC Data Source Administrator

[wryfhk22]

When I go into the ODBC Data Source Administrator, for the Tab User DSN, should I already have MySQL set as a Data Source. I have installed MySQL 5.5.10, run the MySQL Connector ODBC and have run the MySQL Workbench and connected to the DB fine.
When I go to the ODBC DS Admin,
1. Create a new Data Source: SQL Server
2. What Name for the DS: UserDSN
Desc: User DSN
Server: localhost
3. SQL Verify: With SQL Server Auth
Connect to SQL server to obtain default settings.
Login Id: root
password: xxxx

Then it goes into "Not Responding". In a couple of
minutes I get the following:

SQLSTATE '01000'
SQL Server Error: 10061
Connection Failed
SQLSTATE: '08001'
SQL Server Error: 17
SQL Server does not exist or access denied.

Any ideas? Thanx in advance.

[tylerlongtw]

i was looking for such an explanation, once I had to move my mySQL to Oracle database as the database was getting handy, I had faced a lot of problems, eventually i used Oracle with DSN configuration, but did not have an idea that even mySQL can also be configured through DSN