Still problems with pgODBC

From: "Lothar Behrens" <lothar(dot)behrens(at)lollisoft(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Still problems with pgODBC
Date: 2004-10-23 11:13:05
Message-ID: 200410231113.i9NBD5C28887@jedi.behrens.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I have still problems with my application using pgODBC driver.

I am mainly using Windows 2000, Openwatcom 1.2 and the official
Cyborg 7.3.200 version of the ODBC driver.

I can delete a row and after doing that I am able to move to first or
last row. But if I try to move next, I get this log messages amd my
app crashes - possibly due to the 'SC_pos_reload_needed'.

Why and how can I avoid this problem ?

I tried to do a SQL_REFRESH, but this doesn't help.

I have tested my application against MS SQL and Sybase database. It
works, but it might be still a bug in my code - I think.

(Possibly the proper handling of the above 'SC_pos_reload_needed'
message)

Thanks

Lothar

[872]DEFAULT: len = 20, ptr = '12345 '
[872] SQL_C_CHAR, default: len = 20, cbValueMax = 21,
rgbValueBindRow = '12345 '
[872]copy_and_convert: retval = 0
[872][SQLExtendedFetch][872]PGAPI_ExtendedFetch: stmt=15799552
[872]SQL_FETCH_NEXT: num_tuples=4, currtuple=1
[872]SC_pos_reload_needed
[872]PGAPI_ExtendedFetch: new currTuple = 1
[872]manual_result = 0, use_declarefetch = 0
[872]type = -858993460 and valuepointer here (line: 871) is 00000000
[872]**** SC_fetch: manual_result
[872]type = -858993460 and valuepointer here (line: 909) is 00000000
[872]manual_result = 0, use_declarefetch = 0
[872]type = -858993460 and valuepointer here (line: 871) is 00000000
[872]**** SC_fetch: manual_result
[872]type = -858993460 and valuepointer here (line: 909) is 00000000
[872]type = -858993460 and valuepointer here (line: 951) is 00000000
[872]fetch: cols=9, lf=0, opts = 15799640, opts->bindings = 15831744,
buffer[] = 15667784
[872]type = -858993460 and valuepointer here (line: 958) is 00000000
[872]type = 1042 and valuepointer here (line: 967) is 00000000
[872]copy_and_convert: field_type = 1042, fctype = 99, value = '

---- My home: www.lollisoft.de -----------------------------
Lothar Behrens | Independent: lothar(dot)behrens(at)gmx(dot)de
Rosmarinstr 3 | My public project:
40235 Düsseldorf | http://sourceforge.net/projects/lbdmf
| -> Need comments, please visit :-)

Browse pgsql-odbc by date

  From Date Subject
Next Message Joost Kraaijeveld 2004-10-25 13:20:13 Does SQLFetch get all the data from the database?
Previous Message Dave Page 2004-10-21 09:03:11 Re: Snapshot release 08.00.0002 uploaded