CF Oracle DataSource

[WebolutionDesigns]

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?

[LAW01]

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)?

[WebolutionDesigns]

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

[Adam Cameron.]

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

--

Adam

[WebolutionDesigns]

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

[Adam Cameron.]

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