Re: Oracle Heterogenous Services Error - Mailing list pgsql-odbc

----- Original Message -----


Subject: Re: [ODBC] Oracle Heterogenous Services Error


From: "Ludek Finstrle" <luf@pzkagis.cz>


Date: Wed, June 21, 2006 13:15





> > We are able to connect via sql server to postgres. Also, we are
> > providing the username in lowercase, the Oracle error always
> > returns it in uppercase.
>
> Could you get the exact connection string?
> Could you post here the mylog output?
>
> ----- End of original Message -----
>
> Here's the trace file from Oracle, does this help?

No, I see no connection string for psqlodbc. Please could you post
mylog output?

Regards,

Luf


The mylog output is listed below:

Thanks for your help with this...


{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0
Courier New;}{\f1\fswiss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.15.1503;}\viewkind4\uc1\pard\f0\fs20
[4168]globals.extra_systable_prefixes = 'dd_;'\par
[4168][[SQLAllocHandle]][4168]**** in PGAPI_AllocEnv ** \par
[4168]** exit PGAPI_AllocEnv: phenv = 13e1f90 **\par
[4168][[SQLSetEnvAttr]] att=200,2\par
[4168][[SQLAllocHandle]][4168]PGAPI_AllocConnect: entering...\par
[4168]**** PGAPI_AllocConnect: henv = 13e1f90, conn = 13e39d0\par
[4168]EN_add_connection: self = 13e1f90, conn = 13e39d0\par
[4168]       added at i =0, conn->henv = 13e1f90, conns[i]->henv =
13e1f90\par
[4168][SQLGetInfoW(30)][4168]PGAPI_GetInfo: entering...fInfoType=77\par
[4168]PGAPI_GetInfo: p='03.51', len=0, value=0, cbMax=12\par
[4168][SQLSetConnectAttrW][4168]PGAPI_SetConnectAttr 115 1\par
[4168]the application is ansi\par
[4168][SQLDriverConnectW][4168]PGAPI_DriverConnect: entering...\par
[4168]**** PGAPI_DriverConnect: fDriverCompletion=0,
connStrIn='DSN=KAM_FINAL;UID=PGADMIN;PWD=xxxxxxx;'\par
[4168]our_connect_string = 'DSN=KAM_FINAL;UID=PGADMIN;PWD=xxxxxxx;'\par
[4168]attribute = 'DSN', value = 'KAM_FINAL'\par
[4168]copyAttributes:

DSN='KAM_FINAL',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)\par
[4168]attribute = 'UID', value = 'PGADMIN'\par
[4168]copyAttributes:

DSN='KAM_FINAL',server='',dbase='',user='PGADMIN',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)\par
[4168]attribute = 'PWD', value = 'xxxxx'\par
[4168]copyAttributes:

DSN='KAM_FINAL',server='',dbase='',user='PGADMIN',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)\par
[4168]getDSNinfo: DSN=KAM_FINAL overwrite=0\par
[4168]globals.extra_systable_prefixes = 'dd_;'\par
[4168]rollback_on_error=-1\par
[4168]globals.extra_systable_prefixes = 'dd_;'\par
[4168]our_connect_string = 'DSN=KAM_FINAL;UID=PGADMIN;PWD=xxxxxxx;'\par
[4168]attribute = 'DSN', value = 'KAM_FINAL'\par
[4168]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[4168]attribute
= 'UID', value = 'PGADMIN'\par
[4168]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[4168]attribute
= 'PWD', value = 'xxxxx'\par
[4168]CopyCommonAttributes:
A7=100;A8=4096;A9=0;B0=254;B1=8190;B2=1;B3=1;B4=1;B5=1;B6=0;B7=1;B8=0;B9=1;C0=0;C1=0;C2=dd_;[4168]calling
getDSNdefaults\par
[4168]CC_connect: entering...\par
[4168]sslmode=disable\par
[4168]original_CC_connect: entering...\par
[4168]original_CC_connect: DSN = 'KAM_FINAL', server = 'casanblol01', port
= '5433', database = 'testdb', username = 'PGADMIN', password='xxxxx'\par
[4168]connecting to the server socket...\par
[4168]connection to the server socket succeeded.\par
[4168]sizeof startup packet = 99\par
[4168]sent the authentication block.\par
[4168]sent the authentication block successfully.\par
[4168]gonna do authentication\par
[4168]read 13, global_socket_buffersize=4096\par
[4168]auth got 'R'\par
[4168]areq = 5\par
[4168]in AUTH_REQ_MD5\par
[4168]read 97, global_socket_buffersize=4096\par
[4168]auth got 'E'\par
[4168]original_CC_connect: 'E' - SFATAL\par
[4168]original_CC_connect: 'E' - C28000\par
[4168]original_CC_connect: 'E' - Mpassword authentication failed for user
"PGADMIN"\par
[4168]original_CC_connect: 'E' - Fauth.c\par
[4168]original_CC_connect: 'E' - L337\par
[4168]original_CC_connect: 'E' - Rauth_failed\par
[4168]CONN ERROR: func=original_CC_connect, desc='', errnum=210,
errmsg='FATAL: password authentication failed for user "PGADMIN"'\par
[4168]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=210, errmsg='FATAL: password authentication failed for user
"PGADMIN"'\par
[4168][SQLGetDiagRecW][4168]PGAPI_GetDiagRec entering type=2 rec=1\par
[4168]**** PGAPI_ConnectError: hdbc=13e39d0 <0>\par
[4168]enter CC_get_error\par
[4168]enter CC_create_errormsg\par
[4168]msg = 'FATAL: password authentication failed for user "PGADMIN"'\par
[4168]exit CC_create_errormsg\par
[4168]exit CC_get_error\par
[4168]CC_get_error: status = 210, msg = #FATAL: password authentication
failed for user "PGADMIN"#\par
[4168]\tab      szSqlState = '28000',len=56, szError='(null)'\par
[4168]PGAPI_GetDiagRec exiting 1\par
[4168][SQLGetDiagRecW][4168]PGAPI_GetDiagRec entering type=2 rec=1\par
[4168]**** PGAPI_ConnectError: hdbc=13e39d0 <58>\par
[4168]enter CC_get_error\par
[4168]exit CC_get_error\par
[4168]CC_get_error: status = 210, msg = #FATAL: password authentication
failed for user "PGADMIN"#\par
[4168]\tab      szSqlState = '(null)',len=56, szError='FATAL: password
authentication failed for user "PGADMIN"'\par
[4168]PGAPI_GetDiagRec exiting 0\par
[4168][[SQLGetDiagFieldW]] Handle=(2,13e39d0) Rec=1 Id=8
info=(12d6f0,256)\par
[4168]PGAPI_GetDiagField entering rec=1[4168]PGAPI_GetDiagField exiting 0\par
[4168][[SQLGetDiagFieldW]] Handle=(2,13e39d0) Rec=1 Id=9
info=(12d6f0,256)\par
[4168]PGAPI_GetDiagField entering rec=1[4168]PGAPI_GetDiagField exiting 0\par
[4168][[SQLGetDiagFieldW]] Handle=(2,13e39d0) Rec=1 Id=10
info=(12d6f0,256)\par
[4168]PGAPI_GetDiagField entering rec=1[4168]PGAPI_GetDiagField exiting 0\par
[4168][[SQLGetDiagFieldW]] Handle=(2,13e39d0) Rec=1 Id=11
info=(12d6f0,256)\par
[4168]PGAPI_GetDiagField entering rec=1[4168]PGAPI_GetDiagField exiting 0\par
[4168][SQLGetDiagRecW][4168]PGAPI_GetDiagRec entering type=2 rec=2\par
[4168]**** PGAPI_ConnectError: hdbc=13e39d0 <0>\par
[4168]PGAPI_GetDiagRec exiting 100\par
[4168][[SQLFreeHandle]][4168]PGAPI_FreeConnect: entering...\par
[4168]**** in PGAPI_FreeConnect: hdbc=13e39d0\par
[4168]enter CC_Destructor, self=13e39d0\par
[4168]in CC_Cleanup, self=13e39d0\par
[4168]after CC_abort\par
[4168]SOCK_Destructor\par
[4168]after SOCK destructor\par
[4168]exit CC_Cleanup\par
[4168]after CC_Cleanup\par
[4168]after free statement holders\par
[4168]exit CC_Destructor\par
[4168]PGAPI_FreeConnect: returning...\par
[4168][[SQLFreeHandle]][4168]**** in PGAPI_FreeEnv: env = 13e1f90 ** \par
[4168]in EN_Destructor, self=13e1f90\par
[4168]exit EN_Destructor: rv = 1\par
[4168]   ok\par
[4168]DETACHING PROCESS\par
\par
\f1\par
}