I am trying to set up a CF DSN using Access 365 (accdb) on win10 CF 2018 and I get this error message
Unable to update the NT registry.
Variable DRIVERPATH is undefined.
The google results are all over the board.
Change the Registry key, change to 32 bit, etc.
Is there a known solution to setting up this dsn?
Unless this is for limited use (ie, ten users or less), it is ill advised to use Access DB for CF app/site. You're better off with MS-SQL, or MySQL if you need a low-cost option.
I know this isn't the answer you want to hear. But it's my best advice on this matter.
^ _ ^
I've switched to MySQL. Thank you !
Thank you for marking my answer as correct. I do appreciate it, and I'm sure someone else in your situation will, too.
^ _ ^
PS.. considering how much more robust MySQL is over Access, I'm sure you'll be much happier with MySQL.
WolfShade's answer is really the best one. But if you're really unable or unwilling to do that, this blog post is probably your best shot.
The problem is pretty complicated, and does involve the registry and 32-bit drivers. ColdFusion reads ODBC datasource info from the Windows registry, and there's a 64-bit vs 32-bit issue with the SequeLink drivers that act as an ODBC bridge. So, long story short, you'll have to define the datasource outside of the CF Administrator using the information in the blog post.
Note: I don't know anything about Access 365. I'm assuming it still works the same way as previous Access versions when it comes to ODBC and SequeLink, though.
Finally: again, WolfShade's answer is really the right one. It's pretty easy to migrate a database from Access to MySQL or even Apache Derby. MySQL is your best bet for a web application, out of the options listed. Apache Derby is a lot like Access in that it's not a traditional client-server database engine, but at least it's well supported by CF. You can even migrate to SQL Server Web Edition, I think, which is definitely an improvement.
Dave Watts, Eidolon LLC