Need Help for Crystal reports in client machine with ORACLE

Jun 3 2004 2:27 AM
Guys, We are using C#,Oracle 9.0,Crystal Reports 8.5 We are trying to print reports in client system, where we are not installing oracle. But there is a database connectivity problem from client system. We are trying to use an ODBC connection (System DSN, through MICROSOFT ODBC DRIVER/ORACLE DRIVER). The following article suggests to install ORACLE CLIENT in all the client systems. Anybody who knows how to solve this issue, please suggest. Instead of going for a client installation of ORACLE, how can we establish a connection. Article : Crystal 8.5 Documentation =============================== Crystal Reports supports direct access to Oracle 7 and Oracle 8 SQL databases. This accessibility is provided by the P2sora7.dll and P2lora7.dll translation files. These files communicate with the Oracle 7 and Oracle 8 database driver, which works directly with Oracle databases and clients, retrieving the data you need for your report. Note: In order for Crystal Reports to use Oracle 7 and Oracle 8 SQL databases the Oracle client software must be installed on your system, and the location of the Oracle driver must be in the PATH statement of your Autoexec.bat file. Note: When logging on to Oracle using P2sora7.dll or P2lora7.dll, the date format is changed to match the default date/time format of Crystal Reports. For more information about default formats, see To set standard default formats for Date, Time, and Date/Time fields.

Answers (1)