Re: Oracle Heterogenous Services Error

[Ludek Finstrle <luf(at)pzkagis(dot)cz>]

> 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