Oracle 8i Error message

[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?

[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

[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.

[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

[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?

[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

[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.

[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