Dominic Caffey - Alliance Entertainment Corp.
9/26/2002 10:54:00 PM
I'm getting the following exception on a sporadic basis:
DataBase Exception Caught:
Microsoft.Data.Odbc.OdbcException: NO_DATA - no
error information available
at Microsoft.Data.Odbc.OdbcConnection.HandleError
(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode)
at Microsoft.Data.Odbc.OdbcDataReader.GetData(Int32 i,
SQL_C sqlctype, Int32 cb)
at Microsoft.Data.Odbc.OdbcDataReader.internalGetString
(Int32 i)...
I can run the same select that caused the above directly
from the Informix command line interface and the select
runs fine so I know the problem is in the Odbc driver.
.....
One of my associates suggested trying a "pass-thru" query
as a possible way to get around the above exception.
Problem is that I can't find a way to do this with an
OdbcDataAdapter after having read the documentation. Is
doing a "pass-thru" query even possible
with "Microsoft.Data.Odbc.*"? If so, could someone post
back to this thread how to do it and also email me
directly at "domcaf@aent.com".
Thanks,
Dom