Crystal 10 Connection to Oracle 9 DB

[benamorton]

Hey All,
I am wondering if there is a way to run a Crystal V10 report using an Oracle 9 DB without having the Oracle client software installed on the PC (PC has Win 2000).
Is there some kind of ODBC driver I can use to connect to it? Can I use OLE?
I have been reading thru the documentation on the Crystal website for hours and haven't found anything very useful.
Any help that can be given is much appreciated.

Thanks,
Ben Morton

 

[synapsevampire]

The client is an Oracle requirement.

By OLE do you mean OLE DB?

I believe that OLE DB requires a client as well.

-k

 

[benamorton]

I have found some info on connecting using JDBC, so I am trying that route.
I am having problems connecting still, Crystal tells me "JDBC Driver not found."..... I'm sure this has to do with the JDBC driver path that I have given it. I just used the default as:
JDBCDriverName = oracle.jdbc.driver.OracleDriver
(in the CRDB_javaserver.ini file)
and the URL is:
JDBCURL =oracle:thinOracle9i:1521:ORCL

Anyone who can help me, I would be greatful to.
Thanks in advance.
Ben

 

[synapsevampire]

I did see a blurb on usign JDBC connections without a client as well, however I've not tried it.

Let's read if you are successfull.

-k

 

[Turkbear]

Hi,
Did you install the Oracle JDBC driver?