Oracle HSODBC problems

["LLC" <kevin(at)kevinkempterllc(dot)com>]

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?

 

Thanks in advance