ODBC- call failed

[carolineon]

i opened a database with :

Set wspNew = CreateWorkspace("ODBCWorkspace", "Test_mon_access.mdb", "", dbUseODBC)
Set conn = wspNew.OpenConnection("connection2", dbDriverNoPrompt, False, _
"ODBC;DATABASE=LPC_SERVER;UID=id1;PWD=pw1;DSN=lpc_int")

Then i want to execute a sql string :

Set recSocket = conn.OpenRecordset(strSql, dbOpenDynaset)

But it cannot execute it and had the message "ODBC-call failed".
What's wrong here? Can someone please tell me. I really need this urgently. Thank you.

[Cakkie]

What is the statement you are executing. Maybe there's a mistake there

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook