JDBC Connection to Oracle Using Crystal 10 1

[benamorton]

Hey All,
Crystal Reports v10 is giving an error when trying to connect to my oracle 9 database using JDBC. The error is "Logon Failed Details:JDBC Driver not found"

I know that this type of connection can be done (according to CR), but I haven't been able to find out how to do it, or anyone that has done it.
I should also mention that I am trying to do this w/o Oracle installed on the client machine.
I have been editing my CRDB_Javaserver.ini file changing the items in there.
Here is what I have in the .ini file:

[Common]
PATH = C:\Program Files\Common Files\Java\jdk1.5.0_01\bin
CLASSPATH = C:\CrystalJDBC\CRDBJavaServer.jar;C:\CrystalJDBC\msbase.jar;C:\CrystalJDBC\mssqlserver.jar;
C:\CrystalJDBC\msutil.jar

IORFileLocation = c:\temp
JavaServerTimeout = 1800
JVMMaxHeap = 64000000
JVMMinHeap = 32000000

[CRDB_JDBC]
CacheRowSetSize = 100
JDBCURL =oracle:thinOracle9i:1521:ORCL
JNDIURL =oracle:thinOracle9i:1521:ORCL
JDBCUserName = casa
JDBCDriverName = oracle.jdbc.driver.OracleDriver
JNDIUserName = casa
JNDIConnectionFactory =
JNDIInitContext = /
GenericJDBCDriverBehavior = ORACLE

[CRDB_XML]
PREREADNBYTE = 5000
CacheRowSetSize = 100
XMLLOCALURL =
SCHEMALOCALURL =
XMLHTTPURL =
SCHEMAHTTPURL =
USETEMPFile = TRUE

I would be very appreciative of any info that can be given about this. I have been working on it for days.
Thanks
Ben

 

[Turkbear]

Hi, As I noted in my reply to your other post on this topic, you need to install the Oracle JDBC drivers ( the jar file) - get it from your Oracle Client CD or download it from Technet..


PS: DataDirect does make 'thin client' wire protocol ODBC drivers..These also avoid needing an Oracle Client.
Read about them here:

http://www.datadirect.com/products/odbc/odbcrelhighlights/index.ssp

 

[synapsevampire]

Interesting stuff, *Turk*, thanks! I haven't needed this for years, but have in the past and will recall that it's possible anyway.

-k

 

[micro2005]

I am having a similar issue. I am trying to create a JDBC connection to connect to a SQL Server 2000 db with JBoss as the application server. CR v10 with JRC installed.

Here are the contents of my .ini file.


[Common]
PATH = ${JAVA_HOME}/bin
CLASSPATH = ${CLASSPATH}

IORFileLocation = ${TEMP}
JavaServerTimeout = 1800
JVMMaxHeap = 64000000
JVMMinHeap = 32000000

[CRDB_JDBC]
CacheRowSetSize = 100
JDBCURL =jdbc:JSQLConnect://hq-mp-usda-02:1433
JNDIURL =
JDBCUserName = icomp_2905_usda
JDBCDriverName = com.jnetdirect.jsql.JSQLDriver
JNDIUserName =
JNDIConnectionFactory =
JNDIInitContext = test
GenericJDBCDriverBehavior = SQL Server 2000

[CRDB_XML]
PREREADNBYTE = 5000
CacheRowSetSize = 100
XMLLOCALURL =
SCHEMALOCALURL =
XMLHTTPURL =
SCHEMAHTTPURL =
USETEMPFile = TRUE

The Class Path information was entered directly throught the enivronment variables. When I go to Crystal and try to create a JDBC connection it gives me an error message: "logon failed. JDBC driver not found"

Any help will be appreicated.

 

[micro2005]

Ok, I was able to solve this problem. Here are the details of my .ini file (in case anyone is interested).

[Common]
PATH = C:\j2sdk1.4.2_07\bin
CLASSPATH = C:\CrystalJDBC\CRDBJavaServer.jar;C:\CrystalJDBC\msbase.jar;C:\CrystalJDBC\mssqlserver.jar;C:\CrystalJDBC\msutil.jar;C:\CrystalJDBC\ojdbc14.jar

IORFileLocation = C:\temp
JavaServerTimeout = 1800
JVMMaxHeap = 64000000
JVMMinHeap = 32000000

[CRDB_JDBC]
CacheRowSetSize = 100
JDBCURL =jdbc:microsoft:sqlserver://<b>myservername</b>:1433
JNDIURL =
JDBCUserName =
JDBCDriverName = com.microsoft.jdbc.sqlserver.SQLServerDriver
JNDIUserName =
JNDIConnectionFactory =
JNDIInitContext = test
GenericJDBCDriverBehavior = SQLServer

[CRDB_XML]
PREREADNBYTE = 5000
CacheRowSetSize = 100
XMLLOCALURL =
SCHEMALOCALURL =
XMLHTTPURL =
SCHEMAHTTPURL =
USETEMPFile = TRUE