Re: Configuration of ODBC-driver

I have a similar setup as you (PostgreSQL 7.1.2, MS
Access 97 and psqlodbc).  However, I use Win98, not
NT.

I changed the odbc configuration as follows:

Advanced Options (Driver)
  Select "Recognize Unique Indexes"
  Select "Use Declare/Fetch"
  Deselect "Read Only"

Advanced Options (Data Source)
  Deselect "Read Only"

I _strongly_ advise that you select "Use
Declare/Fetch".  It will prevent some queries from
timing out due to memory limitations.

Primary keys are recognized on my system
automatically.

Caveats:
1.  Primary keys are lost when exporting an Access
table to PostgreSQL.  You'll have to create unique
indexes.
2.  If you drop your indexes to speed up copying,
remember to recreate them.

I hope this helps,

Andrew Gould

--- "Tille, Andreas" <TilleA@rki.de> wrote:
> Hello,
>
> I�ve got the Win-ODBC driver for postgres from
>
>
>
ftp://ftp.de.postgresql.org/pub/odbc/versions/dll/psqlodbc-07_01_0005.zip
>
> It works well with Postgres 7.1.  I just have the
> problem that the
> information about primary indexes is not transmitted
> to Access if I
> want to do a connection to external tables.  I
> checked the box
> named "Recognize Unique Indexes" in the drivers
> "Advanced Options"
> dialog but Access seems to take no notice and every
> time asks me
> which fields can be used a unique index.  That�s
> quite boring and
> I wonder if there are any other fields to change to
> get the information
> right.
>
> System Information:
>   Server: Debian GNU/Linux with PostgreSQL 7.1.2
>   Client: Win NT, Access 97 (if you need more
> detailed information about
>           this box please ask - I�m very seldom on
> those kind of machines
>           and don�t know what could be relevant)
>
> Kind regards
>
>          Andreas.
>
> PS: Is this the right list for those kind of
> questions.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/