Hi all,
I'm encountering a strange problem and I can't seem to make any sense of.
First, here is my environment :
Client.
WIN2k Pro - SP3
Two ODBC datasources, both to an Oracle Database Server (Oracle 9i)
The datasources use the following ODBC drivers
Source 1 = 2.573.9001.00 (MS Driver)
Source 2 = 8.01.78.00 (Oracle Driver)
Now here is my problem. In my program, I execute exactly the same code and I get success in one case(Source 1 - MS Driver), and an ODBC error in the other(Source 2 - Oracle Driver).
In the case that fails, the call thats failing is the SQLGetData call. In the Source 1 case, the code goes thru fine and I have no problem. In the Source 2 case, I get the following error from the SQLGetData call :
[S1109] [Oracle][ODBC][Ora]Invalid cursor position.
The table I'm querying has the following structure :
VI int, VC char(10), VV varchar(20), VF float, V2 int, V4 int, V9 int
and the only column I'm querying is the first one, VI.
Here is the output from the ODBC log file
Dyalog 56c-2e4 ENTER SQLExecDirect
HSTMT 0B151978
UCHAR * 0x0A034E38 [ -3] "SELECT VI FROM NICK ORDER BY
VI\ 0"
SDWORD -3
Dyalog_
Long postings are being truncated to ~1 kB at this time.
_