> Hi List;
> We've setup an oracle HSODBC (Heterogeneous Services) connection to a postgres database using the postgresql ODBC driver. The odbs driver and oracle instance are on a windows box and the Postgres db is on a red hat box. We've specified the db name in the ODBC DSN and in the query but each time we get 'table does not exist'. Based on the postgres logs I see that the database is always 'postgres' . Since postgres is the default db it leads me to believe that the oracle connection is not passing the database name...
> Anyone have any experiences similar, know of any work-arounds, etc?
In the ODBC DSN you can specify the database.
Joshua D. Drake
> Thanks in advance
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
In response to
pgsql-odbc by date
|Next:||From: Jonah H. Harris||Date: 2006-08-30 02:11:22|
|Subject: Re: Oracle HSODBC problems|
|Previous:||From: Hiroshi Inoue||Date: 2006-08-30 01:22:00|
|Subject: Re: Visual FoxPro, PostgreSQL, and Dates (Long)|