From: G. Anthony Reina <reina@nsi.edu>
To: Adolfo Diaz <adiaz@vega.inf.cu>
To: interfaces@postgreSQL.org <interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] psqlODBC/MS Access
Date: Wed, 25 Aug 1999 14:39:20 -0700
Message-ID: <37C46288.CD984EAD@nsi.edu> (raw)
References: <Pine.LNX.3.95.990825114606.10178B-100000@vega.inf.cu>
Adolfo Diaz wrote:
> I do not want to disturbe you, because I can not help you, but I am
> looking for the postODBC drivers. I will be so glad of you if you will had
> the kindness to send me the needing files and how to configure the ODBC
> connection.
>
> Thanks,
> Adolfo Diaz
>
Sure. You can find the postODBC driver on the www.postgresql.org site
(ftp://ftp.postgresql.org/pub/odbc/latest/postdrv.exe). The postdrv.exe
should be a self-extracting zip file which will auto-install the first time
you run it on your Windows machine. Once that's installed, go to the Windows
Start->Settings->Control Panel->32 bit ODBC. Hit the button called 'Add' to
add a new ODBC connection. You should get a window that asks for which driver
you want to use. Toward the bottom of the window, select the driver called
PostgreSQL (courtesy of Insight Distribution Systems). Then the postODBC
driver should cause another window to pop up asking you where the database is
located (IP address), its name, etc. You'll also have to configure your
$POSTGRES/.odbc.ini file on the database server. There's a sample file with
directions at http://www.postgresql.org/doxlist.html (the Programmer's
Manual). That file I think will allow you to control whether the database can
be written to over the ODBC connection. Once you have this done, all of ODBC
programs in windows should recognize this database.
The MS Access good directions in the on-line help about linking to an
external source via ODBC. Once you've got the postgres driver working, it
should be a piece of cake from there.
Let me know if you have any problems.
-Tony
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: reina@nsi.edu, adiaz@vega.inf.cu, interfaces@postgreSQL.org
Subject: Re: [INTERFACES] psqlODBC/MS Access
In-Reply-To: <37C46288.CD984EAD@nsi.edu>
* 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