Skip site navigation (1) Skip section navigation (2)

Re: Oracle HSODBC problems

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: kevin(at)kevinkempterllc(dot)com
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Oracle HSODBC problems
Date: 2006-08-30 02:07:13
Message-ID: 44F4F2D1.2080209@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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 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
              http://www.commandprompt.com/



In response to

pgsql-odbc by date

Next:From: Jonah H. HarrisDate: 2006-08-30 02:11:22
Subject: Re: Oracle HSODBC problems
Previous:From: Hiroshi InoueDate: 2006-08-30 01:22:00
Subject: Re: Visual FoxPro, PostgreSQL, and Dates (Long)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group