Unix Technical Forum

Re: ForwardOnly ?

This is a discussion on Re: ForwardOnly ? within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> --- Petr Odložil <odlozil@trakceol.cz> wrote: > I din't set this option forward cursors only and I > even can't ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 02:09 AM
Jeff Eckermann
 
Posts: n/a
Default Re: ForwardOnly ?

--- 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/...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

---------------------------(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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:11 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com