From: | "LLC" <kevin(at)kevinkempterllc(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Oracle HSODBC problems |
Date: | 2006-08-30 17:06:16 |
Message-ID: | 1156957576.v2.fusewebmail-164106@f |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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');
From | Date | Subject | |
---|---|---|---|
Next Message | Avery Payne | 2006-08-30 17:42:47 | Re: Visual FoxPro, PostgreSQL, and Dates (Long) |
Previous Message | LLC | 2006-08-30 16:59:57 | Re: Oracle HSODBC problems |