ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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.
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.
-
7
-
6
4- +1
18 Comments
why dont you try using oledb for oracle. ODBC is very flexible and must be good for alot of the datasources including ORacle. However try oledb for oracle too and see what it does for you
Regards
Emre
Regards
Emre
read this article.This articlle shows the oracle odbc dependencies. You could be missing one
http://support.businessobjects.com/library/kbase/articles/c2000757.asp
Regards
Emre
http://support.businessobjects.com/library/kbase/articles/c2000757.asp
Regards
Emre
Also this is a great document telling about ODBC architecture for Crystal
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_odbc_architecture.pdf
Emre
http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_odbc_architecture.pdf
Emre
You can also install the native Crystal ODBC Driver for Oracle - I've had the best luck using that driver in most cases as it seems to have the fewest unexplainable problems.
frodoman
frodoman
In ODBC there are two kinds of drivers
1.native
2.ODBC drivers specialized for specific DBMS
1. They ship with crystal and are the drivers listed under database files, or More Data Sources under Data Explorer, If you want to use native one you can select the Oracle version from here
2. Also you can use specialized drivers. these are the dlls that help you connect to the specialized DBMS. CROR814.dll for example
Regards
Emre
1.native
2.ODBC drivers specialized for specific DBMS
1. They ship with crystal and are the drivers listed under database files, or More Data Sources under Data Explorer, If you want to use native one you can select the Oracle version from here
2. Also you can use specialized drivers. these are the dlls that help you connect to the specialized DBMS. CROR814.dll for example
Regards
Emre
>>>native Crystal ODBC Driver
where can I get it, where can I check to see if it is installed, and how do I reference/use/setup ?
where can I get it, where can I check to see if it is installed, and how do I reference/use/setup ?
>>>oledb for oracle
never used it, don't know how to set this up...where, details, need hand holding down to the novice detail here
never used it, don't know how to set this up...where, details, need hand holding down to the novice detail here
Native Driver: When you add a new odbc connection you'll see it listed as CR Oracle ODBC Driver 4.10 (the number may be different of course).
Should be on your Crystal CD. If not you can find on the net (e.g.: http://www.dynamiclink.nl/htmfiles/rframes/dll-c08.htm ) looking for CROR818.dll
did you read this article that I posted.It explains all the odbc drivers and methods that you can use and where to find them. But simply
go to control panel
go to administrative tools
go to odbc data sources
select driver tab
That shows the drivers installed special drivers
Native drivers already come with crystal and that article gives you the names of dlls that should be on the computer
http://support.businessobjects.com/library/kbase/articles/c2000757.asp
Regards
Emre
go to control panel
go to administrative tools
go to odbc data sources
select driver tab
That shows the drivers installed special drivers
Native drivers already come with crystal and that article gives you the names of dlls that should be on the computer
http://support.businessobjects.com/library/kbase/articles/c2000757.asp
Regards
Emre
I installed the client for Oracle 8i, I was able to then get rid of that error when clicking on the Microsoft ODBC for Oracle. It prompted me for the following info wich is entered correctly:
Data Source Name
Description
User Name
Server
Ok, but the problem I have now (I'm throwing in Crystal here), is that in Crystal, when I try to expend this ODBC in the set location to try to view the tables, I get this error:
ODBC error: [Microsoft][ODBC Driver for Oracle][Oracle] ORA-12514: TNS: Listener could not resolve SERVICE NAME given in connect.
There was no where in the Create new ODBC window for the Microsoft ODBC for Oracle that allowed me to enter a "SERVICE NAME". So Crystal must be looking somwhere else for this?
Data Source Name
Description
User Name
Server
Ok, but the problem I have now (I'm throwing in Crystal here), is that in Crystal, when I try to expend this ODBC in the set location to try to view the tables, I get this error:
ODBC error: [Microsoft][ODBC Driver for Oracle][Oracle] ORA-12514: TNS: Listener could not resolve SERVICE NAME given in connect.
There was no where in the Create new ODBC window for the Microsoft ODBC for Oracle that allowed me to enter a "SERVICE NAME". So Crystal must be looking somwhere else for this?
I understand how to navigate in the ODBC Administrator...I create ODBCs all the time for SQL Server. I just didn't know about the native drivers...so those are just the list that come with XP then is what you are saying in the Select Server TAB? That is all I needed to know...a simple translation of Native drivers = the ones you see in that TAB. The ones I see every fricking day. Do I know that they are "native" no, I don't...
>>>did you read this article that I posted
Ok, but if you rename these in WINNT, what about if you have installed the Oracle Client....shouldn't it be using those? Or should it just use Crystal's ODBCs (dlls) since they were made for this purpose....connecting to Oracle.
Ok, but if you rename these in WINNT, what about if you have installed the Oracle Client....shouldn't it be using those? Or should it just use Crystal's ODBCs (dlls) since they were made for this purpose....connecting to Oracle.
I will try both methods. Fisrt try to do it with the native drivers
Try tpo connect from moredatasources tab under dataexplorer or data tables. If that fails see if the native driver dlls are located in the client
Then if all fails I will try using
Specialized drivers
create an odbc system dsn for oracle and connect to the report using that dsn created from odbc tab under datasources
I will again check if the dlls are there
Regards
Emre
Try tpo connect from moredatasources tab under dataexplorer or data tables. If that fails see if the native driver dlls are located in the client
Then if all fails I will try using
Specialized drivers
create an odbc system dsn for oracle and connect to the report using that dsn created from odbc tab under datasources
I will again check if the dlls are there
Regards
Emre
The TNS listener error probably just means that you need to update (or create) your name file. You should have this file:
c:\oracle\ora81\network\ad
Bear in mind it may be slightly different folders so search on the name if you must. Open this file in notepad (MAKE A BACKUP FIRST IN CASE YOU MAKE A MISTAKE!!!) anD make an entry corresponding to your oracle service name. For example here's one of the entries from my file for the "orcl" service name:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = orcl))
)
Obviously the host=xxx.... should be the tcp/ip address of your database - I removed it here for security. Once you've made this entry, reboot and hopefully that'll clear the TNS listener error message.
frodoman
c:\oracle\ora81\network\ad
Bear in mind it may be slightly different folders so search on the name if you must. Open this file in notepad (MAKE A BACKUP FIRST IN CASE YOU MAKE A MISTAKE!!!) anD make an entry corresponding to your oracle service name. For example here's one of the entries from my file for the "orcl" service name:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = orcl))
)
Obviously the host=xxx.... should be the tcp/ip address of your database - I removed it here for security. Once you've made this entry, reboot and hopefully that'll clear the TNS listener error message.
frodoman
I resolved it by having to install Oracle 8i client. Then I used the ODBC called "Oracle ODBC Driver" which I don't believe I saw prior to installing the client. That ODBC gave me the prompts I needed unlike the others.
Featured Post
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples).
Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone,
Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8.
We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Suggested Courses
Course of the Month11 days, 15 hours left to enroll
605 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.