Skip site navigation (1) Skip section navigation (2)

Re: Oracle Heterogenous Services Error

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: LLC <kevin(at)kevinkempterllc(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Oracle Heterogenous Services Error
Date: 2006-06-21 16:45:57
Message-ID: 20060621164557.GE9181@soptik.pzkagis.cz (view raw or flat)
Thread:
Lists: pgsql-odbc
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(at)pzkagis(dot)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

In response to

pgsql-odbc by date

Next:From: LLCDate: 2006-06-21 18:01:37
Subject: Re: Oracle Heterogenous Services Error
Previous:From: LLCDate: 2006-06-21 16:29:28
Subject: Re: Oracle Heterogenous Services Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group