odbc?

From: "Brent Waldrop" <waldrop_brent(at)hotmail(dot)com>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: odbc?
Date: 1999-06-13 08:28:05
Message-ID: 19990613082557.97125.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas Lockhart 1999-06-13 15:45:52 Re: [INTERFACES] hacked unixodbc driver..
Previous Message Brent Waldrop 1999-06-13 06:11:20 odbc update problems?