I am moving an application from Oracle 8i to 9i and I am having issues setting
up the datasource connection to Oracle9i Enterprise Edition Release 9.2.0.7.0
from the CFMX7 administrator (Developer install). I can connect to the 9i box
from SQL*Plus and every other other DB tool I have tried. Only having
connection issues with CF.

I have tried two approaches in setting up the datasource.
1. Oracle Driver - I get the error: "java.sql.SQLException: No more data
available to read." I updated the DataDirect JDBC drivers to version 3.5. Same
error.

2. JDBC Thin Client - I get the error: "java.sql.SQLException: No more data to
read from socket". Downloaded the latest JDBC driver from Oracle. Same error.

I think I need to use option (1) long term because we use Oracle REF CURSORs
in the application. But I thought I would use the JDBC thin client as another
test option.

Does anyone have any recommendations about what could be wrong?
Set-up/config? patches?

Thanks in advance.