From: David C Hartwig Jr <daybee@bellatlantic.net>
To: Michael Meskes <meskes@postgreSQL.org>
Cc: PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Access problems
Date: Mon, 20 Dec 1999 14:45:19 -0500
Message-ID: <385E874F.C8398C52@bellatlantic.net> (raw)
References: <19991220152353.A585@fam-meskes.de>
Michael Meskes wrote:
> I have installed onshore-timesheet on my machine. It works like a char. No I
> tried to access the database via M$ Access and found some problems. The ODBC
> connection is up and running. However, Access refuses to link in several
> tables.
>
> I attach the table definitions.
>
> It says the following attributes are not correct either in index or in
> relationship definition:
>
> table attribute
> -------------------------------
> category category_id
> hours del
> job downloaded
> notification fkpersonnel_id
> personnel personnel_id
>
> Only the client relation is okay.
>
> So far I wasn't able to see what's wrong with these. Maybe anyone on this
> list has an idea. Also ODBC logs don't show something special.
>
>
I am a bit rusty on the internals on the psqlODBC driver as it relates to MS
Access. But as I seem to recall, Access cannot have a key column over 256
bytes. Text columns are virtually unbounded. This may explain some of your
tables linking problems. If you can, try changing some of those primary key
fields to varchar(255) or smaller.
Ultimately what you need to do is activate the logging feature in the driver
and attach a minimalist failure log file.
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: daybee@bellatlantic.net, meskes@postgreSQL.org
Subject: Re: [INTERFACES] Access problems
In-Reply-To: <385E874F.C8398C52@bellatlantic.net>
* 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