error connecting to PostgreSQL database

From: "Bob Nix" <bnix(at)Intranexus(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: error connecting to PostgreSQL database
Date: 2003-08-20 13:44:06
Message-ID: BB29A9AD081CFE448883C92B463173C9399887@mail.intranexus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Here's the problem: I can connect to PostgresSQL through Crystal Reports. I could connect without problems last week. I can connect to PostgreSQL through EMS Postgres Manager; and through phppgadmin. I have documented the information below. I have rebooted, deleted and reinstalled the ODBC driver, tried it with nothing else running - no success. I am running Windows 2000, all patches installed; Norton AntiVirus is current.

* your ODBC driver version ==== 7.03.01.00
* your PostgreSQL database version === 7.3.2
* any error messages you saw on the screen
* last week, no error when connecting to Crystal Reports; now, I get
Logon failed
Details: 08001: Could not connect to the server;
Socket is already connected
* the commlog(psqlodbc_????.log) file (you will have to enable the commlog driver option)
C:\>type psqlodbc_616.log
DSN info: DSN='PostgresDemo',server='10.1.31.48',port='5432',dbase='public.demo',user='bnix',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
DSN info: DSN='PostgresDemo',server='10.1.31.48',port='5432',dbase='public.demo',user='bnix',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''

C:\>
* the ODBC trace log (sql.log) file (if the problem warrants it)

C:\>type mylog_616.log
[436]globals.extra_systable_prefixes = 'dd_;'
[436][[SQLAllocHandle]][436]**** in PGAPI_AllocEnv **
[436]** exit PGAPI_AllocEnv: phenv = 70393744 **
[436][[SQLSetEnvAttr]] att=200,3
[436][[SQLAllocHandle]][436]PGAPI_AllocConnect: entering...
[436]**** PGAPI_AllocConnect: henv = 70393744, conn = 70400184
[436]EN_add_connection: self = 70393744, conn = 70400184
[436] added at i =0, conn->henv = 70393744, conns[i]->henv = 70393744
[436][SQLGetInfo(30)][436]PGAPI_GetInfo: entering...fInfoType=77
[436]PGAPI_GetInfo: p='03.00', len=0, value=0, cbMax=12
[436][[SQLSetConnectAttr]] 101
[436]PGAPI_SetConnectAttr 101
[436]PGAPI_SetConnectOption: entering fOption = 101 vParam = 1
[436][SQLConnect][436]PGAPI_Connect: entering...
[436]globals.extra_systable_prefixes = 'dd_;'
[436]globals.extra_systable_prefixes = 'dd_;'
[436][[SQLAllocHandle]][436]**** in PGAPI_AllocEnv **
[436]** exit PGAPI_AllocEnv: phenv = 70393744 **
[436][[SQLSetEnvAttr]] att=200,3
[436][[SQLAllocHandle]][436]PGAPI_AllocConnect: entering...
[436]**** PGAPI_AllocConnect: henv = 70393744, conn = 70400184
[436]EN_add_connection: self = 70393744, conn = 70400184
[436] added at i =0, conn->henv = 70393744, conns[i]->henv = 70393744
[436][SQLGetInfo(30)][436]PGAPI_GetInfo: entering...fInfoType=77
[436]PGAPI_GetInfo: p='03.00', len=0, value=0, cbMax=12
[436][[SQLSetConnectAttr]] 101
[436]PGAPI_SetConnectAttr 101
[436]PGAPI_SetConnectOption: entering fOption = 101 vParam = 1
[436][SQLConnect][436]PGAPI_Connect: entering...
[436]globals.extra_systable_prefixes = 'dd_;'

C:\>

Bob Nix, Technical Analyst
IntraNexus, Inc.
bnix(at)intranexus(dot)com
336-282-4415 Fax: 509-355-2669

Browse pgsql-odbc by date

  From Date Subject
Next Message Andre Felipe Machado 2003-08-20 17:13:42 Re: large objects and pg 7.3.x with OpenOffice.org
Previous Message Hiroshi Inoue 2003-08-20 13:05:07 Re: ODBC Open cursors on views