Skip to main content
Participant
December 6, 2019
Question

Accessing Access database with CF2018 and Windows server 2019

  • December 6, 2019
  • 1 reply
  • 956 views

I am migrating my website from Windows server 2008 to Windows server 2019. I've got CF 2018. I cannot get it to connect with my MS Access database. Did all the ODCB entries. Registry has the correct information. When trying to make and verify the connection in CF admin, I get "java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined". I found a website that said Windows 2016+ does not support SequeLink. I don't know if that is the problem. I just need to get CF2018 and my database connected. Any solutions?

 
This topic has been closed for replies.

1 reply

Charlie Arehart
Community Expert
Community Expert
December 6, 2019

Let's put on the table first that MS Access has not been formally supported by CF since CF11. You can see that while it's listed in the "system support matrix" for CF11 (here), while it's no longer listed as a supported DB in the version of that document for CF2016 (here) or 2018 (here).

 

So you're pushing a rock up hill, in trying to keep it going (and of course many would decry anyone trying to use Access with CF still in 2019--and even someone trying to help folks wanting to do it).

 

But if you really are determined/compelled/feel required to get it to work, there were various solutions shared in this other thread on the topic, created in 2016 and updated into 2019, and multiple people reported particularly getting success from the steps shared by someone in this comment (with steps they got for Adobe, as a workaround).

 

FWIW (for future readers that may find this), as the title of that other thread indicated, those were for getting it running on 64 bit CF. There have been other discussions in the past on getting things working with 32-bit CF, but note that CF2018 no longer supports 32-bit (and bgbowling does refer here specifically to using CF2018).

 

If you do try this approach (in the other threads, from the 2016 era), let us know how it goes.

 

But again, folks, really: it's long past time to get off of Access, for use with a server like CF. Note that there are free alternatives like the Express edition of MS SQL Server (as well as MySQL, PostGres, and others), and tools to convert from Access to that.

/Charlie (troubleshooter, carehart. org)
kkfin
Participating Frequently
December 7, 2019

One option is also to use MS Access as a frontend and MS Sql Server or Azure Sql Database as a backend.