From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
---|---|
To: | kevin(at)kevinkempterllc(dot)com |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Oracle HSODBC problems |
Date: | 2006-08-30 02:11:22 |
Message-ID: | 36e682920608291911x708b8bd0of56037f8cabf8660@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2006-08-30 03:19:22 | Re: Latest ODBC driver? / lo (blob) problem with fieldtype |
Previous Message | Joshua D. Drake | 2006-08-30 02:07:13 | Re: Oracle HSODBC problems |