Missing the CR Oracle driver from CR Standard 2

[mirty12]

Sorry if this is a really dumb question. We have just started using the Crystal Reports platform.

Our developer created reports from our Oracle database, using CR Developer edition. He asked me to purchase five licenses of CR Standard, so that some other users could work on and modify these reports. I did so. Now I've installed CR Standard, but the workstations are missing the CR Oracle 8 ODBC driver (needed to create the Oracle DSN).

I checked the manual and online help, and downloaded the files it seemed were needed: p2sora7.dll and p2lora7.dll. I copied these into the c:\winnt\crystal directory on the workstations. Still no CR Oracle ODBC option.

I called CR tech support, and the tech rep said that "Standard" does not include Oracle connectivity, only "Professional" and "Developer" include that. (But the manual that came with the Standard edition includes several pages on Oracle!) Can this be true? Am I stuck now with a version of CR that won't connect to our databases?

 

[rosemaryl]

Dear Mirty12,

Just checking, do you have the Oracle client installed on these machines?

Also, do you have the Microsoft Oracle ODBC or the Oracle 8 ODBC drivers (you can check by click add when in the System DSN tab) both of these will also work, you don't have to use the CR Oracle 8 driver.

If you have either one of those, create the DSN, then open a report and click the Database/Convert Database Driver, this should allow you to change to the just configured DSN.

I hope this helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[synapsevampire]

Just set up an Oracle ODBC connection on the boxes. I assume that Standard will use ODBC connections, you probably just don't get the Oracle direct or th CR supplied ODBC.

You may have some unusual behavior with Stored Procedures, etc., but I'm fairly sure that you can connect through ODBC (their site says ODBC sources).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mirty12]

Thanks! I set up the Oracle ODBC and gave it the same name as the CR Oracle ODBC that the developer is using. That worked.