Home > mailing lists

Can't get ODBC from Windows to Linux/Postgres to work - Mailing list pgsql-general

From	Jeff Martin
Subject	Can't get ODBC from Windows to Linux/Postgres to work
Date	March 11, 2002 18:02:34
Msg-id	NEBBLNMDMLIJEILLDFNBCEJLCGAA.jeff@dgjc.org Whole thread Raw
Responses	Re: Can't get ODBC from Windows to Linux/Postgres to work Re: Can't get ODBC from Windows to Linux/Postgres to work Automatic mod time? Automatic mod time?
List	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@dgjc.org
www.dgjc.org

From: "Peter Darley"
Date: 11 March 2002, 17:33:23
Subject: Stale temp tables

From: Joel Burton
Date: 11 March 2002, 18:14:19
Subject: Re: Can't get ODBC from Windows to Linux/Postgres to work