Re: Oracle HSODBC problems

LLC wrote:
> 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
specifiedthe db name in the ODBC DSN and in the query but each time we get 'table does not exist'. Based on the
postgreslogs I see that the database is always 'postgres' . Since postgres is the default db it leads me to believe
thatthe 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
              http://www.commandprompt.com/