error connecting to PostgreSQL database - Mailing list 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@intranexus.com
336-282-4415   Fax: 509-355-2669