ODBC database connection string to Linux server?

Discussion in 'ASP.NET / ASP.NET Core' started by tgrgrd00, Oct 15, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I am trying to access a mysql database that is hosted on a seperate Linux server. I know this can be done with an ODBC connection. I have researched and tried 100 different ways to make this connection but to no avail. Here is my connection string....what is wrong?




    Dim myconstring As String = "DRIVER={MYSQL ODBC 3.51 Driver};SERVER=66.98.142.9;DATABASE=captain_xmb2;UID=username;PASSWORD=password;OPTION=3;PORT=3306;"


    Here is the error I am getting:


    [OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'username'@'web115.discountasp.net' (using password: YES)
    ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'username'@'web115.discountasp.net' (using password: YES)]

    If the IP address I am specifying is not hosted on discountasp.net then why is the error showing web115.discountasp.net? Anyone have any idea what I am doing wrong...this is driving me bonkers!

    Thanks!
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    You probably need to use use a >NET data provider for mySQL. I don't think you can use ODBC provider w/o a DSN.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page