Hi Joshua;
I do have the database name in the ODBC DSN but it seems to have no
effect. In the below samples, sample 1 works and sample 2 does not.
Thanks for your help
Sample 1:
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');
Sample 2:
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');