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
' 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