Re: Oracle HSODBC problems

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

Responses

Browse pgsql-odbc by date

  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