From: | Klaus Reimer <k(at)ailis(dot)de> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Connection to a unix domain socket |
Date: | 2001-04-09 15:13:29 |
Message-ID: | 0104091713290B.06741@neo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
I can connect via ODBC over TCP/IP to my postgresql database and I connect
WITHOUT ODBC over a Unix Domain socket to this database, but how can I
connect via ODBC over a Unix Domain socket to the database? It doesn't matter
what filename I specify with the SOCKET-Option. The connection is always made
but as soon as I exec a query I get this error message:
SQLAllocStmt: ErrorSQL error state code: 08003
[iODBC][Driver Manager]Connect not open
I think I specified the wrong ODBC Options. To connect via TCP/IP I use these
options:
DRIVER=/usr/lib/libodbcpsql.so.1
SERVER=localhost
PORT=5432
UID=xxxxxxxxx
PWD=xxxxxxxxx
DATABASE=test
ReadOnly=0
This is working fine. Now I tried to just remove the SERVER and PORT Options
to make a socket connection and I tried to specifiy this additional option:
SOCKET=/var/run/postgresql/.s.PGSQL.5432
But both tries failed with the above error message. I also wonder why the
SQLDriverConnect() isn't showing any errors. But SQLAllocStmt() says there is
no connect. The same code used with a mysql database (over unix-domain socket
specified with the SOCKET option) works fine.
Any hints? Please answer directly to my mail address, I am not subscribed to
the list.
- --
Bye, K
[a735 47ec d87b 1f15 c1e9 53d3 aa03 6173 a723 e391]
(Finger k(at)ailis(dot)de to get public key)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE60dGZqgNhc6cj45ERAtglAKDkCC6+G4aBp+12bos4YvCxen3yQACeNrpQ
+5n2TXOsy7SrGuM0PUp7qTY=
=lXLe
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-04-10 00:31:47 | Re: Connection to a unix domain socket |
Previous Message | Jean-Michel POURE | 2001-04-09 06:16:31 | Re: Help : serious problems with ODBC & Postgresql 7.1 RC2 &Access 2000 |