From: | Fabio Nanni <f(dot)nanni(at)albourne(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | MS Access problems |
Date: | 2000-08-18 21:27:16 |
Message-ID: | 399DAA34.A4870D95@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hello all,
I have two problems in accessing a psql database via MS-Access-ODBC, and
I cannot find anything similar on the mailing list. I am a novice to
psql and ODBC, has anybody perhaps faced these problems?
The configuration was:
Client side:
- MS Access 97 SR-2 running on NT 4.0 (Build 1381: Service Pack 6)
- odbc driver version: 6.50.0000
Server side:
- postgresql database, version: 7.0.0
The problems are:
1. when linking a table, Access is unable to find automatically the
primary key and raises a dialog asking me to specify it.
I attached the tracelog file due to the linking of the table below:
Table "currencies"
Attribute | Type | Modifier
------------+---------+----------------------
curr | char(3) | not null
curr_name | text | not null
curr_quote | boolean | not null default '1'
Index: currencies_pkey
2. Access is unable to discover automatically
relations and foreign keys in the database.
Many thanks in advance
Fabio
Attachment | Content-Type | Size |
---|---|---|
psqlodbc.log.gz | application/x-gzip | 2.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Uckun | 2000-08-18 21:42:17 | Re: MS Access + Postgres |
Previous Message | Jim O'Rourke | 2000-08-18 14:58:51 | /tmp/.s.PGSQL.${PGPORT} |