Problems connecting via ODBC - Mailing list pgsql-odbc
From | Eric J. Christeson |
---|---|
Subject | Problems connecting via ODBC |
Date | |
Msg-id | 20070605201029.GE18143@chicadee.cc.ndsu.nodak.edu Whole thread Raw |
List | pgsql-odbc |
I'm using libiodbc-3.52.5 and psqlodbc-08.02.0400 to connect to a server running PostgreSQL 8.1.5. When I run the iodbctest with the DSN I have set up, I get: 1: SQLDriverConnect = The database does not exist on the server or user authentication failed. (105) SQLSTATE=HY000 The database does exist and I'm able to connect fine via psql. I have logging turned on in Postgres and the connection is allowed vs. when I supply an incorrect password and the connection is denied. Relevent files follow. ; ; odbc.ini ; [ODBC Data Sources] pg_ldap=PostgreSQL [pg_ldap] Driver=PostgreSQL Description=Connection to LDAP/POSTGRESQL Servername=dummyserver.net Port=5432 Protocol=6.4 UserName=test Password=test Database=pg_ldap ReadOnly=no [ODBC] InstallDir=/usr/local/lib ; ; odbcinst.ini ; [PostgreSQL] Description=ODBC for PostgreSQL Driver=/usr/local/lib/psqlodbcw.so [ODBC] Trace=1 Debug=1 Pooling=No PostgreSQL log: DEBUG: forked new backend, pid=89606 socket=7 LOG: connection received: host=dummyserver.net port=56614 DEBUG: received password packet LOG: connection authorized: user=test database=pg_ldap DEBUG: postmaster child[89606]: starting with ( DEBUG: postgres DEBUG: -v131072 DEBUG: -p DEBUG: pg_ldap DEBUG: ) DEBUG: InitPostgres DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 115384/1/0, nestlvl: 1, children: <> DEBUG: CommitTransaction DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 115384/1/0, nestlvl: 1, children: <> DEBUG: StartTransactionCommand STATEMENT: DEBUG: StartTransaction STATEMENT: DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 115385/1/0, nestlvl: 1, children: <> STATEMENT: LOG: statement: STATEMENT: DEBUG: CommitTransactionCommand STATEMENT: DEBUG: CommitTransaction STATEMENT: DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 115385/1/0, nestlvl: 1, children: <> STATEMENT: LOG: duration: 1.117 ms statement: STATEMENT: DEBUG: proc_exit(0) DEBUG: shmem_exit(0) LOG: disconnection: session time: 0:00:00.00 user=test database=pg_ldap host=dummyserver.net port=56614 DEBUG: exit(0) DEBUG: reaping dead processes DEBUG: server process (PID 89606) exited with exit code 0 Any ideas? Thanks, Eric -- Eric J. Christeson <Eric.Christeson@ndsu.edu> Information Technology Services (701) 231-8693 (Voice) Room 242C, IACC Building North Dakota State University, Fargo, ND 58105-5164 PHP is a minor evil perpetrated and created by incompetent amateurs, whereas Perl is a great and insidious evil, perpetrated by skilled but perverted professionals. - Jon Ribbens
pgsql-odbc by date: