Re: Oracle HSODBC problems - Mailing list pgsql-odbc

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');