MyOLEDB

[Swi]

I have downloaded the above but when I attempt to connect to a certain table it says the table does not exit even though it actually does. Any ideas.


' Set your objects
Set MYSQLCON = New ADODB.Connection
Set MYSQLRS1 = New ADODB.Recordset

With MYSQLCON
.CommandTimeout = 10000
.ConnectionTimeout = 10000
.CursorLocation = adUseServer
.Open "Provider=MySQLProv;" & _
"Location=999.999.999.99;" & _
"Data Source=xxxxx;" & _
"User Id=xxxxx;" & _
"Password=xxxxxxx;"
End With


Set MYSQLRS1 = New ADODB.Recordset
MYSQLRS1.Open "SELECT * FROM elements;", MYSQLCON, adOpenDynamic, adLockOptimistic, adCmdText

Swi

 

[vbrunner]

Check the connection userid and make sure it has authorization to access the table.