| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Connecting to Unidata through HS
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
![]() |
![]() |