Postgres Pro
Downloads
Home   >   mailing lists

Thread: error connecting to PostgreSQL database

error connecting to PostgreSQL database

From
"Bob Nix"
Date:

    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