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
Ben ConnerCTO, SAS developerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ben ConnerCTO, SAS developerAuthor 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).
0
Ben ConnerCTO, SAS developerAuthor 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
0
_agx_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 :)
0
Ben ConnerCTO, SAS developerAuthor 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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.