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
<mh@pixar.com> To: Postgresql-General <pgsql-general@postgresql.org>
Sent by: cc:
Subject: [GENERAL] accessing postgresql via odbc?
pgsql-general-owner@pos |-------------------|
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
----------------------------------------------------------------------------------------------