oracle odbc connection fails (architecture mismatch) and oracle jdbc connection timesout in Adobe ColdFusion 10 Administrator

New Here ,
Nov 03, 2015 Nov 03, 2015

Copy link to clipboard

Copied

I am moving a ColdFusion app off of a really old server (the old server has Blue Dragon installed that came with oracle odbc drivers built in) to an newer server (Windows 2012) with ColdFusion installed instead.

On this new server, I get a success when I test the 64 bit Oracle in instantclient10_2 connection.  However, when I attempt this connection as an ODBC Socket in the ColdFusion Administrator, with this strategy I get an error of architecture mismatch between driver and application.

So, on this new server I instead went the route of jdbc, so I instead chose "other" as my driver in the ColdFusion Administrator, with this strategy I get an error of "Timed out trying to establish connection"

I have verified my jdbc url and username/password are correct (I connected successfully with this jdbc url via RazorSQL as a test),

I have verfied the jdbc driver is in the appropriate class path for ColdFusion.

I initially believed I truly had the incorrect oracle odbc instant client installed on the new machine so I tried the same tests above with every oracle instantclient 32 bit version and every oracle instantclient 64 bit version available and found this is the only one that gives me a success on testing the connection:  64 bit Oracle in instantclient10_2)

My 32 bit odbc experiments were set up from here: syswow64\odbcad32.exe

My 64 bit odbc experiments were set up from here: system32\odbcad32.exe

If you have any suggestions send them my way, thanks and have a great day!

Views

314

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation