• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

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

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?


  • 2
  • 2
1 Solution
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.

bigfigAuthor Commented:
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.

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.
bigfigAuthor Commented:
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>

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

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now