How to fix odbc driver mismatch or jdbc driver issue

[nc777]

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.

[BKBK]

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]

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]

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?