Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

Next:From: Avery PayneDate: 2006-08-30 17:42:47
Subject: Re: Visual FoxPro, PostgreSQL, and Dates (Long)
Previous:From: LLCDate: 2006-08-30 16:59:57
Subject: Re: Oracle HSODBC problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group