Different versions of ODBC drivers accept different parameters (Execute())??

[Wenrich]

in my app, i have the following code run successfully with MS Access Driver 4.00.6019.00, but fail with version 4.00.6200.00. the exception thrown says "[ODBC MS Access Driver] Too few parameters. Expected 1." // _ConnectionPtr m_pConnection; // _RecordsetPtr m_pRecordSet; m_pRecordSet = m_pConnection->Execute(_bstr_t(query), &vRecsAffected, adOptionUnspecified); How should i overcome this problem? is there a generic way that works with different versions of MS Access Driver? Thanks a lot! Wenrich

[Pavel Klocek]

What is in query? Maybe some field name is equal to a reserved word added in new version? Pavel Sonork 100.15206

[Wenrich]

Thanks Varel! this query is CString query; query.Format(_T("SELECT * FROM %s WHERE (%s='%s') AND (%s='%s')"), table, key, value1, field, value2); // table:"client", key:"ID", value1:"some name", field:"Pass", values"some // password" Is there anything wrong with the field names? Thanks a lot!

[Pavel Klocek]

I would try:

SELECT * FROM [%s] WHERE ([%s]='%s') AND ([%s]='%s')

Doesn't some of the values contain an ' character (apostrof)? Pavel Sonork 100.15206