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):
Start --> Control Panel --> Administraion Tools --> Data Sources (ODBC)
System DSN tab --> Add... --> SQL Server (Version 2000.86.3959.00, File SQLSRV32.dll) --> Finish
I then enter a name for the data source, and type in my domain for the server.
I then configure the Client and change the port to 3306
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