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

Re: ForwardOnly ?

From: Petr Odložil <odlozil(at)trakceol(dot)cz>
To: lothar(dot)behrens(at)lollisoft(dot)de
Cc: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: ForwardOnly ?
Date: 2005-04-26 06:07:30
Message-ID: 426DDAA2.7030907@trakceol.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
I've tried both.

  to switch off the updateable cursors
  and to uninstall ODBC driver and install 7.3.2.

  but still the same problem.

I've looked into the psqlodbc_xxxx.log  and found this message :


conn=25181736, query='SELECT * FROM modules WHERE 
m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0  AND 
m_ip2=2 AND m_ip3 = 20 AND m_mb=2'
     [ fetched 7 rows ]
STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=13, 
errmsg='Invalid column number in ColAttributes.'
 
------------------------------------------------------------
                  hdbc=25181736, stmt=25202240, result=25202080
                  manual_result=0, prepare=0, internal=0
                  bindings=25203160, bindings_allocated=8
                  parameters=0, parameters_allocated=0
                  statement_type=0, statement='SELECT * FROM modules 
WHERE m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0  AND 
m_ip2=2 AND m_ip3 = 20 AND m_mb=2'
                  stmt_with_params='SELECT * FROM modules WHERE 
m_sname='KRASNE_LOUCKY' AND m_type=0 AND m_ip0=10 AND m_ip1=0  AND 
m_ip2=2 AND m_ip3 = 20 AND m_mb=2'
                  data_at_exec=-1, current_exec_param=-1, put_data=0
                  currTuple=-1, current_col=-1, lobj_fd=-1
                  maxRows=0, rowset_size=1, keyset_size=0, 
cursor_type=0, scroll_concurrency=1
                  cursor_name='SQL_CUR01808E40'
                  ----------------QResult Info 
-------------------------------
                  fields=25175672, manual_tuples=0, 
backend_tuples=25214360, tupleField=25214360, conn=25181736
                  fetch_count=0, num_total_rows=7, num_fields=8, 
cursor='(NULL)'
                  message='(NULL)', command='SELECT', notice='(NULL)'
                  status=8, inTuples=0
CONN ERROR: func=PGAPI_ColAttributes, desc='', errnum=0, errmsg='(NULL)'
             ------------------------------------------------------------
             henv=25181680, conn=25181736, status=1, num_stmts=16
             sock=25192736, stmts=25201016, lobj_type=-999
             ---------------- Socket Info -------------------------------
             socket=572, reverse=0, errornumber=0, errormsg='(NULL)'
             buffer_in=25192808, buffer_out=25196912
             buffer_filled_in=557, buffer_filled_out=0,buffer_read_in=557


In mylog_xxx.log I've found this
[1268][[SQLColAttribute]][1268]PGAPI_ColAttributes: entering..col=9 1011 
len=256.
[1268]SC_pre_execute: status = 3
[1268]**** PGAPI_ColAtt: result = 25202080, status = 3, numcols = 8
[1268]STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=13, 
errmsg='Invalid column number in ColAttributes.'
[1268]CONN ERROR: func=PGAPI_ColAttributes, desc='', errnum=0, 
errmsg='(NULL)'
[1268][SQLBindCol][1268]PGAPI_BindCol: entering...

and several lines down after that this :
[1268]PGAPI_ExtendedFetch: stmt=25202240
[1268]SQLFetchScroll return = -1
[1268][[SQLGetDiagRec]]
[1268]PGAPI_GetDiagRec entering rec=1[1268]**** PGAPI_StmtError: 
hstmt=25202240 <512>
[1268]SC_get_error: status = 33, msg = #The fetch type for 
PGAPI_ExtendedFetch isn't allowed with ForwardOnly cursor.#
[1268]	     szSqlState = 'S1106',len=77, szError='The fetch type for 
PGAPI_ExtendedFetch isn't allowed with ForwardOnly cursor.'
[1268]PGAPI_GetDiagRec exiting 0

Petr

lothar(dot)behrens(at)lollisoft(dot)de wrote:
> Am 25 Apr 2005 um 8:00 hat Jeff Eckermann geschrieben:
> 
> 
>>--- Petr Odložil <odlozil(at)trakceol(dot)cz> wrote:
>>
>>>I din't set this option forward cursors only and I
>>>even can't find it to
>>>check the state of it. I'm using ODBC driver for
>>
>>My understanding is that, if you want an updateable
>>cursor, it has to be forward only.  This is a
>>limitation of the PostgreSQL ODBC driver.  I believe
>>that the "updatable cursors" driver setting refers to
>>this.  But I'm only working from memory here; I could
>>not find a reference to this when I looked.  Someone
>>else please correct me as necessary.
> 
> 
> I use updateable cursors also when moving back.
> I do not remember, if it not works, when I move a row back
> after editing a row.
> 
> But I must say, that there will be a problem with the 8.x ODBC
> driver. Even reinstalling the old 7.3.200 version it didn't resolved
> it.
> This is because the install process may be brocken. I have removed
> the 8.x driver by hand, before reinstallation of 7.3.200.
> 
> The code for my ODBC abstraction classes are public. All can try it.
> See the link below.
> 
> Lothar
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 
> 


-- 
Odchozí zpráva neobsahuje viry.
Zkontrolováno Antivirovým systémem AVG.
Verze: 7.0.308 / Virová báze: 266.10.3 - datum vydání: 25.4.2005


In response to

pgsql-odbc by date

Next:From: andersen@modelcreatorDate: 2005-04-26 10:26:24
Subject: Serial
Previous:From: Typing80wpmDate: 2005-04-25 20:24:42
Subject: Toad Adm ODBC DSN connect questions

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