Hi, I just did this myself (I'm a Unix/Linux person). Three steps: 1. Install the PostgreSQL ODBC driver on the Windows box. (download from http://www.postgresql.org/ftp/odbc/versions/msi/). 2. Configure the DSN on the Windows box: Go to Control Panel / Admin Tools / Data Sources (ODBC), Under the "System DSN" tab, click on "Add". Select "PostgreSQL" from the list. Fill in the form. 3. Tell your ODBC application to use the DSN you configured.
Worked like a charm for me.
Susan
Mark Harrison
<[EMAIL PROTECTED]> To:
Postgresql-General <pgsql-general@postgresql.org>
Sent by: cc:
Subject: [GENERAL]
accessing postgresql via odbc?
[EMAIL PROTECTED] |-------------------|
tgresql.org | [ ] Expand Groups |
|-------------------|
08/10/2005 12:15
PM
So, I've got pg running on a linux box, and I'm informed that a
windows box should be able to access this through ODBC, about
which I am woefully uninformed.
Can somebody loan me a clue as to what I should do to make
this happen?
Many TIA!
Mark
--
Mark Harrison
Pixar Animation Studios
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
----------------------------------------------------------------------------------------------
See our award-winning line of tape and disk-based
backup & recovery solutions at http://www.overlandstorage.com
----------------------------------------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
