|
I successfully installed the PostgreSQL ODBC driver, and got Access to link
to a table as external data.
It took me a while to figure out what the proper parameters might be in
configuring the ODBC
in the control panel in Administrative Tools, and then to fill in the
proper fields in Access when defining the external data linked table.
In Administrative Tools, ODBC, the Database name is the database I created
in Postgresql, which I called lantimes. The Server was a REAL MYSTERY,
until I read something in google which suggested that it should be
localhost.
I was in despair for a while, until I saw it suddenly work.
Another problem I encountered, in the two tables I created in pgAdmin III ,
involves two different numeric fields, where I get the message from Access
"Field is of type MONEY but _expression_ is double precision."
The field was defined in the sql statement in PostgreSQL as MONEY. I was simply
copying an exercise from a SQL primer. Should I not use MONEY in defining
such fields to be used with ACCESS? Is there a different TYPE that I should use
in my definition? Thanks!
By the way, what would you suggest as a tool to administer the PostgreSQL
databases. I mean, something sort of graphical which would display tables and
names and relationships.
|
