MYSQL ODBC Connection

[James Proctor]

Hi there, im having problems connecting to a MYSQL database and think
there must be something up with my connection string. I wondered if
anyone could help me out. Im using an ODBC connection. It currently
looks something like this.

DBStr = "DRIVER={MySQL ODBC 3.51
Driver};SERVER=localhost;DATABASE=ebmdb;UID=Username;PASSWORD=Password;O
PTION=3;"
MYOpenConnection = New OdbcConnection(DBStr)
Try
MYOpenConnection.Open()
MsgBox(MYOpenConnection.State.ToString)
Catch ex As Exception
MsgBox("No Connection")
End Try

I just keep getting it jumping to "No Connection" msgbox. Does anybody
know where im going wrong. My guess is that the connection string is
incorrect. Maybe someone can point me in the right direction as to what
it should be.

Regards

JP

P.S. I have installed the MYSQL ODBC Drivers

 

[Scott]

According to the example on the following page the User ID is assigned using
the keyword "USER" instead of "UID".

http://www.mysql.com/products/myodbc/faq_3.html

Also, check the information for the exception that is being caught to get
more information about the error.