Pierre, I know your last reply here was from a few months ago, but since I know some people who are paying attention to this thread, I wanted to follow-up with you. You said you had gotten the jar, put it in the lib, created an "other" DSN, and got the error about "No suitable driver".
What you don't indicate is whether you had restarted CF, as halbob indicated was the final step. Usually, the "no suitable driver" is because of that (CF does not have the jar loaded). Is it possible you did since then do that restart, and all did work and you just forgot to tell us? Or did you maybe give up and never try to verify the DSN again after a restart? Please do let us know.
I will add that resorting to a 3rd party jar (like that hxtt one) should not be necessary, for those wanting to create and use an Access DSN (though that should be discouraged generally) on 64-bit CF10 or 11. The steps above about creating a DSN in the Windows 32-bit ODBC control panel (and one in the CF Admin of the same name) should suffice. (More in a moment on CF2016, where that alone does not seem to suffice.)
Note that one DOES need to have the CF ODBC Windows service implemented and running (and it would not be, if whoever ran the CF installer on a gien machine told it not to bother. I think that's what caused the error Elliot reported before your post, "ColdFusion ODBC Server service is not running". Fixing that involves simply calling an Admin API method to create those services, as discussed Re: ColdFusion 11 ODBC service.)
Back to CF2016, these steps alone don't seem enough. As HCR and mcollins323 discussed in other comments here, they found they needed to install also the 64 bit MS Access Database Engine, also. Pierre, I know you said that had not worked for you. But rather than delve into that, and since you later brought up this challenge using the hxtt driver, I thought we ought first make sure a simple restart of CF might not have solved that problem (as it should have).
Bottom line, though folks really ought not be using MS Access still in 2018, those who choose to or feel forced should still be able to get it working one of these various ways.
One last thing: Pierre noted in an earlier comment that the CF Admin doc page for the CF Admin still referred to Access, though note that was in passing regarding the ODBC Server service. It seems worth noting that Access is NO LONGER listed in the CF 2016 support matrix" document listing supported systems and databases: https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdf. It WAS indeed listed in the CF11 one: https://wwwimages2.adobe.com/content/dam/acom/en/products/coldfusion/pdfs/cf11/coldfusion11-support-....
So it seems we should likely not expect much further help from Adobe to get Access DSNs working again on CF2016 or beyond. We may even find that the Access option in the CF Admin DSN driver type list could someday be removed. In that case, the "other" option and using the hxtt driver would seem the only recourse for those who choose not to move off of Access.
But no discussion of enabling use of Access should be left without an acknowledgment that for nearly 20 years people have been told it is NOT a DBMS suited to multi-threaded web applications. Does it work for some? Sure. Might it fail them in ways they've never realized, or that better alternatives would not? Sure. As Halbob also indicated, one can consider the free SQL Server Express edition (which really is free for production, with merely a 10g limit per database, and for which MS offers migration tools to move to from Access). Or there are of course MySQL and other DBMSs that can be used for free. See my cf411 list of DB alternatives, at http://www.cf411.com/db.
/Charlie (troubleshooter, carehart.org)
17
Replies
AdChoices