Re: SQL server application porting headache - Mailing list pgsql-general

From Hiroshi Inoue
Subject Re: SQL server application porting headache
Date
Msg-id 3D17E769.43B6407A@tpf.co.jp
Whole thread Raw
In response to SQL server application porting headache  (Oskar Berggren <beo@sgs.o.se>)
List pgsql-general
Oskar Berggren wrote:
>
> Hiroshi Inoue wrote:
> > Oskar Berggren wrote:
> >
> >>Hi,
> >>
> >>I have a Windows application (not written by myself) that uses ODBC to
> >>connect to the database. It was developed using MS Access and SQL Server
> >>as the database. However, we would like to run it using PostgreSQL
> >>as database engine. While trying to do this I have run into some
> >>problems:
> >>
> >>     1.  The PostgreSQL ODBC driver from odbc.postgresql.org doesn't
> >>         seem to support dynasets (which I believe require keyset-driven
> >>         cursors). Is there any work on supporting this?
> >
> >
> > Please try the snapshot dll at http://w2422.nsk.ne.jp/~inoue/
> > with checking the *(Trial) Updatable cursors* option.
> >
>
> I already have; it didn't work. This was with the ODBC3 driver
> included in the package from odbc.postgresql.org. Perhaps the
> snapshot you are mentioning are much never?

Possibly. Keyset-driven cursors were implemented recently.

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/



pgsql-general by date:

Previous
From: Gregory Seidman
Date:
Subject: Re: Proxy Server ...
Next
From: Bruce Momjian
Date:
Subject: Re: Astonishing explain...!