Thread: psqlODBC and Access

psqlODBC and Access

From
Typing80wpm@aol.com
Date:
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.
 
 

Re: psqlODBC and Access

From
Hannes Dorbath
Date:
On 23.04.2005 03:23, Typing80wpm@aol.com wrote:
> 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!

 From http://www.postgresql.org/docs/8.0/interactive/datatype-money.html

"The money type is deprecated. Use numeric or decimal instead, in
combination with the to_char function."

> 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.

In case you don't like PgAdminIII you may try commercial products like

EMS PostgreSQL Manager
http://sqlmanager.net/products/postgresql/manager

What they call "Visual Database Designer" might just be what you are
looking for. It's an MS-Access-like, visual display of tables and
relations. But remember, it's a frontend and not a modelling tool.

For modelling better look at:

http://www.casestudio.com/

I don't think there's something better out there for the money, but it
takes some time to learn using it.

Re: psqlODBC and Access

From
Tony Caduto
Date:
Let's not forget about PG Lightning Admin :-)

http://www.amsoftwaredesign.com

>
> In case you don't like PgAdminIII you may try commercial products like
>
> EMS PostgreSQL Manager
> http://sqlmanager.net/products/postgresql/manager
>
> What they call "Visual Database Designer" might just be what you are
> looking for. It's an MS-Access-like, visual display of tables and
> relations. But remember, it's a frontend and not a modelling tool.
>
>