WebolutionDesigns

Known Participant

Question

CF Oracle DataSource

Forum|Forum|16 years ago
September 1, 2009
2 replies
1205 views

My IT department set up an ODBC connection to Oracle and it tests out fine from the CF admin. I then wrote a simple SQL statement to pull one record to test the connect from a cfm page. When I run that page, it just hangs...never resolves or throws an error. Am stumped from a troubleshooting standpoint, especially since no error displays. Can anyone point me in the right direction please?

Database access

This topic has been closed for replies.

Inspiring

I'm not sure this has anything to do with your issue, but why did they use ODBC instead of JDBC?

--

Adam

WebolutionDesignsAuthor

Known Participant

Not any reason in particular. Our IT department set it up. Would that make a difference?

Inspiring

It's accessing the DB via a completely different mechanism, so it could make a difference, yeah.

In a Java environment, one should use JDBC if possible. One should fall back to ODBC only if there is not a better way of doing it.

--

Adam

Participant

Can you post your code for the query? Also, can you query sysdate?

<cfquery name="name" datasource="DSN">

select sysdate

from dual

</cfquery>

Have you checked your coldfusion or oracle log files to see if there are any errors being generated (even though it seems to hang)?

WebolutionDesignsAuthor

Known Participant

I tried that and same result...just hangs there. ANy other thoughts?