| 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-22 16:07:28 |
| Message-ID: | 20060622160728.GB25481@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2006-06-23 00:16:10 | Re: Cannot wrap stored procs in transaction via sql server |
| Previous Message | LLC | 2006-06-22 16:03:12 | Re: Oracle Heterogenous Services Error |