Avatar of Ben Conner
Ben Conner
Flag for United States of America asked on

Managing DSNs in CF 11

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
ColdFusion Language

Avatar of undefined
Last Comment
Ben Conner

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
_agx_

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Ben Conner

ASKER
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 Conner

ASKER
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
_agx_

>> 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 :)
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Ben Conner

ASKER
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