X-Original-To: pgsql-interfaces-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 85B019FB207
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 21 Sep 2006 00:59:22 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 40567-03 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 21 Sep 2006 03:59:13 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 9E7609F9F72
	for <pgsql-interfaces@postgresql.org>;
	Thu, 21 Sep 2006 00:59:12 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from fuse17.mailanyone.net (fuse17.mailanyone.net [69.31.1.213])
	by svr4.postgresql.org (Postfix) with ESMTP id A6AD15AF9FD
	for <pgsql-interfaces@postgresql.org>;
	Thu, 21 Sep 2006 03:59:11 +0000 (GMT)
Received: from mailanyone.net
	by fuse17.mailanyone.net with asmtp (MailAnyone extSMTP kkempter)
	id 1GQFiO-0002jV-Ip
	for pgsql-interfaces@postgresql.org; Wed, 20 Sep 2006 22:59:08 -0500
Received: from 63.214.184.6 (FuseMail web AccountID 164106)
	by webmail.fusemail.com with HTTP;
	Wed, 20 Sep 2006 22:59:10 -0500 (CDT)
Message-ID: <1158811150.v2.fusewebmail-164106@ffuse9>
Date: Wed, 20 Sep 2006 22:59:10 -0500 (CDT)
Subject: Oracle only see's 'postgres' db and no schema's vi HSODBC
From: "LLC" <kevin@kevinkempterllc.com>
To: pgsql-interfaces@postgresql.org
Reply-To: kevin@kevinkempterllc.com
User-Agent: FuseMail W
MIME-Version: 1.0
X-Priority: 3
Importance: Normal
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.071 tagged_above=0 required=5 tests=HTML_MESSAGE,
	SPF_NEUTRAL, UNPARSEABLE_RELAY
X-Spam-Level: *
Content-Type: multipart/alternative;
	boundary="----=_20060920225910_81086"
X-Archive-Number: 200609/23
X-Sequence-Number: 6268

<div>Hi List;</div>
<div>&nbsp;</div>
<div>We've established an Oracle HSODBC (Heterogeneous Services) connection to postgres. However no matter what database we specify in the postgres ODBC driver on the Oracle (windows) box Oracle only connects to the 'postgres' database. Also Oracle does not allow us to specify a schema name.</div>
<div>&nbsp;</div>
<div>Any help? Comments? Thoughts???</div>
<div>&nbsp;</div>
<div>Thanks in advance
<br></div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>
<br></div>
------=_20060920225910_64433
Content-Type: multipart/alternative;
	boundary="----=_20060920225910_81086"

------=_20060920225910_81086
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Hi List;
 
We've established an Oracle HSODBC (Heterogeneous Services) connection to postgres. However no matter what database we specify in the postgres ODBC driver on the Oracle (windows) box Oracle only connects to the 'postgres' database. Also Oracle does not allow us to specify a schema name.
 
Any help? Comments? Thoughts???
 
Thanks in advance

 
 

------=_20060920225910_81086
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

<div>Hi List;</div>
<div>&nbsp;</div>
<div>We've established an Oracle HSODBC (Heterogeneous Services) connection to postgres. However no matter what database we specify in the postgres ODBC driver on the Oracle (windows) box Oracle only connects to the 'postgres' database. Also Oracle does not allow us to specify a schema name.</div>
<div>&nbsp;</div>
<div>Any help? Comments? Thoughts???</div>
<div>&nbsp;</div>
<div>Thanks in advance
<br></div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div>
<br></div>
------=_20060920225910_81086--
------=_20060920225910_64433--