From: | "Jeff Martin" <jeff(at)dgjc(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Can't get ODBC from Windows to Linux/Postgres to work |
Date: | 2002-03-11 23:03:35 |
Message-ID: | NEBBLNMDMLIJEILLDFNBCEJLCGAA.jeff@dgjc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
My clients need to access PostgreSQL data from their windows box.
Trying to get ODBC to work from Windows to Linux/PostgreSQL.
I have done the following:
1. configured and compiled PostgreSQL with the --enable-odbc flag
2. installed psqlodbc-07_01_0009.zip on my windows box from
odbc.postgresql.org
3. executed the command "psql -d template1 -f pgsql/share/odbc.sql
4. rebuilt my database.
5. created a new ODBC source on my windows bow pointing to my Linux
machine and PostgreSQL database.
I get the following error when trying to connect to the ODBC source from MS
Access
ODBC call failed:
Could not connect to the server.
Could not connect to the remote socket. (#101)[Microsoft][ODBC Driver
Manager]Connection not open(#0)
What step am I missing here? Thanks for any help.
Jeff
Jeff Martin
704 Torrey Lane, Apartment D
Boalsburg, PA 16827
H814-466-7791
jeff(at)dgjc(dot)org
www.dgjc.org
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-03-11 23:04:23 | Re: pg_toast table growth out of control |
Previous Message | Matthew Hixson | 2002-03-11 23:03:13 | Postgres on Apple hardware? |