connecting oracle and oracle MySql CF16

Forum|Forum|7 years ago
December 27, 2018
1 reply
614 views

In the past I have always had success connecting data sources. However, I am really struggling connecting both my Oracle database and my MySQL databases to CF16. I believe I have the drivers in place but no matter what I do I still am cursed with the "No suitable driver available" message.

Trying to connect to Oracle 12c and MySQL latest version 8.

For oracle I am using what i did with CF11 and that is the jdbc oracle thin driver.

For MySQL I am using jdbc mysql driver.

Both are located in the /cfroot/cfusion/lib directory (or at least I think they are).

Any help would be appreciated.

Thanks

JK

This topic has been closed for replies.

BKBK

Community Expert

The latest drivers may be no good to you. The ColdFusion 2016 Support Matrix says you should install the drivers most suitable to Oracle 11g R2 / 12c and MySQL 5.7.

BKBK

Community Expert

Useful links:

Oracle driver

Re: Connect to Oracle Database

ColdFusion 2016 standard and Oracle adventures - ColdFusion

MySQL driver

MySQL :: Download MySQL Connector/J (Archived Versions) [The MySQL web site says "MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, 5.6, and 5.5. Please upgrade to MySQL Connector/J 8.0". Nevertheless, should this new driver be incompatible with ColdFusion 2016, download and use version 5.1.46.]

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.

Scanning file for viruses.

This file cannot be downloaded