"Oracle8 ODBC Driver Connect" versu "Oracle SQL" connection

Posted on 2005-03-24
Medium Priority
Last Modified: 2008-01-09
We can connect to our Police Oracle 7 database from our clients running Crystal Reyport 8.5 when using the DSN configured with Oracle 8.01 driver.  This works only using  Crystal's "Data Explorer", because the server logon dialog box shows "Oracle8 ODBC Driver Connect".

The Problem:
If we try a run the report or do a "Database Verify", the database logon show s a different logon dialog box of "Oracle SQL".  When using this connection type we get the following message "Error while trying to retrieve text for error ORA-00000".

How Can We:
change the report or Crystal Reports setup to use "Oracle8 ODBC Driver Connect" instead of  "Oracle SQL" logon process when running reports or doing a database verify.  Again, the only way we get the Oracle8 ODBC Driver connect is when we use the "Data Explorer."  Why is that?


Question by:bigfig
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Accepted Solution

AnnetteHarper earned 2000 total points
ID: 13630098
Try using the Database | Set Datasource Location command to change the report's datasource from using the native driver (Oracle Server) to using an ODBC datasource. Note that when using an ODBC datasource, you'll want to use the Crystal ODBC drivers for Oracle. The driver names start with "CR Oracle".

Since the Data Explorer is always used to connect to databases, I'm not sure I understand your question about that being the only way you can get the ODBC connection.


Author Comment

ID: 13631357
Thanks Annette for your help.  

Regarding using Data Explorer, when we use this Crystal function, I recieve a dialog box labeled "Oracle8 ODBC Driver Connect."

I have installed the Oracle Client 8.0.1 software, so I believe its saying it's using the Oracle 8 driver from this install.  And it works.

Now, if I call up my users reports, its using another driver that has a dialog box labeled "Oracle SQL" which fails to connect.


Expert Comment

ID: 13631588
Well, it's been a long time since I used CR 8.5, but maybe some background info will be helpful to you.

There are basically two ways to connect to Oracle databases using Crystal Reports, ODBC or native. Both require the installation of Oracle Client software (unless you're using the Wire Protocol ODBC driver). The "native" driver uses a DLL supplied by Crystal Reports to interact with Oracle databases specifically and shows up as "Oracle Server" (or possibly "Oracle SQL" in 8.5) in the Database Expert if an Oracle client is installed. If you use ODBC, then you must first create a DSN using the ODBC Administrator. You should create the DSN using one of the Crystal Reports ODBC drivers for Oracle. These always have names starting with "CR". ODBC drivers from other vendors such as Oracle or Microsoft will not work as well with Crystal Reports. After creating the DSN, you use the "ODBC" connection type in the Database Expert and pick the DSN you created.

Each machine that will run reports must have the same setup, using either native or ODBC connections. Each maching must have the Oracle client installed. If using native connections, the Oracle data access option must be installed when installing Crystal Reports. If using ODBC, each machine must have the same DSNs setup or access the DSNs on a shared network drive. This includes the server, if reports are being run from the web.

You need to determine which type of connection is defined in the report file and make sure that all the necessary pieces are setup on each machine. Alternatively, you can use the Set Datasource Location command to switch to a different connection type.

Author Comment

ID: 13633417
The following worked, thanks Annette:

1) In CR select <Database>/<Set Location>

2) For each database we are calling for a particular report
    a) highlight one at a time each DB in the Databases box and click  <Set Location>
    b) scroll down to ODBC/name and make the logon(it using the Oracle8)
    c) and choose the database name.
    d) click on YES to <propagate set location>


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question