locked
How to declare connection string for Toad MySQL Instance RRS feed

  • 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?

    Wednesday, April 23, 2014 3:59 PM

Answers

All replies

  • User-821857111 posted

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

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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, April 23, 2014 4:02 PM
  • User1283221234 posted

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

    Wednesday, April 23, 2014 4:16 PM
  • 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?

    Wednesday, April 23, 2014 4:41 PM