EasyCFM.COM ColdFusion Forums / Oracle Related Issues / DataDirect JDBC and Coldfusion Standard

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: DataDirect JDBC and Coldfusion Standard

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

hockeypfef
11-30-2006 @ 9:33 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 194
Joined: Apr 2006

I am trying to connect Coldfusion 7 Standard with the DataDirect JDBC drivers from DataDirect's webpage.  I keep getting this error:

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

My setup is this:
Data Source Name: XXXXXX
JDBC URL: jdbc:datadirect:oracle://servername:port;SID=YYYY
Driver Class: com.ddtek.jdbc.oracle.OracleDriver

Any ideas?  The test bat file that the DataDirect JDBC comes with connects fine.

Thanks,
Chris

hockeypfef
12-21-2006 @ 3:54 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 194
Joined: Apr 2006

Does anyone know if you have to have the Enterprise version or can you get DataDirect (purchasing from DataDirect directly) to work with the Standard version?

Thanks,
Chris

pangea33
12-22-2006 @ 6:01 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 62
Joined: Jul 2005

You definitely shouldn't require an Enterprise version of CFMX to work with the DataDirect drivers. Very few people would be willing to shell out the money for them if they can't verify that they work first. Typically this would be done on a machine other than the servers and most companies use developer versions on the programmer's machines due to licensing fees.

I've seen mention that the 3.4 drivers have errors that aren't found in the 3.2 drivers. What version are you running. Also, I've seen that this error is often reported when you're unable to see the actual native error, which could be something like a bad password or incorrect port. The timeout just comes back after the actual error has been occuring for a time.

http://knowledgebase.datadirect.com/kbase.nsf/ce24d9443437511f85256e57006bfe2a/31bab22f3326d99285256cee00531e04?OpenDocument&Highlight=0,timed,out

http://www.adobe.com/support/coldfusion/releasenotes/mx/mx61_known_problems.html
51664 You might receive a misleading "Timed out trying to establish connection" error rather than the database server's native error (such as "bad password") if the database doesn't respond in 30 seconds, which is the login timeout default.

--
http://benconley.net


Website Designed and Developed by Pablo Varando.