Skip to main content
nc777
nc777
Participant
December 4, 2015
Question

How to fix odbc driver mismatch or jdbc driver issue

  • December 4, 2015
  • 1 reply
  • 1529 views

Hi, I installed CF 11 Developer edition on Windows 12R2 and I have Oracle 12c as db. I installed both 32-bit and 64-bit of Oracle 12 clients. I tried to set up a data source using both odbc and jdbc approaches, but none of them is working. I ran the odbcad32.exe file from "C:\Windows\System32\", and odbcad32.exe from "C:\Windows\SysWOW64" to set up my data sources. Both connections are tested successful. For odbc, it said "The specified DSN contains an architecture mismatch between the Driver and Application". For jdbc it said no suitable driver available. Has anyone seen this and solved it? Thanks for any pointer.

This topic has been closed for replies.

1 reply

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
December 6, 2015

What's the deal with all the Windows stuff? You could set up a datasource by choosing the 'oracle' driver in the ColdFusion Administrator.

nc777
nc777Author
Participant
December 7, 2015

I did work on jdbc setup but got "driver not available" error. I couldn't figure it but then yesterday I found out from this site http://stackoverflow.com/questions/30858546/connect-teradata-jdbc-driver-on-coldfusion-11 that jdbc files need to be in this directory C:\ColdFusion11\cfusion\runtime\lib. I did just that and it worked. Thanks. I tested a simple page and it did connect to my db. But when I ran my app, I got a general error without debug output. I made some changes to the debug page under CF Admin and messed around, then my test page ignores cf codes and just display my static text.

nc777
nc777Author
Participant
December 7, 2015

Now my test page is working but for some reason it wouldn't execute query of query codes. I have made sure the caching setting in Admin is set up properly but still get "Query Of Queries runtime error. Unsupported SQL type java.sql.Types.UNKNOWN." Has anyone experienced query of query issues in ColdFusion 11?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices