Very weird coz same application works on my machine but not on the targeted machine (winxp also - with sp1, while mine has service pack2)
I am trying to connect to a mysql database and I am not having any problems from my computer while I get this error message (see topic) when tested on other computer!
for connection I am using:
.ConnectionTimeout = 60 ' seconds
.CommandTimeout = 5 'seconds
.CursorLocation = adUseClient
for recordset I use:
Set rsClients = New ADODB.Recordset
rsClients.CursorType = adOpenKeyset
rsClients.LockType = adLockBatchOptimistic
rsClients.Open "SELECT * FROM Users", oConnection, , , adCmdText
remember this works on my comp, but not on target pc.
And I've installed MDAC 2.8 on target pc, so I don't know what the problem is!