ASP.NET<->MySQL Connection String?

Hi,

I've been having trouble connecting to the mySql installation on mirelstaging.com. I've tried a number of different permutations of this connection string:

OdbcConnection cn1 = new OdbcConnection('DRIVER={MySQL ODBC 3.51 Driver}; SERVER=mssql01.discountasp.net; DATABASE=MYSQLDB_439326; UID=myusername; PASSWORD=mypassword; OPTION=3');

((including adding PORT=3306 and DSN=myusername_mysqlConn

but I always get the same error message: 'Data Source Name not found and no default driver specified.'

I'm hoping I just need an example of a connetction string that works using the OdbcConnection from .NET 2.0.

Many Thanks in Advance,

Michael

 

I don't use MySQL but does this help?
http://www.connectionstrings.com/?carrier=mysql

 

Thanks-- the support people told me it must be a programming error and to post here! So, I reluctantly changed to Sql Server....