ODBC Error. (OpenInsight 32-bit Specific)
At 30 JUL 2003 08:56:49PM matt bavis wrote:
I am getting an error message while trying to use the Revelation ODBC driver.
If I am reading my log file correctly I see my SQL command and then it looks like it successfully starts to return records, but then I get the following error:
DIAG 42S00 Revelation Software IncRevelation ODBC DriverOpenEngineSQLFetch error - OpenEngine has reported the following exception: FS100 - Record "%REVODBC_16856236*2" does not exist. (7)
If I instruct my SQL interface to only return 100 records, it completes successfully. When I bump it up to 1000, I get this message.
I have went through my dictionaries and changed all of the VARCHAR(65531) to the minimum I can get away with, most are VARCHAR(2). I am only asking for one item when I perform the command that gives the above error
Does anyone have any ideas, or suggestions?
Thanks,
Matt
At 31 JUL 2003 06:16AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Matt,
Pretty sure I've seen this behaviour under certain circumstances and it may have got fixed in a recent update. What's the file version of RevODBC.DLL in your System32 directory?
World leaders in all things RevSoft
At 31 JUL 2003 07:25AM matt bavis wrote:
It is version 1.00.02.241
Matt