Re: Oracle HSODBC problems - Mailing list pgsql-odbc

From Jonah H. Harris
Subject Re: Oracle HSODBC problems
Date
Msg-id 36e682920608291911x708b8bd0of56037f8cabf8660@mail.gmail.com
Whole thread Raw
In response to Oracle HSODBC problems  ("LLC" <kevin@kevinkempterllc.com>)
List pgsql-odbc
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/

pgsql-odbc by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Oracle HSODBC problems
Next
From: Hiroshi Inoue
Date:
Subject: Re: Latest ODBC driver? / lo (blob) problem with fieldtype