Issue with Oracle DB connection.

Question

I have a 64bit VM windows server running Windows Server 2008 R2.

I installed Oracle drivers for both 32bit and 64bit. Have TNS for both setup for my Oracle database.

The setup of the datasource, verified fine.

The web application will connect fine to the database and works sometimes against it.

But will error out at some point, error is: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused.

The database is not the issue since this application and database is running perfectly on an older server that is being decommissioned.

I had first tested with the Coldfusion trial version and everything worked perfectly without error. Problem appeared to be introduced

after setting the license key. Also, in the trial version, I was not using the ODBC socket, but there was specifically an Oracle type

available.

Help with this would be very much appreciated - I am stuck.

Thanks Scott

Charlie Arehart · Answer

You say, “also, in the trial version, I was not using the ODBC socket“. Are you using that (the ODBC socket-type DSN) now? Why? Is the driver you got form Oracle an ODBC or JDBC driver? If the latter (as your error message seems to indicate), then use the “other”-type for creating the DSN. Let us know how that goes or what you think.

/charlie

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.