Can't get ODBC from Windows to Linux/Postgres to work

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

Responses

Browse pgsql-general by date

  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?