Thread: ForwardOnly ?

ForwardOnly ?

From
Petr Odložil
Date:
Hello,

  I'm using some Control and Visualization tool ControlWeb for my
aplication and saving information into the Postgres database through the
ODBC driver.
SQL queries works fine, but when I was to move through the open set of
records using the procedures of the Control Web
a did get following message :
  The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly
cursor

is there any help about it ?

thanks a lot

Petr


--
Odchozi zprava neobsahuje viry.
Zkontrolovano Antivirovym systemem AVG.
Verze: 7.0.308 / Virova baze: 266.10.2 - datum vydani: 21.4.2005


Re: ForwardOnly ?

From
lothar.behrens@lollisoft.de
Date:
Am 22 Apr 2005 um 14:46 hat Petr Odložil geschrieben:

> Hello,
>
>   I'm using some Control and Visualization tool ControlWeb for my
> aplication and saving information into the Postgres database through the
> ODBC driver.
> SQL queries works fine, but when I was to move through the open set of
> records using the procedures of the Control Web
> a did get following message :
>   The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly
> cursor
>
> is there any help about it ?

Do you have set forward cursors only in ODBC configuration ?
I can use it with success, but I don't know about ControlWeb.

Lothar
>
> thanks a lot
>
> Petr
>
>
> --
> Odchozi zprava neobsahuje viry.
> Zkontrolovano Antivirovym systemem AVG.
> Verze: 7.0.308 / Virova baze: 266.10.2 - datum vydani: 21.4.2005
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


--
Lothar Behrens        www.lollisoft.de
Rosmarinstr 3        My public project:
40235 Düsseldorf      http://sourceforge.net/projects/lbdmf




Re: ForwardOnly ?

From
Petr Odložil
Date:
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 windows and I looked to
the system registry to the ODBC.INI section and there was nothing
simillar. Is somewhere a guide for this detailed ODBC driver configuration ?

thanks

Petr

>>Hello,
>>
>>  I'm using some Control and Visualization tool ControlWeb for my
>>aplication and saving information into the Postgres database through the
>>ODBC driver.
>>SQL queries works fine, but when I was to move through the open set of
>>records using the procedures of the Control Web
>>a did get following message :
>>  The fetch type for PGAPI_ExtendedFetch isn't allowed with ForwardOnly
>>cursor
>>
>>is there any help about it ?
>
>
> Do you have set forward cursors only in ODBC configuration ?
> I can use it with success, but I don't know about ControlWeb.
>
> Lothar
>


thanks a lot
>>
>>Petr
>>
>>
>>--
>>Odchozi zprava neobsahuje viry.
>>Zkontrolovano Antivirovym systemem AVG.
>>Verze: 7.0.308 / Virova baze: 266.10.2 - datum vydani: 21.4.2005
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 4: Don't 'kill -9' the postmaster
>>
>
>
>
> --
> Lothar Behrens        www.lollisoft.de
> Rosmarinstr 3        My public project:
> 40235 Düsseldorf      http://sourceforge.net/projects/lbdmf
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>


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


Re: ForwardOnly ?

From
Jeff Eckermann
Date:
--- Petr Odlo�il <odlozil@trakceol.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.

> windows and I looked to
> the system registry to the ODBC.INI section and
> there was nothing
> simillar. Is somewhere a guide for this detailed
> ODBC driver configuration ?

The best information I am aware of is here:
http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config

>
> thanks
>
> Petr
>
> >>Hello,
> >>
> >>  I'm using some Control and Visualization tool
> ControlWeb for my
> >>aplication and saving information into the
> Postgres database through the
> >>ODBC driver.
> >>SQL queries works fine, but when I was to move
> through the open set of
> >>records using the procedures of the Control Web
> >>a did get following message :
> >>  The fetch type for PGAPI_ExtendedFetch isn't
> allowed with ForwardOnly
> >>cursor
> >>
> >>is there any help about it ?
> >
> >
> > Do you have set forward cursors only in ODBC
> configuration ?
> > I can use it with success, but I don't know about
> ControlWeb.
> >
> > Lothar
> >
>
>
> thanks a lot
> >>
> >>Petr
> >>
> >>
> >>--
> >>Odchozi zprava neobsahuje viry.
> >>Zkontrolovano Antivirovym systemem AVG.
> >>Verze: 7.0.308 / Virova baze: 266.10.2 - datum
> vydani: 21.4.2005
> >>
> >>
> >>---------------------------(end of
> broadcast)---------------------------
> >>TIP 4: Don't 'kill -9' the postmaster
> >>
> >
> >
> >
> > --
> > Lothar Behrens        www.lollisoft.de
> > Rosmarinstr 3        My public project:
> > 40235 D�sseldorf
> http://sourceforge.net/projects/lbdmf
> >
> >
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
> >
> >
>
>
> --
> Odchoz� zpr�va neobsahuje viry.
> Zkontrolov�no Antivirov�m syst�mem AVG.
> Verze: 7.0.308 / Virov� b�ze: 266.10.2 - datum
> vyd�n�: 21.4.2005
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please
> send an appropriate
>       subscribe-nomail command to
> majordomo@postgresql.org so that your
>       message can get through to the mailing list
> cleanly
>

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: ForwardOnly ?

From
lothar.behrens@lollisoft.de
Date:
Am 25 Apr 2005 um 8:00 hat Jeff Eckermann geschrieben:

> --- Petr Odložil <odlozil@trakceol.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



Re: ForwardOnly ?

From
Petr Odložil
Date:
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.behrens@lollisoft.de wrote:
> Am 25 Apr 2005 um 8:00 hat Jeff Eckermann geschrieben:
>
>
>>--- Petr Odložil <odlozil@trakceol.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@postgresql.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