From: | U K Laxmi <laxmiuk(at)yahoo(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com>, lothar(dot)behrens(at)lollisoft(dot)de |
Cc: | "Pgsql-Odbc(at)Postgresql(dot)Org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | unsubscribe |
Date: | 2005-02-24 12:01:12 |
Message-ID: | 20050224120112.55899.qmail@web20022.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
--- Richard Huxton <dev(at)archonet(dot)com> wrote:
> lothar(dot)behrens(at)lollisoft(dot)de wrote:
> > Hi,
> >
> > is there really no answer for me ?
>
> I'm not sure the question was clear.
>
> > I have the following problem under Linux:
> >
> > I use SQLSetpos to update data at current cursor
> position with SQL_UPDATE.
> > I get back an error message, that only
> SQL_POSITION/REFRESH is supported.
>
> > Does this limitation come from your ODBC driver or
> is it limited by unixODBC ?
>
> > Or, how must I activate these functionality while
> building it from sources ?
> > With your windows ODBC driver (version 7.3.200), I
> do not have these problems.
>
> So - "SQLSetpos+SQL_UPDATE" works with the ODBC
> driver under Windows.
> It doesn't work under unixODBC on Suse 9.1
>
> Well, the ODBC driver is presumably the same - AFAIK
> the same code
> builds Windows and Unix versions. This suggests the
> problem lies elsewhere.
>
> Are you sure the SQL being executed is the same in
> both cases? Try
> turning on statement logging in PostgreSQL and
> check.
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>
__________________________________
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-02-24 15:56:01 | Re: New snapshot - 08.00.0005 |
Previous Message | Richard Huxton | 2005-02-24 11:47:54 | Re: (Fwd) SQLSetPos problem under Linux |