Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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 :-)


pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group