Can't setup OCI driver for MX6.1

[ck969]

I'm using Oracle Oracle OCI driver for MX6.1 on solaris, however, I could not setup a datasource and this is the error i got:

Connection verification failed for data source: adminforms
[]java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection

and I've check the jvm.config file, it points to the correct <oracle_path>/jdbc/lib/classes.zip path. Also, on the coldfusion startup script, the LD_LIBRARY_PATH variable has this path set.

I could not see why, any clue ?

 

[ecobb]

I didn't realize you had posted twice...Can you ping the Oracle server from the CF Server? It sounds more like ColdFusion can't find the Oracle server.

Hope This Helps!

Ecobb

&quot;Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer.&quot; - Homer Simpson

 

[ck969]

Yes, I could. From unix level, I can connect to the server through sqlplus. The native driver works fine for oracle connection on Coldfusion Admin. page, but not the OCI connection. Why ? It seems lile not just me having this problem for MX 6.1 version, other people have this problem too.