Solved
Trouble setting up ODBC for Oracle for use with Crystal
Posted on 2004-09-10
I noticed we have an ODBC setup on one of our servers (Windows 2000) that connects to an Oracle Database. I'm trying to create the same ODBC on my WinXP Pro machine.
When I look at the list of drivers to choose from in create New Datasource window, I see:
Oracle 7
Oracle 8 v3.6
Microsoft ODBC for Oracle
1) I tried to use the Microsoft choice but I get this error:
"The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3 (or greater) client software installation.
You will be unable to use this driver until these components have been installed."
I do not support Oracle here so I do not have this software....nor would I know exactly what to download or what CD to use from Oracle. I don't even know if I should be using this driver. The database I'm trying to connect to is running Oracle 8
2) I tried using the Oracle 8 v3.6 driver. In the setup, I put in:
Data Source Name
Server Name
Default User Name
When I try to click the "Test Connect" button, I get the error "Specific driver could not be loaded due to system error 126(CR Oracle 8 v3.6)
3) My end objective is to create this ODBC on my PC so I can use it with Crystal to build a report. I need to create this Oracle ODBC first.