Skip to main content
JeffK
Inspiring
Dec 27, 2018 8:56 PM UTC
Question

connecting oracle and oracle MySql CF16

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 is closed to new replies. Start a new post to keep the conversation going.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
Dec 29, 2018 7:34 PM UTC

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.

Translate
BKBK
Community Expert
BKBKCommunity Expert
Community Expert
Dec 30, 2018 6:37 PM UTC

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.]

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