Skip to Content.
Sympa Menu

freetds - RE: [freetds] Oracle heterogeneous services

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Gregg Anderson" <ganderson AT ghx.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Oracle heterogeneous services
  • Date: Fri, 23 Apr 2004 09:14:47 -0600

Thanks Vitaly. Could you please explain the need for "c:=
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@hsodbc('use tempdb');"... We did get
it working without this by using version 0.63 and turning on the development
flag.

--Gregg Anderson

-----Original Message-----
From: VZverev AT genesis.spb.ru [mailto:VZverev AT genesis.spb.ru]
Sent: Friday, April 23, 2004 2:38 AM
To: freetds AT lists.ibiblio.org
Subject: RE: [freetds] Oracle heterogeneous services


Hello Gregg.
Try to use quoted identifiers ("table_name" instead table_name) and set valid
DB with DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE before query:

DECLARE
c INTEGER;
v varchar2(30);
begin
c:= DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE@hsodbc('use tempdb');
select foo into v from "table_name"@hsodbc ;
end;

Unfortunately, generic heterogeneous connectivity service does not support
distributed transactions :(.

Sincerely yours.

------------------------------------------------------------
Vitaly Zverev, Oracle Applications DBA,
Genesis Ltd., S.Petersburg, Russia


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Gregg Anderson
Sent: Thursday, April 22, 2004 7:47 PM
To: freetds AT lists.ibiblio.org
Subject: [freetds] Oracle heterogeneous services


We are trying to connect our Solaris 8 Oracle 9i database to FreeTDS through
unixODBC, and are able to connect to SQLServer2000. However, all our queries
through SQLPlus error out with "table or view does not exist. Both tsql and
isql queries run fine, so we are baffled.

Here is our configuration string... Any help would be greatly appreciated.

locale is "C"
locale charset is "646"
Compile-time settings (established with the "configure" script):
Version: freetds v0.62.3
MS db-lib source compatibility: no
Sybase binary compatibility: unknown
Thread safety: no
iconv library: yes
TDS version: 7.0
iODBC: no
unixodbc: yes

Thanks,

Gregg Anderson
Senior Software Developer

Global Healthcare Exchange
10385 Westmoor Drive, Suite 100
Westminster, CO 80021
720.887.7294
720.887.7200 fax
ganderson AT ghx.com

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page