Re: ODBC Access from Visual Foxpro

Are you turning on *Recognize Unique Indexes* option ?

OTOH psqlodbc driver itself doesn't support updatable
cursors, so you need some means to access updatable
cursors like M$ DAO-Jet/ M$ ODBC cursor library...

I've tried (updatable) driver cursors a little
but gave up the plan due to a recent backend
change.

regards,
Hiroshi Inoue

Andrea Aime wrote:
>
> I have the same problem with the data access features of Autocad...
> is there anyone who has an idea? I've tried to track it down but
> without success...
> best regards
> Andrea Aime
>
> Marc Balmer wrote:
> >
> > Hi All and sorry if this is a FAQ...
> >
> > I am trying to access a PostgreSQL V 7.1.2 server with PsqlODBC from
> > Microsoft Visual Foxpro 5.0. The machine is MS Windows NT 4.0 SP 6.
> >
> > I can access the tables with no problem but only in read-only mode,
> > although
> > I unchecked the "read-only" checkbox in the ODB driver & datasource tabs.
> >
> > Any idea what I am doing wrong?
> >
> > Regards & Thanks,
> > Marc
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl