MySQL ConnectionString.....HELP!!!!!!

[gimbal]

I've just moved over to the hosting here and am in the process of moving my sites accross.
all was going well until i try to connect to the database.
I can connect vie MySQL Query Browser and add all of my tables and data, but as soon as i try to connect from my code (classic asp) i get an error.

I was using the following connection string:

Driver={mySQL};Server=[IP Address of server];Stmt=;Database=[DATABASE NAME];Uid=[USER];Pwd=[PASSWORD];

but i get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/testimonial.asp, line 13


Can anyone point me in the right direction please?
I need to get this sorted quickly as downtime is a problem.

Thanks

[sysadmin]

Hi Ian,

I've corrected the connection string in your code, please check the site now. You might want to restore the MySQL database such that the other errors can be fixed too

Driver={MySQL ODBC 5.1 Driver};Server=[IP ADDRESS];Database=[DATABASE NAME];User=[USER];Password=[PASSWORD];

More info on MySQL connection strings can be found here : MySQL Connection String Samples - ConnectionStrings.com

Please get in touch if you require any further assistance, good luck !

[gimbal]

Thats great thanks.
I'd tried several different combinations (including ones suggested on the siteyou mentioned)
and it turns out to be the name of the driver i had got wrong. lol

Oh well. it works now.

Thanks again for the help, its much appreciated.

[sysadmin]

Originally Posted by gimbal

Thats great thanks.
I'd tried several different combinations (including ones suggested on the siteyou mentioned)
and it turns out to be the name of the driver i had got wrong. lol

Oh well. it works now.

Thanks again for the help, its much appreciated.

You're welcome