Native vs. CR Driver(s) - 1

[amatson]

Debating on using an oracle8i driver with my reports in lieu of CR driver but receive conflicting advice and find little information on the subject.

***Looking for comprehensive documentation AND expert opinion on what to go with and WHY.

 

[synapsevampire]

There are whitepapers on the CD site explaining numerous problems.

I just corrected a lot of problems at my current client by changing their driver to the CR (we're using CR 8.5, which you might consider sharing when you post).

Crystal says use their driver.

What is motivating you to use the Oracle one, speed?

It shouldn't be worth the other hits you'll take, and never knowing.

-k

 

[amatson]

I've searched CD papers using many key word variations nothing on cror815.dll except a download and irrelavant info.

I would like to know what components of the driver are native to oracle and technical specs on the build.

Motivation: I don't think changing my odbc/native driver is the fix to our problem.

Problem/Scenario:

We've developed a ColdFusion 5 Web app, integrated CR into the app via ASP viewer and oracle 8i procedures.

I develop the reports (using CR 8) on my box hitting oracle8i via network. The reports are then placed on Win2k and NT servers which have the CE9 report engine installed. Many oddities are taking place...

One issue is 4-digit year reads normally on my box but reads '0' in app which hits reports on servers.

Are odbc dll s installed on servers?
Any thoughts on my scenario??