cagilbert
asked on
"ODBC call failed" on one specific query to SQL Server, no matter ODBC, ADO, pass through, etc.
The same query can work using one variable in the where clause, but fail using another -- same table, same query.
Post the query and the consition that it fails with and the one that is successful.
ASKER
set rs = db.OpenRecordset("Select * from tbl where TSid = " & lngTsID)
is one variation that fails. lngTSIS is a number. sometimes it works sometimes not.
is one variation that fails. lngTSIS is a number. sometimes it works sometimes not.
I am sorry but I am afraid that does not help me. I was asking for the specific values in your condition that fail and which are successful.
Hopefully, someone will step up to the plate with some insight.
Good luck.
Hopefully, someone will step up to the plate with some insight.
Good luck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It doesn't figure out the issue, but it solves the problem.