• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4375
  • Last Modified:

Unable to update the NT registry. Variable DRIVERPATH is undefined

I am trying to configure a Microsoft Access data source on Vista 64-bit with ColdFusion 8.0.1.  Get this error each time: "Unable to update the NT registry. Variable DRIVERPATH is undefined"
Found many people asking this question, but not much help.  This link seemed to be the best help, but did not work for me (http://www.webmasterkb.com/Uwe/Forum.aspx/cold-fusion/14625/Variable-DRIVERPATH-is-undefined).  I tried adding  a "Driver" string containing "C:\WINDOWS\System32\odbcjt32.dll" to the this reg key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<my data source>
Also tried  "C:\WINDOWS\SysWOW64\odbcjt32.dll" as the string value.  Any suggestions would help.  I'd really like to use my Vista box to develop with.
0
sulzener
Asked:
sulzener
1 Solution
 
Jim P.Commented:
Guessing here --

Find the userid that your cold fusion/asp/ whatever runs under.
(or conversely -- breaking standardized security use everyone or Authenticated Users)

Then go into regedit, Drill down until you find the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC key and then right-click --> Properties --> Security tab and give full permission to that user id.
0
 
sulzenerAuthor Commented:
Instead of Properties, it said Permissions.  I still tried it and it didn't work.  Still need help!!!
0
 
Jim P.Commented:
What if you right-click My Computer --> Properties --> Advanced Tab --> Environment Variables --> System Variables block and do a New

Add DRIVERPATH as the Variable Name and in the Value add C:\WINDOWS\System32\ and see what happens.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
sulzenerAuthor Commented:
That didn't work either.  Thanks again.
0
 
Jim P.Commented:
Have you seen this:

Michael Imhoff said...

    Hi Ben,

    Are you using "Microsoft Access with Unicode" as the driver? This worked just fine for me, outside of that I'm sorry to say I won't be of much help as I primarily use SQL Server.

http://michael.omnicypher.com/2006/10/cfmx-setup-on-vista.html
0
 
sulzenerAuthor Commented:
jimpen, I looked for that to try as I have seen it in earlier CF installs.  But in CF8, it only shows Microsoft Access.  Any clue how I can get the driver "with Unicode" to show in the available Driver list?
0
 
Jim P.Commented:
0
 
sulzenerAuthor Commented:
I thought this might be it, but it still didn't work.  Could it be that I am on 64-bit machine?  When I look at the Drivers listed in Adminstrative Tools/Data Sources, the only driver list is SQL Server.  On my WinXP box, I have a boatload of drivers listed there.
0
 
Jim P.Commented:
There is a SysWOW\ODBCAD32 -- what does that show?
0
 
sulzenerAuthor Commented:
I do not see that folder on my box.  I see c:\windows\sysWOW64\
0
 
Jim P.Commented:
You're looking for the driver list. c:\windows\sysWOW64\ODBCAD32.exe
0
 
sulzenerAuthor Commented:
Sorry for the delay:  the command shows several drivers.  The Access drivers are:
Driver do Microsoft Access (*.mdb)
Microsoft Access dBASE (*.dbf)
Microsoft Access Driver (*mdb)
Microsoft Access Driver (*mdb, *accdb)
Microsoft Access Paradox Driver (*db)
Microsoft Access Text Driver (*txt, *csv)
Microsoft Access Teiber (*mdb)
0
 
Jim P.Commented:
Try using the Microsoft Access Driver (*mdb, *accdb) and see what happens.
0
 
sulzenerAuthor Commented:
Okay, when I create a System DSN using "c:\windows\sysWOW64\ODBCAD32.exe", it does not appear in the CF Admin Data Sources.
0
 
sulzenerAuthor Commented:
I am giving up on this since it appears there is no Microsoft Access connection when using Vista Ultimate 64-bit.  I will award the points for effort.  
0
 
Jim P.Commented:
Glad to be of assistance. May all your holidays be great.
0
 
dlemareCommented:
This worked for me on a 64bit windows with 64 bit Cold Fusion 8.
http://blog.flemingonline.com/2008/03/creating-64-bit-odbc-dsn-to-work-with.html

It seems that 64bit apps don't use the hklm\software\wow6432\odbc subkey and the registry entries for hklm\software\odbc don't get added when the office system drivers are installed.
0
 
JohnMac328Commented:
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now