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

From Ludek Finstrle
Subject Re: Oracle Heterogenous Services Error
Date
Msg-id 20060622160728.GB25481@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Oracle Heterogenous Services Error  ("LLC" <kevin@kevinkempterllc.com>)
List pgsql-odbc
> The mylog output is listed below:
>
> Thanks for your help with this...
>
>
> [4168][SQLDriverConnectW][4168]PGAPI_DriverConnect: entering...\par
> [4168]**** PGAPI_DriverConnect: fDriverCompletion=0,
> connStrIn='DSN=KAM_FINAL;UID=PGADMIN;PWD=xxxxxxx;'\par

As I said before. psqlODBC get PGADMIN instead of pgadmin.
There are two ways:
1) say Oracle to don't uppercase the username
2) create PGADMIN user in postgresql backend - to create this
   user you have to spcify the username in double quotes
   (somethink like this: create user "PGADMIN").

It isn't psqlODBC problem.

Regards,

Luf

pgsql-odbc by date:

Previous
From: "LLC"
Date:
Subject: Re: Oracle Heterogenous Services Error
Next
From: Hiroshi Inoue
Date:
Subject: Re: Cannot wrap stored procs in transaction via sql server