elsapo
October 21st, 2004, 08:06 AM
Hi,
I'm having a quite strange problem using ODBC Access Driver (4.00.6200.00) and MS Jet Engine (4, last service pack) in my database interface program (VC++ 7), against an Access 2002 MDB file.
The situation is pretty much simple. Whenever I'm trying to execute a prepared statement I'm getting the following error:
SQL Message: [Microsoft][ODBC Microsoft Access Driver] Object invalid or no longer set.
I've trie with Win2000/2003 and XP.
The statement is as simple as possible:
SELECT COLUMN1 FROM TABLE WHERE COLUMN2 = ?
The SQLPrepare works fine, I can check the number of needed parameters, the number of columns to be retrived and I can properly bind the parameters, but whenever the SQLExecute comes I receive the error message.
Even if I'm preparing a statement that does not contain any parameter, so I'm not binding too, the execution fails.
If I'm executing the statement using the SQLExecuteDirect it works, but obviously it prevents me from using variable parameters and prepare.
I've tried using Oracle and MSSQL as datasource and everything works fine.
Does anybody has an idea about this unusual problem?
Thank you very much in advance.
I'm having a quite strange problem using ODBC Access Driver (4.00.6200.00) and MS Jet Engine (4, last service pack) in my database interface program (VC++ 7), against an Access 2002 MDB file.
The situation is pretty much simple. Whenever I'm trying to execute a prepared statement I'm getting the following error:
SQL Message: [Microsoft][ODBC Microsoft Access Driver] Object invalid or no longer set.
I've trie with Win2000/2003 and XP.
The statement is as simple as possible:
SELECT COLUMN1 FROM TABLE WHERE COLUMN2 = ?
The SQLPrepare works fine, I can check the number of needed parameters, the number of columns to be retrived and I can properly bind the parameters, but whenever the SQLExecute comes I receive the error message.
Even if I'm preparing a statement that does not contain any parameter, so I'm not binding too, the execution fails.
If I'm executing the statement using the SQLExecuteDirect it works, but obviously it prevents me from using variable parameters and prepare.
I've tried using Oracle and MSSQL as datasource and everything works fine.
Does anybody has an idea about this unusual problem?
Thank you very much in advance.