I have a new computer that’s been a challenge to set up…I’m a web developer, not a computer tech which is the problem. I have Windows11 Pro, installed ColdFusion2023 and on my Windows10 use MS Access 2013 (yeah, I know, it’s old, but it has always worked perfectly for me) when developing sites on my local host. On my old computer, which ran CF10, I’d use ODBC32 to connect…but I’d have to connect it first in Windows ODBC32, then add it through the CF admin system. Unfortunately, while I connect it the same way on Windows 11 Pro, when I open a website, I get this:
[Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: Data source name not found and no default driver specified
I’ve checked and rechecked everything…making sure the data source name is correct, that the proper driver is selected, that both CF 2023 ODBC Agent and Server are running, but clearly I’m missing something. Can anyone help?
Newbie
1 posts
ColdFusion 2023 works with MS Access. I’ve got it running–without any special odbc settings or new jdbc drivers. I simply selected the MS Access driver offered in the cf admin–albeit on a machine where Access itself was installed. (I did it some months ago in response to someone else asserting it didn’t work.)
Michelle, have you gotten it running since creating this thread 3 months ago? If not, can you confirm if you tried that simple approach?
And Steve, you’re not the first to want to let people know they should not be using Access. I gave up fighting about that years ago. 🙂 People have their reasons, good or bad, to have found it was suitable for their needs. They only complain when it unexpectedly stops working with a new install of CF. It can and it should work with it, even if they should perhaps rightly be discouraged from using it.
Finally, Phil suggested getting “a new jdbc driver”. There’s no new one to get for cf’s provided one–or if there is, it’s offered by Adobe when a cf update might implement it. There’s nothing else we can do regarding to update that driver, as it’s licensed for us by Adobe.
But as has been offered in many cf community support places and blog posts over the years, there is indeed the ucanaccess third party jdbc driver which others have implemented successfully with CF, when other approaches failed.
Again, I’m pointing out first and foremost that the built-in Access driver should work. It does for me, with CF2023. If it doesn’t for someone, there will be an explanation and we should be able to come up with should a resolution.
It’s not supposed to use MS Access with Coldfusion or any other platforms for the sake of the limitation of concurrency and the performance.
Personally, I think MySQL could be recommended to take the place.
The most important reason is MySQL is free and adequate for me.
(Though, maybe, the recent and latest MySQL versions are charged. ???)
You may need to get a new JDBC Driver to connect to access for the latest version. I stepped briefly through this making an infrastructure change from an older database engine to a newer one. I had to find the latest JDBC connector for my database engine, and drop it into (I may not remember correctly) cfusion\lib. Then I had to build a connection in cfadmin to call up that driver and pass the connection string.
You must be logged in to post a comment.
23 Nov
10AM Pacific
Online
