oracle11g – Coldfusion 9.0.1 Standard 64bit and Oracle 11g 64bit ODBC connection results in architecture mismatch

oracle11g – Coldfusion 9.0.1 Standard 64bit and Oracle 11g 64bit ODBC connection results in architecture mismatch

Using Dans advice I grabbed a JDBC Driver from Oracle here:

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-111060-084321.html

I then moved the JAR (ojdbc6.jar in my case) and added it to my Coldfusion Class Path.

Determining the correct settings for using the datasource to Coldfusion was slightly harder but here are the settings I ended up going with:

JDBC URL: jdbc:oracle:thin:@//dbsrv.mydomain.com:1521/myDB.world
Driver Class: oracle.jdbc.driver.OracleDriver
Driver Name: Oracle Thin Driver

Then the username and password for the DB.

Sure enough it worked like a charm.

Dan, I want to give you a check mark because you definitely put me in the right direction, but I can only mark one correct.

I believe you need to either step down to the 32-bit drivers, or use native JDBC drivers to connect to Oracle successfully. My suggestion would be to go the JDBC route, and connect directly through a native Oracle JDBC driver by using the other selection on the Datasource screen. Youll get better performance that way, and have more control over your connection via ColdFusion.

Connecting to Oracle information in ColdFusion Livedocs.

oracle11g – Coldfusion 9.0.1 Standard 64bit and Oracle 11g 64bit ODBC connection results in architecture mismatch

i found an alternate way to do this

install the ODBC drivers for 64bit and 32bit (in that order) on your win2008 64bit OS

thereafter create the DSNs on both the System32 folder and SysWow64 folder by running the odbc32ad32.exe

ensure your tnsnames are setup fine in the respective network/admin folder (if you use tnsnames to maintain your sids)

now on the CF admin you creaet a new ODBC source with aODBC Socket and name. the next page should show you a drop down of all DSNs that exists in the 64bit DSN setup. When you go and test it in CF, it will strangely use the config of the 32bit DSN setup for validationb

voila….your connections should work. No worries of those architectural failures etc

Leave a Reply

Your email address will not be published. Required fields are marked *