Page 1 of 1
Oracle 8i Error message
Posted: Wed Jul 25, 2001 12:49 pm
by Mike_Johnson_(Guest)
I am running R&R SQL 8.1 on and Oracle 8i database and keep getting a General Protection fault error message and crash of course. The message list the offending dll as SQORA32.DLL.____Any ideas?
=> RE: Oracle 8i Error message
Posted: Wed Jul 25, 2001 1:56 pm
by kfleming
When does the error occur?__Does it happen on all reports?____One thing that you might try is editing your RSWSQL.INI file.__Change the Oracle section to read:____;;;;;;;;;;;;;;;;;;__;;; ;;;__;;; Oracle ;;;__;;; ;;;__;;;;;;;;;;;;;;;;;;__[Oracle]__;DataSourceDBMS = Oracle__DataSourceDriver=SQORA32.DLL__DataSourceOuterJoinStyle = 2__DateFormat = to_date(^%dd-%mm-%yyyy^, ^dd-mm-yyyy^)____This adds a semi colon at the start of the DataSourceDBMS line and then adds the new DataSourceDriver line.____Kathleen__R&R Support
==> RE: Oracle 8i Error message
Posted: Thu Jul 26, 2001 9:52 am
by Mike_Johnson
Nope didn^t work. It does it when I try to preview a report. Seems to be limited to reports where I am using a date field.
===> RE: Oracle 8i Error message
Posted: Thu Jul 26, 2001 10:30 am
by kfleming
Try creating a calculated field that whose expression is:__RR(datefield) and use that in place of the actual datefield and see if that helps.____Kathleen__R&R Support
====> RE: Oracle 8i Error message
Posted: Wed Aug 22, 2001 10:24 am
by Mike_Johnson_(Guest)
I tried your suggestion and I also loaded R&R 9. I can view the report about three times then I get the same error message again.____The Release Notes for 9 said to use SQO32_73.DLL rather than the SQORA32.DLL because the new datatype VARCHAR2 that Oracle 8 has won^t translate correctly. I think the date,time field has the same problem. ____I have SQO32_73.DLL but don^t know how to get R&R to use it. Do I have to install it as a Data Source?
=====> RE: Oracle 8i Error message
Posted: Mon Aug 27, 2001 7:44 am
by kfleming
You would I think need to install the Oracle7 client to make the earlier ODBC driver available for use.__The Oracle7 client can connect to an Oracle8 database.____Kathleen__R&R Support
======> RE: Oracle 8i Error message
Posted: Mon Oct 29, 2001 12:29 pm
by Mike_Johnson
Tried everything. Doesn^t work. Can^t reinstall Oracle 7 files without distroying Oracle 8. Need to be able to use R&R with Oracle 8.____When will a fix be available for this? We would like to use R&R with Oracle 8 and Oracle 9 will be out soon. This is a big problem.
=======> RE: Oracle 8i Error message
Posted: Mon Oct 29, 2001 9:49 pm
by kfleming
Apart from the varchar issue and potentially an RSW.INI tweak to help performance, R&R should work fine from an Oracle 8 client.__Do you have other apps that can use the Oracle data source without error?______Kathleen__R&R Support