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

Re: Oracle HSODBC problems

From: "LLC" <kevin(at)kevinkempterllc(dot)com>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>,pgsql-odbc(at)postgresql(dot)org
Subject: Re: Oracle HSODBC problems
Date: 2006-08-30 16:59:57
Message-ID: 1156957197.v2.fusewebmail-164106@f (view raw or flat)
Thread:
Lists: pgsql-odbc


----- Original Message -----


Subject: Re: [ODBC] Oracle HSODBC problems


From: "Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com>


Date: Tue, August 29, 2006 20:11





On 8/29/06, LLC <kevin(at)kevinkempterllc(dot)com> wrote:
> each time we get 'table does not exist'

In PostgreSQL:
CREATE TABLE test_tbl (test_id NUMERIC(10) NOT NULL PRIMARY KEY,
test_name VARCHAR(32));

In PostgreSQL:
INSERT INTO test_tbl VALUES (1, 'From PostgreSQL');

In Oracle over HSODBC:
INSERT INTO "test_tbl"@dblinkname VALUES (2, 'From Oracle');


-- 
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 2nd Floor            | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster




Hi Jonah;

The above works so long as the test_tbl lives in the 'postgres' database
(the default db). If I run the folowing it does not work. Oracle cannot
find the table because it's not connecting to the testdb database. The
postgres logs indicate a connection attempt via the postgres database.

The correct database is specified in the odbs DSN as well, but seems to
have no effect.

Thanks for your help...


In PostgreSQL:
CREATE database testdb;

\c testdb

CREATE TABLE test_tbl (test_id NUMERIC(10) NOT NULL PRIMARY KEY,
test_name VARCHAR(32));

In PostgreSQL:
INSERT INTO testdb.test_tbl VALUES (1, 'From PostgreSQL');

In Oracle over HSODBC:
INSERT INTO "testdb.test_tbl"@dblinkname VALUES (2, 'From Oracle');



pgsql-odbc by date

Next:From: LLCDate: 2006-08-30 17:06:16
Subject: Re: Oracle HSODBC problems
Previous:From: Joshua D. DrakeDate: 2006-08-30 16:59:48
Subject: Re: Latest ODBC driver?

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