Re: psqlodbc MSAccess and Postgresql - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: psqlodbc MSAccess and Postgresql
Date
Msg-id d4b05v$19d7$1@news.hub.org
Whole thread Raw
In response to psqlodbc MSAccess and Postgresql  (Typing80wpm@aol.com)
List pgsql-general
<Typing80wpm@aol.com> wrote in message news:19f.324000cd.2f99d761@aol.com...
> Thanks for the help with /dt... Mike, your post helped me to discover psql
> command window, I had been trying out the pgAdmin ...
>
> I found an interesting article regarding MSAccess as a front end to
> Postgresql, so I downloaded the psqlodbc installer.  I will be getting up
> the nerve
> to run the install and go into windows odbc and install that driver so  I
> can
> use MSAccess with Postgresql ... any tips or caveats appreciated....

Be sure to check out the FAQs and How-tos at the psqlodbc project site:
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php

You will find that that Access and PostgreSQL get on well together.  You can
get by with the default driver settings for the most part; I suggest that
you make sure that the "row versioning" and "true = -1" options are set to
true.  If you want to use the "memo" datatype in Access, then you will need
to check "text = longvarchar" option.

If you have further questions, try posting to the pgsql-odbc list.

>
> This is the link which is guiding me....
> _http://database.sarang.net/database/postgres/postodbc/faq.html_
> (http://database.sarang.net/database/postgres/postodbc/faq.html)
>
>
>



pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Postgresql Windows ODBC
Next
From: Leandro Repolho
Date:
Subject: postgres user work with any password!