I am trying to connect Crystal Reports v11 to an Oracle 9i database. The ODBC driver provided with Microsoft XP does not work and so I am wondering which driver I might require for this simple application. There are so many drivers offered on the Oracle website and elsewhere that I am not sure which one is required.
Any help here would be gratefully received.
Thanks in advance
Can you be more specific about what "does not work"? What driver are you using? I'm guessing that you're trying to use the "Microsoft ODBC driver for Oracle," but if you could confirm that, it would be helpful. What error do you get?
Is there an Oracle client installed on the machine where Crystal Reports is installed? Are there multiple Oracle Homes on the machine?
There are no clients on the PC. We have tried to use the Microsoft provided ODBC driver and the error message refers to this not being able to deal with Oracle above v7.3 I think. We are using Oracle 9i and have found that this never had an approved driver for Windows. Is this true?
Also, I do not think that there is an Oracle Home on the PC as this accesses the Oracle via .exe files on another server
Edited by: user8724399 on 13-Aug-2009 14:46
The machine where Crystal Reports is running will need an Oracle client installed. There are potentially three different machines involved here-- your local desktop, a middle tier server where Crystal Reports is running, and a database server. Whichever machine(s) connect to the Oracle database would need the Oracle client installed.
I expect that the error message you are getting is telling you that the Microsoft ODBC driver for Oracle requires that the 7.3 or later version of the Oracle client is installed on the machine that is attempting to connect to the database. That is expected if the Oracle client has not been installed-- Microsoft ships a driver that works on top of the Oracle client, not a driver that can directly communicate with the database.
If the machine that wants to connect to the Oracle database does not have an Oracle client installed, you would need to install a version of the Oracle client. You can download this from OTN from the same place that the database can be downloaded-- if you are installing on Windows, there is a separate client-only download on the same page where the database can be downloaded, on other operating systems, you generally need to download the database installer and do a client-only install. The client-only install for Windows is still a few hundred MB depending on the version of the client you get. If that footprint is too large, you can use the Instant Client instead, but that requires a bit more work to install-- it is more commonly used when you want to ship a very small Oracle client with an application you are developing, so it assumes that you'll be writing the installer and registering the appropriate DLLs.
Hi Justin -
I have a similar situation - where I am trying to connect a version of Crystal Reports (locallly running on my machine) to a 10g Oracle db. I have the ODBC driver installed, but when I try to create a datasource using the driver, I get an error in odbcad32.exe : Unhandled exception at 0x7c90100b in odbcad32.exe: 0xC0000005: Access violation reading location 0x00000034.