hallo,
 
i use the cygwin postgresql 7.03.x and i have ported some tables from access to pg. for example the following you can see at the bottom of this mail. and there are some datasets in this table (more than 1!!!).
with libodbc++ i login into the db, create and execute my select-statement and let get the resultset with:
  odbc::ResultSet* rs = stmt->getResultSet();
 
and with rs->next() i go to the first dataset. all to this point works fine and the data is also correct. but if i try to get the next dataset with rs->next() i get this sql-exception:
  Error fetching numeric statement option: Not positioned on a valid row.
 
but there are more than 1 dataset in this table.
the odbc driver seems to work correctly cause access shows me all datasets.
 
i hope, somebody can help me.
thanks in advance,
axel
 
 

CREATE TABLE public.devices ( key_devclass int4 NOT NULL, key_devname varchar(50) NOT NULL, CONSTRAINT devices_pkey PRIMARY KEY (key_devname)) WITH OIDS;

 
 >From pgsql-odbc-owner@postgresql.org Sat May 22 03:47:50 2004 X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 383D1D1B1C7 for ; Sat, 22 May 2004 03:47:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 00791-01 for ; Sat, 22 May 2004 03:47:27 -0300 (ADT) Received: from bal_proxy00.BAL (unknown [193.170.218.78]) by svr1.postgresql.org (Postfix) with ESMTP id 7C182D1B1A9 for ; Sat, 22 May 2004 03:47:23 -0300 (ADT) Received: by BAL_PROXY00 with Internet Mail Service (5.5.2653.19) id ; Fri, 21 May 2004 10:54:10 +0200 Message-ID: <551ED10FD7815D4CA218B2DF1042FCC31B072E@BAL_PROXY00> From: Albin Blaschka To: "'pgsql-odbc@postgresql.org'" Subject: Unknown connect option (Get), Postgres 7.4.2 Date: Fri, 21 May 2004 10:54:10 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.4 tagged_above=0.0 required=5.0 testsÚTE_IN_PAST_12_24 X-Spam-Level: X-Archive-Number: 200405/38 X-Sequence-Number: 4062 Hello, Following situation: I have updated to Postgres 7.4.2 from 7.3.2, the ODBC-Driver stayed the same We use Access (Office XP) with Windows 2000 as frontend to our data But now after migration to the new database and a new server, I get following error-messages when I want to connect via ODBC (Access) or even via PGAdmin II (but PGAdmin III works...): (taken from the ODBC-Log) CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption0002', errnum 5, errmsg='Unknown connect option (Get)' and a littler after that: CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum5, errmsg='The database does not exist on the server or user authentication failed. This last message appears then in Access (with Errorcode #105) or in PGAdmin II. As said above, the connection from the same machine to the database in question with PGAdmin III *works with no problems*...only Access and PGAdmin II are having problems... The Database-Server now is a Debian "Sarge" (testing) - Box (the old one is a Debian "Woody") Clients are Windows 2000, Access is from Office XP ODBC-Driver Version is 7.03.02.00 In the archives, I have found quite similar questions/problems, but no answers... Some of the messages are quite outdated, maybe now somebody araound here knows a solution or what I might have done wrong... Please help & thanks in advance! Albin Blaschka Here is the output of the psqlodbc-log: CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption0002', errnum 5, errmsg='Unknown connect option (Get)' ------------------------------------------------------------ henv6060816, conn6066856, status=0, num_stmts sock6060872, stmts6060944, lobj_type=-999 ---------------- Socket Info ------------------------------- socket=-1, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in6077856, buffer_out6081960 buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0 conn6066856, PGAPI_DriverConnect( in)='DSN=testing7.4.2;', fDriverCompletion=1 DSN info: DSN='testing7.4.2',server='balappserver',port='5432',dbase='zuecht',user='al bin',passwd='xxxxx' onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0' conn_settings='',conn_encoding='OTHER' translation_dll='',translation_option='' Global Options: Version='07.03.0200', fetch0, socket@96, unknown_sizes=0, max_varchar_size%4, max_longvarchar_size90 disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0 text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALENd extra_systable_prefixes='pg_;', conn_settings='' conn_encoding='OTHER' conn6066856, query=' ' NOTICE from backend during send_query: 'LOG: Anweisung: ' NOTICE from backend during send_query: 'LOG: Dauer: 0.246 ms ' CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum5, errmsg='The database does not exist on the server or user authentication failed.' ------------------------------------------------------------ henv6060816, conn6066856, status=0, num_stmts sock6060872, stmts6060944, lobj_type=-999 ---------------- Socket Info ------------------------------- socket–4, reverse=0, errornumber=0, errormsg='(NULL)' buffer_in6077856, buffer_out6081960 buffer_filled_inH, buffer_filled_out=0, buffer_read_inH And here from the mylog-file: [1244]globals.extra_systable_prefixes = 'dd_;' [1244][[SQLAllocHandle]][1244]**** in PGAPI_AllocEnv ** [1244]** exit PGAPI_AllocEnv: phenv = 136060816 ** [1244][[SQLSetEnvAttr]] att 0,2 [1244][[SQLAllocHandle]][1244]PGAPI_AllocConnect: entering... [1244]**** PGAPI_AllocConnect: henv = 136060816, conn = 136066856 [1244]EN_add_connection: self = 136060816, conn = 136066856 [1244] added at i =0, conn->henv = 136060816, conns[i]->henv 136060816 [1244][SQLGetInfo(30)][1244]PGAPI_GetInfo: entering...fInfoTypew [1244]PGAPI_GetInfo: p='03.00', len=0, value=0, cbMax [1244][[SQLSetConnectAttr]] 103 [1244]PGAPI_SetConnectAttr 103 [1244]PGAPI_SetConnectOption: entering fOption = 103 vParam = 20 [1244][[SQLGetConnectAttr]] 30002 [1244]PGAPI_GetConnectAttr 30002 [1244]PGAPI_GetConnectOption: entering... [1244]CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption0002', errnum 5, errmsg='Unknown connect option (Get)' [1244][[SQLSetConnectAttr]] 30002 [1244]PGAPI_SetConnectAttr 30002 [1244]PGAPI_SetConnectOption: entering fOption = 30002 vParam = 122428760 [1244]Microsoft Jet !!!! [1244][SQLDriverConnect][1244]PGAPI_DriverConnect: entering... [1244]**** PGAPI_DriverConnect: fDriverCompletion=1, connStrIn='DSN=testing7.4.2;' [1244]our_connect_string = 'DSN=testing7.4.2;' [1244]attribute = 'DSN', value = 'testing7.4.2' [1244]copyAttributes: DSN='testing7.4.2',server='',dbase='',user='',passwd='xxxxx',port='',onlyrea d='',protocol='',conn_settings='',disallow_premature=-1) [1244]globals.extra_systable_prefixes = 'pg_;' [1244]our_connect_string = 'DSN=testing7.4.2;' [1244]attribute = 'DSN', value = 'testing7.4.2' [1244]CopyCommonAttributes: A70;A8@96;A9=0;B0%4;B190;B2=1;B3=1;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C 0=1;C1=0;C2=pg_;[1244]CC_connect: entering... [1244]CC_connect(): DSN = 'testing7.4.2', server = 'balappserver', port '5432', database = 'zuecht', username = 'albin', password='xxxxx' [1244]connecting to the server socket... [1244]connection to the server socket succeeded. [1244]sizeof startup packet = 292 [1244]sent the authentication block. [1244]sent the authentication block successfully. [1244]gonna do authentication [1244]read 9, global_socket_buffersize@96 [1244]auth got 'R' [1244]areq = 5 [1244]in AUTH_REQ_MD5 [1244]read 15, global_socket_buffersize@96 [1244]auth got 'R' [1244]areq = 0 [1244]auth got 'K' [1244]auth got 'Z' [1244]sending an empty query... [1244]send_query(): conn6066856, query=' ' [1244]send_query: done sending query [1244]in QR_Constructor [1244]exit QR_Constructor [1244]read 48, global_socket_buffersize@96 [1244]send_query: got id = 'N' [1244]~~~ NOTICE: 'LOG: Anweisung: ' [1244]send_query: got id = 'I' [1244]send_query: got id = 'N' [1244]~~~ NOTICE: 'LOG: Dauer: 0.246 ms ' [1244]send_query: got id = 'Z' [1244]got no result from the empty query. (probably database does not exist) [1244]QResult: in DESTRUCTOR [1244]QResult: free memory in, fcount=0 [1244]QResult: free memory out [1244]QResult: exit DESTRUCTOR [1244]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum5, errmsg='The database does not exist on the server or user authentication failed.' [1244][[SQLGetDiagRec]] [1244]PGAPI_GetDiagRec entering rec=1[1244]**** PGAPI_ConnectError: hdbc6066856 <0> [1244]enter CC_get_error [1244]enter CC_create_errormsg [1244]msg = 'The database does not exist on the server or user authentication failed.' [1244]exit CC_create_errormsg [1244]exit CC_get_error [1244]CC_get_error: status = 105, msg = #The database does not exist on the server or user authentication failed.# [1244] szSqlState = 'S1000',lenr, szError='(null)' [1244]PGAPI_GetDiagRec exiting 1 [1244][[SQLGetDiagRec]] [1244]PGAPI_GetDiagRec entering rec=1[1244]**** PGAPI_ConnectError: hdbc6066856 <74> [1244]enter CC_get_error [1244]exit CC_get_error [1244]CC_get_error: status = 105, msg = #The database does not exist on the server or user authentication failed.# [1244] szSqlState = 'S1000',lenr, szError='The database does not exist on the server or user authentication failed.' [1244]PGAPI_GetDiagRec exiting 0 [1244][[SQLGetDiagField]] Handle=(2,81c3728) Rec=1 Id=8 [1244]PGAPI_GetDiagField entering rec=1[1244]PGAPI_GetDiagField exiting 0 [1244][[SQLGetDiagField]] Handle=(2,81c3728) Rec=1 Id=9 [1244]PGAPI_GetDiagField entering rec=1[1244]PGAPI_GetDiagField exiting 0 [1244][[SQLGetDiagField]] Handle=(2,81c3728) Rec=1 Id [1244]PGAPI_GetDiagField entering rec=1[1244]PGAPI_GetDiagField exiting 0 [1244][[SQLGetDiagField]] Handle=(2,81c3728) Rec=1 Id [1244]PGAPI_GetDiagField entering rec=1[1244]PGAPI_GetDiagField exiting 0 [1244][[SQLGetDiagRec]] [1244]PGAPI_GetDiagRec entering rec=2[1244]**** PGAPI_ConnectError: hdbc6066856 <0> [1244]PGAPI_GetDiagRec exiting 100 [1244][[SQLFreeHandle]][1244]PGAPI_FreeConnect: entering... [1244]**** in PGAPI_FreeConnect: hdbc6066856 [1244]enter CC_Destructor, self6066856 [1244]in CC_Cleanup, self6066856 [1244]after CC_abort [1244]SOCK_Destructor [1244]after SOCK destructor [1244]exit CC_Cleanup [1244]after CC_Cleanup [1244]after free statement holders [1244]exit CC_Destructor [1244]PGAPI_FreeConnect: returning... [1244][[SQLFreeHandle]][1244]**** in PGAPI_FreeEnv: env = 136060816 ** [1244]in EN_Destructor, self6060816 [1244]exit EN_Destructor: rv = 1 [1244] ok -- ************************************************************************ ** Albin Blaschka, Mag. rer. nat. ** SURE - Successful Restoration and Rehabilitation ** Accompanying Infrastructural Interventions ** BAL Gumpenstein - Federal Research Institute for alpine Regions ** Tel.: ++43 (0)3682 / 22451 - 244 ** No trees were killed in the creation of this message. ** However, many electrons were terrible inconvenienced. ************************************************************************