Last post Apr 23, 2014 04:41 PM by Mikesdotnetting
Apr 23, 2014 03:59 PM|aktzc|LINK
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
but it is not working and throwing the following error:
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?
Apr 23, 2014 04:02 PM|Mikesdotnetting|LINK
Connection strings for MySQL: http://www.connectionstrings.com/mysql/
Bookmark the site. You will use it often...
Apr 23, 2014 04:16 PM|aktzc|LINK
I created my connectionstring from http://www.connectionstrings.com/mysql/. Still I got the above mentioned error.
Apr 23, 2014 04:41 PM|Mikesdotnetting|LINK
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?