How to declare connection string for Toad MySQL Instance

Question

User1283221234 posted

Hi, I have a mySQL instance with Toad. I want to connect to the database(that is in the TOAD-MySQL Sever) from aspx page . What connectionString should I use and how should it be. I tried the following connectionstring

Server=serverName;Port=8080;Database=db_1;Uid=u_id;Pwd=pwd;Provider=SQLOLEDB;

but it is not working and throwing the following error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Invalid connection string attribute

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Invalid connection string attribute

Can anybody let me know where I was going wrong. And what should the connectionstring look like?

Answer 1

User-821857111 posted

Connection strings for MySQL: http://www.connectionstrings.com/mysql/

Bookmark the site. You will use it often...

Answer 2

User1283221234 posted

I created my connectionstring from http://www.connectionstrings.com/mysql/. Still I got the above mentioned error.

Answer 3

User-821857111 posted

None of the connection strings on the MySQL page feature the provider value you have used (which belongs to SQL Server). Try removing it. Also, did you repalce "ServerName" with the name of your MySQL server? And did you provide alternative values for the placeholders for the database name, user id and password?