Connecting to MySQL

[lucyv]

I'm having a lot of trouble connecting to a MySQL database on my webserver. Everytime I run this code I get this error message:


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

Dim pconConnection As New OleDb.OleDbConnection

With pconConnection                
    .ConnectionString = "PROVIDER=SQLOLEDB;" & _
                        "DRIVER={MySQL ODBC 3.51 Driver};" & _
                        "SERVER=mysql.domain.com;" & _
                        "DATABASE=###;" & _
                        "UID=###;" & _
                        "PWD=###;" & _
                        "OPTION=3;" & _
                        "PORT=3306"
    .Open()
End With

Does anyone see what I am doing wrong?

-lucyv

 

[earthandfire]

Have a look at these two:

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

It looks as if you shouldn't be using both:

PROVIDER=SQLOLEDB
and
DRIVER={MySQL ODBC 3.51 Driver}


Hope this helps.

 

[lucyv]

I don't understand. Do I have to download/install the OLEDB Provider for MySQL? I already have an application called MySQL-Front that can connect to my webserver, so I'm assuming I already have the adequate files.

Please help!!!

-lucyv

 

[lucyv]

I just downloaded the MyODBC Provider but I'm still having problems. Any help would be greatly appreciated.

-lucyv