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

CR 8.5/9 with Oracle

How do i connect to the Oracle database ?
I dont want to use the ODBC Drivers, any thing else i can do ?
0
glottis
Asked:
glottis
2 Solutions
 
mnyeCommented:
why dont you want to use ODBC?
0
 
mlmccCommented:
Here is some information on using Oracle stored procedures

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_oracle_stored_procedures.pdf.asp

mlmcc
0
 
glottisAuthor Commented:
In java i can connect to the oracle database (located on a network) through the use of classes12.zip file downloaded from Oracle Network. These provide better solutions to connecting.

In odbc there is a slight delay of data transfer.
0
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
glottisAuthor Commented:
that link didnt provide much help,
ok to the last resort, how do you connect through ODBC also ?
0
 
mnyeCommented:
If you are on windows create an Oracle ODBC system or user connection with Service name, user name and password. Then you'll need to call the ODBC in java (using Suns Oracle Bridge.  im not a great Java programmer so i can really give you a example worth seeing but here is the link for documentation on the bridge.

http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html

hth

late
matt
0
 
YKostylevaCommented:
You can use native Oracle drivers.
0
 
glottisAuthor Commented:
i tried using that but i get an error that oracle client 7 should be installed (or something like that) if you want ill enter the exact message in the next post.

that is why i was asking it.
0
 
mnyeCommented:
yeah let me see the error.
0
 
glottisAuthor Commented:
Microsoft ODBC for ORACLE
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 sue this driver untill these components have been installed.

This thing worked a few weeks ago, thats for sure, after that this.

The database i connect to is on the server in a LAN environment.

In java i use the classes12.zip file by the oracle people so connection from java is no problem.
0
 
Ken TurnerCommented:
The fact that the message mentions ODBC seems to suggest that you're still trying to connect through this route rather than via native Oracle Drivers.

In CR8.0 (it may be a bit different in 8.5 or 9.0), in the Set Location -> Data Explorer dialogue, you need to take the More Data Sources -> Oracle Server route.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

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