Crystal Report Error

From: <kayartho_at_norcross.rms.slb.com>
Date: Mon, 10 Aug 1998 21:41:57 GMT
Message-ID: <6qnpf5$oq8$1@nnrp1.dejanews.com>

Hi Everybody, I am facing a problem in crystal reports with Oracle8. We have reports written for Oracle7 database with Oracle73 ODBC Driver version 2.5.3. Same reports if I run on Oracle8 Database using Oracle8 ODBC Driver Version 8.0.4.4, it gives errors. By tracing, I made following observations. 1. It is passing odbc specific query to Oracle like "SELECT

CUSTOMERSVIEW."ENTITYNAME", CUSTOMERSVIEW."LASTNAME",
CUSTOMERSVIEW."FIRSTNAME", CUSTOMERSVIEW."STREETNAME",
CUSTOMERSVIEW."STREETNUMBER", CUSTOMERSVIEW."STREETSUFFIX",
CUSTOMERSVIEW."STREETDIRECTION", CUSTOMERSVIEW."UNITNUMBER",
CUSTOMERSVIEW."CITY", CUSTOMERSVIEW."STATE", CUSTOMERSVIEW."ZIP",
CUSTOMERSVIEW."AREACODE", CUSTOMERSVIEW."PHONENUMBER",
ACCOUNTSVIEW."ENTITYNAME", ACCOUNTSVIEW."LASTNAME", ACCOUNTSVIEW."FIRSTNAME",
ACCOUNTSVIEW."STREETNAME", ACCOUNTSVIEW."STREETNUMBER",
ACCOUNTSVIEW."STREETSUFFIX", ACCOUNTSVIEW."STREETDIRECTION",

ACCOUNTSVIEW."UNITNUMBER", ACCOUNTSVIEW."CITY", ACCOUNTSVIEW."STATE", ACCOUNTSVIEW."ZIP", ACCOUNTSVIEW."AREACODE", ACCOUNTSVIEW."PHONENUMBER", METERSVIEW."ENTITYNAME", METERSVIEW."SERIALNO", READLIST."QUANTITYCODE", READLIST."DISCONNECT" FROM { oj (("MAPS"."CUSTOMERSVIEW" CUSTOMERSVIEW INNER JOIN "MAPS"."ACCOUNTSVIEW" ACCOUNTSVIEW ON CUSTOMERSVIEW."ENTITYID" = ACCOUNTSVIEW."CUSTOMERENTITYID") INNER JOIN "MAPS"."METERSVIEW" METERSVIEW ON ACCOUNTSVIEW."ENTITYID" = METERSVIEW."ACCOUNTENTITYID") INNER JOIN
"MAPS"."READLIST" READLIST ON METERSVIEW."ENTITYID" = READLIST."ENTITYID"}
WHERE (+) ORDER BY ACCOUNTSVIEW."ENTITYNAME" If you see from clause, you can see oj for outer join and from clause is totally odbc specific, which can not be interpreted by oracle.( like oj, { }...)

2. If I use oracle73 odbc driver version 2.5.3 to connect to oracle8 database, the query is
""SELECT CUSTOMERSVIEW."ENTITYNAME", CUSTOMERSVIEW."LASTNAME",

CUSTOMERSVIEW."FIRSTNAME", CUSTOMERSVIEW."STREETNAME",
CUSTOMERSVIEW."STREETNUMBER", CUSTOMERSVIEW."STREETSUFFIX",
CUSTOMERSVIEW."STREETDIRECTION", CUSTOMERSVIEW."UNITNUMBER",
CUSTOMERSVIEW."CITY", CUSTOMERSVIEW."STATE", CUSTOMERSVIEW."ZIP",
CUSTOMERSVIEW."AREACODE", CUSTOMERSVIEW."PHONENUMBER",
ACCOUNTSVIEW."ENTITYNAME", ACCOUNTSVIEW."LASTNAME", ACCOUNTSVIEW."FIRSTNAME",
ACCOUNTSVIEW."STREETNAME", ACCOUNTSVIEW."STREETNUMBER",
ACCOUNTSVIEW."STREETSUFFIX", ACCOUNTSVIEW."STREETDIRECTION",

FROM "MAPS"."CUSTOMERSVIEW" CUSTOMERSVIEW,


"MAPS"."ACCOUNTSVIEW" ACCOUNTSVIEW,

"MAPS"."METERSVIEW" METERSVIEW,
"MAPS"."READLIST" READLIST

WHERE CUSTOMERSVIEW."ENTITYID" = ACCOUNTSVIEW."CUSTOMERENTITYID" AND ACCOUNTSVIEW."ENTITYID" = METERSVIEW."ACCOUNTENTITYID" AND METERSVIEW."ENTITYID" = READLIST."ENTITYID" (+) ORDER BY ACCOUNTSVIEW."ENTITYNAME" 3. It is working fine on Oracle7 database using oracle7 odbc driver ver 2.5.3. If you have any solution or faced similar problem, please help me.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 10 1998 - 16:41:57 CDT