connecting to MySQL with .Net 2.0
-
Hello everyone, I'm currently writing a app that uses MySQL. However, I'm having trouble connecting to my database. I'm running the tests from my local machine and I *DO* have the MySQL Connector .Net 1.0.7 driver installed and the ODBC namespace imported. This is the connection string I'm using: Driver={MySQL ODBC 3.51 Driver};server=myserver.myhost.com;user id=myusername; password=mypassword; database=mydatabase; pooling=false This is the error I'm receiving: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? I've looked throught quite a few tutorials and I seem to be doing everything that they say correctly. Thanks in advance for any help! ------------------- abort, retry, fail?
-
Hello everyone, I'm currently writing a app that uses MySQL. However, I'm having trouble connecting to my database. I'm running the tests from my local machine and I *DO* have the MySQL Connector .Net 1.0.7 driver installed and the ODBC namespace imported. This is the connection string I'm using: Driver={MySQL ODBC 3.51 Driver};server=myserver.myhost.com;user id=myusername; password=mypassword; database=mydatabase; pooling=false This is the error I'm receiving: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? I've looked throught quite a few tutorials and I seem to be doing everything that they say correctly. Thanks in advance for any help! ------------------- abort, retry, fail?
Hello, In this page you will find all the settings and parameters to connect to MySQL via .net http://www.connectionstrings.com Let's hope is just a parameter issue :-(, Good luck Braulio /// ----------------------- Braulio Díez http://www.bdiez.com /// -----------------------
-
Hello everyone, I'm currently writing a app that uses MySQL. However, I'm having trouble connecting to my database. I'm running the tests from my local machine and I *DO* have the MySQL Connector .Net 1.0.7 driver installed and the ODBC namespace imported. This is the connection string I'm using: Driver={MySQL ODBC 3.51 Driver};server=myserver.myhost.com;user id=myusername; password=mypassword; database=mydatabase; pooling=false This is the error I'm receiving: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Any ideas? I've looked throught quite a few tutorials and I seem to be doing everything that they say correctly. Thanks in advance for any help! ------------------- abort, retry, fail?