----- Original Message -----
Subject: Re: [ODBC] Oracle HSODBC problems
From: "Jonah H. Harris" <jonah.harris@gmail.com>
Date: Tue, August 29, 2006 20:11
On 8/29/06, LLC <kevin@kevinkempterllc.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@enterprisedb.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');
