Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Connecting to Unidata through HS

Connecting to Unidata through HS

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca.x>
Date: Thu, 13 Nov 2003 17:53:45 GMT
Message-ID: <JyPsb.43731$Ws6.39141@edtnps84>


I'm trying to use Heterogeneous Services on 8174 SE to connect to a Unidata 5.2 database.
Unfortunately, somewhere the SQL statement gets translated into invalid syntax.
This is what I am passing in SQLPlus:

select DEMO_WELL_INFO_NF.AREA THEAREA, DEMO_WELL_INFO_NF.NAME THENAME from Administrators.DEMO_WELL_INFO_NF_at_DAVEHS

And this is what the HS trace file shows me:

(0) Sql Text is: SELECT A1."AREA",A1."NAME" FROM
(0) "ADMINISTRATORS"."DEMO_WELL_INFO_NF" A1
(0) [Ardent][UniData ODBC Driver][IBM][SQL Client][UNIDATA] SELECT A1.NAME
AS
(0) c0001, A1.AREA AS c0000 FROM ADMINISTRATORS.DEMO_WELL_INFO_NF A1;
syntax
(0) error (SQL State: 37000; SQL Code: 0)
(0) (Last message occurred 2 times)
(0)
(0) [A00A] Execute query failed, data source is DAVEHS, SQL text is SELECT
(0) A1.NAME AS c0001, A1.AREA AS c0000 FROM
ADMINISTRATORS.DEMO_WELL_INFO_NF A1 The problem is that Unidata doesn't like the AS. If I connect through PowerBuilder using ODBC to the Unidata database, I have no problem using the original SQL statement. If I use the translated SQL statement, it will fail unless I remove the AS.
Anybody have any idea how to tell Oracle / Unidata to not mangle my SQL?

-- 
Terry Dykstra
Canadian Forest Oil Ltd.
Received on Thu Nov 13 2003 - 11:53:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US