Skip to main content
W
weezerboy
Inspiring
February 20, 2020
Answered

Unable to update the NT registry. Variable DRIVERPATH is undefined.

  • February 20, 2020
  • 2 replies
  • 2090 views

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?

 

 

This topic has been closed for replies.
Correct answer WolfShade

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.

 

V/r,

 

^ _ ^

2 replies

D
Community Expert
Dave WattsCommunity Expert
Community Expert
February 20, 2020

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.

 

https://www.coldfusionmuse.com/mobile/postDetail.cfm?post=3D91453C-B298-4951-10A5931E252209D1

 

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

Dave Watts, Eidolon LLC
WolfShade
WolfShadeCorrect answer
Legend
February 20, 2020

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.

 

V/r,

 

^ _ ^

W
weezerboyAuthor
Inspiring
February 21, 2020

I've switched to MySQL. Thank you !

    WolfShade
    WolfShade
    Legend
    February 21, 2020

    Thank you for marking my answer as correct.  I do appreciate it, and I'm sure someone else in your situation will, too.

     

    V/r,

     

    ^ _ ^

     

    PS.. considering how much more robust MySQL is over Access, I'm sure you'll be much happier with MySQL.

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