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.