Managing DSNs in CF 11

Ben Conner
Ben Conner used Ask the Experts™
on
Hi,

Does CF 11 need registry access to update ODBC DSNs?  I recently installed CF 11 in secure mode and don't recall if I gave it registry update access or not.  During testing, I tried to add a MS Access DSN and got the following:

Unable to Update the NT registry
Variable DRIVERPATH is undefined

Am also unable to delete any DSNs as well.

Thanks!

--Ben
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Commented:
EDIT: Yes, it does, but if your install didn't have permissions, you'd probably see a different error.  With CF10/11 64bit that error is typically caused by lack of support for Access 64bit.  See if these entries help resolve the problem.  Short story - ignore the error and create a 32bit DSN manually:

http://blogs.coldfusion.com/post.cfm/coldfusion-10-64bit-and-msaccess
https://www.experts-exchange.com/questions/28767919/Error-in-creating-Datasource-in-Coldfusion-11.html

FWIW, the fix didn't seem to work for this guy using CF2016. Not sure if it was a CF2016 or Win10 problem, but ... since it's hasn't been "officially" supported in a long while, you might want to think about moving away from Access, before it is time to upgrade to 2016.
https://www.experts-exchange.com/questions/28973544/Coldfusion-2016-setup-problem-with-MS-Access-advice-needed.html
Ben ConnerCTO, SAS developer

Author

Commented:
This isn't specific to MS Access, but to any DSN entry; I'm unable to delete or add any DSNs  (I imported a CAR file to get the initial ones in there).
Ben ConnerCTO, SAS developer

Author

Commented:
Did some more testing and my previous reply was incorrect; I was able to add and remove a SQL Server DSN.  I just can't add or remove a MS Access one.  Given that my goal is to get rid of all of them, what I will try is manually deleting them by editing the neo-datasource.xml file.

What could possibly go wrong? :)

--Ben
Most Valuable Expert 2015

Commented:
>> What could possibly go wrong? :)

Lol.... don't say that! Are you trying to jinx yourself? ;-)

Seriously though, editing the xml file sounds like a good plan. After making a backup first of course :)
Ben ConnerCTO, SAS developer

Author

Commented:
Looks like the editing tools I have don't do a great job with xml that is missing cr or cr/lf EOL indicators.  I looked at the # of DSNs I need to create and decided it was just easier to type them all in, as I have a working copy on the production server I can compare to.  

The bottom line on this is: if you install a 64 bit version of CF, be prepared for heartburn if you use Access databases.  In my situation it is easy enough to convert them to SQL Server.  But for those who can't, the links above from _agx_ are well worth browsing.

Thanks!

--Ben

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial