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@xxxxxxxxx> To: Postgresql-General <pgsql-general@xxxxxxxxxxxxxx> Sent by: cc: Subject: 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 ---------------------------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
