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 10:45



Wed, Jun 21, 2006 at 11:29:28AM -0500, LLC napsal(a):
> 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?

Regards,

Luf

> ----- Original Message -----
>
>
> Subject: Re: [ODBC] Oracle Heterogenous Services Error
>
>
> From: "Ludek Finstrle" >;luf@pzkagis.cz>
>
>
> Date: Wed, June 21, 2006 2:15
>
>
>
>
>
> > I've setup a user 'pgadmin' for testing.  I've added an entry in the
> > pg_hba.conf file as follows:
>
> Here is username lowercase.
>
> > When we try and connect we get this error:
> >
> > (0) ORACLE GENERIC GATEWAY Log File Started at 2006-06-20T15:05:18
> > (0) hoainit (3): ; hoainit Exited with retcode = 0.
> > (0) hoalgon (7): ; hoalgon Entered. name = PGADMIN.
> > (0) DB_ODBC_INTERFACE (2085): ; FATAL: password authentication failed
> > for user
> > (0) "PGADMIN" (SQL State: 28000; SQL Code: 210
>
> Here is username uppercase. I think postgresql is case-sensitive.
> Could you connect via odbc the postgresql from another app?
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Here's the trace file from Oracle, does this help?

(0) hoagprd (2): ; hoagprd Entered.
(0) HOACONN.C (244): ; [Generic Connectivity Using ODBC] version:
4.6.1.0.0070
(0) HOACONN.C (295): ; Class version: 200
(0) hoagprd (2): ; hoagprd Exited with retcode = 0.
(0) hoainit (3): ; hoainit Entered.
(0)  (0): ; connect string is: defTdpName=hsodbc;SYNTAX=(ORACLE8_HOA,
(0) BASED_ON=ORACLE8, IDENTIFIER_QUOTE_CHAR="",
(0)
CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasourc
es><da-
(0) tasource name='hsodbc' type='ODBC'
(0)
connect='KAM_FINAL'><driverProperties/></datasource></datasources><remot
eMachi-
(0) nes/><environment><optimizer noFlattener='true'/><misc
year2000Policy='-1'
(0) consumerApi='1' sessionBehavior='4'/><queryProcessor
parserDepth='2000'
(0) tokenSize='1000' noInsertParameterization='true'
 noThreadedReadAhead='true'
(0) noCommandReuse='true'/><debug
(0) generalTrace='true'/></environment></binding></navobj>
(0) ORACLE GENERIC GATEWAY Log File Started at 2006-06-20T15:05:18
(0) hoainit (3): ; hoainit Exited with retcode = 0.
(0) hoalgon (7): ; hoalgon Entered. name = PGADMIN.
(0) DB_ODBC_INTERFACE (2085): ; FATAL: password authentication failed
for user
(0) "PGADMIN" (SQL State: 28000; SQL Code: 210)
(0) DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; FATAL: password
authentication failed
(0) for user "PGADMIN" (SQL State: 28000; SQL Code: 210)
(0)
(0) nvRETURN (F:\Work\Connect_4_6_3\src\drv\DRV_BIND.C 356): -2220
(0) nvRETURN (F:\Work\Connect_4_6_3\src\nav\NAV_BIND.C 293): -2220
(0) hoalgon (7): ; hoalgon Exited with retcode = 28500.
(0) hoaexit (6): ; hoaexit Entered.
(0) hoaexit (6): ; hoaexit Exited with retcode = 0.
(0)  (0): ; Closing log file at TUE JUN 20 15:05:19 2006.