Can't get ODBC from Windows to Linux/Postgres to work
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
At 3/11/02 4:17 PM, pgsql-general-owner@postgresql.org wrote:
I think the problem is here. The documentation within the pg_hba.conf
file suggests that all TCP/IP connections need to use IDENT authentication.
I just turned on the ident deamon on the Linux box hosting the database,
but still can't make the connection. Anyone know more about ident
authentication with the postgres database?
With Red Hat Linux 7.2, I found that the default in /etc/identd.conf is
now:
result:encrypt = yes
I had to change that to:
result:encrypt = no
... and restart identd to get Postgres to work with IDENT.
Hope that helps.
--
Robert L Mathews, Tiger Technologies
"The trouble with doing something right the first time is that nobody
appreciates how difficult it was."
Import Notes
Resolved by subject fallback