From: Fabio Nanni <f.nanni@albourne.com>
To: pgsql-interfaces@postgresql.org
Subject: MS Access problems
Date: Sat, 19 Aug 2000 00:27:16 +0300
Message-ID: <399DAA34.A4870D95@albourne.com> (raw)
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
Attachments:
psqlodbc.log.gz (application/x-gzip, 2.3K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: f.nanni@albourne.com
Subject: Re: MS Access problems
In-Reply-To: <399DAA34.A4870D95@albourne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox