From: Michael J Davis <michael.j.davis@tvguide.com>
To: 'Brent Waldrop' <waldrop_brent@hotmail.com>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] odbc?
Date: Mon, 14 Jun 1999 13:49:59 -0500
Message-ID: <93C04F1F5173D211A27900105AA8FCFC1455CC@lambic.prevuenet.com> (raw)
Look at my web site:
www.sevainc.com/Access
This talks about some of the issues I faced with Access97. I had to make
all currency data types a double in version 6.4 of Postgres. In version
6.5, the numeric data type is a much better choice. You will need to
re-establish your links after making data type changes. Access97 remembers
the data types of ODBC connections between sessions. As for primary keys,
both of the following need to be set up:
1) the ODBC driver needs to have the use unique keys option turned
on
2) you need to have a unique key index installed on each table.
I have not figured out how to automatically import relationships. I have
found that they are not necessary in most situation so I have chosen to
ignore them.
Thanks, Michael
> -----Original Message-----
> From: Brent Waldrop [SMTP:waldrop_brent@hotmail.com]
> Sent: Sunday, June 13, 1999 2:28 AM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] odbc?
>
> HI i have a couple of basic and specific questions about odbc access using
> Access 97. First of all, when i try to add a entry in my access database
> that is connected to my posgres database i get an error that says "ERROR:
> parser: attribute 'salary' is of type 'money' but expression is of type
> 'float8' you will need to rewrite or cast the expression how can i fix t
> his
> so that i am able to add entries to the postgres database? I directly
> linked
> these tables with the odbc driver for postgres. Second think is why would
> you ever want to include the OID section...i noticed there is a option to
> include it in the connection options of the ODBC driver and can't see why
> you would want to do this if your keys are set up properly? The next thing
> i
> want to ask is would you evern want to include the pg_* tables in your
> access database? I can't see why you would want to? and the last question
> is...is there anyway to import relationship type of data into access using
> the odbc driver so you don't have to set it up manually through access?
>
> thanks
> Brent
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: michael.j.davis@tvguide.com, waldrop_brent@hotmail.com
Subject: RE: [INTERFACES] odbc?
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC1455CC@lambic.prevuenet.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