Link to home
Start Free TrialLog in
Avatar of cagilbert
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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Post the query and the consition that it fails with and the one that is successful.
Avatar of cagilbert
cagilbert

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.
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.
ASKER CERTIFIED SOLUTION
Avatar of cagilbert
cagilbert

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It doesn't figure out the issue, but it solves the problem.