Create New Data Source To Sql Server?

[sec-k]

I am experimenting with tying some software to an SQL database. I'm having a problem trying to connect to the database, which I created with the MySql Database Wizard in the cPanel.

 

Here is what I'm doing (In Windows XP_64bit):

 

1. 
    
   
2. Start --> Control Panel --> Administraion Tools --> Data Sources (ODBC)
   
3. System DSN tab --> Add... --> SQL Server (Version 2000.86.3959.00, File SQLSRV32.dll) --> Finish
   
4. I then enter a name for the data source, and type in my domain for the server.
   
5. I then configure the Client and change the port to 3306
   
6. I then click next and I get the following error.
   

 

First of all, is what I'm trying to do even possible? Can I connect to a MySQL server? If so, is there more to it than the steps I am following? If you hadn't already guessed, I know very little about SQL databases. I've connected the application to an Access database, but want to take it a step further. Any help or guidance would be appreciated.

 

Thanks,

Jason

[sec-k]

Ok, I now have a connection. I downloaded the MySQL connection driver and it seems to work.

[TCH-Thomas]

I´m glad you found a solution.

[sec-k]

Is there a specific MySQL driver that I need to use? Looks like the MySQL version per cpanel is 5.0.91-community and I'm using MySQL ODBC 5.1 Driver. Should this work correctly?

[TCH-Bruce]

Is it working? Usually they are backwards compatible.

[sec-k]

Well, it connects but nothing happens in the software I'm using when I press OK to export the data. Must be something on the software that I'm using.