Skip navigation
abhishek77
Currently Being Moderated

Variable DRIVERPATH is undefined Error

May 31, 2007 6:26 PM

I have just installed coldfusion mx 6.1 developer edition on vista ultimate. The installation went fine.
However i get an error when adding a datasource in access or verifying all connections.
On adding the datasource, i get the following error.

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

Is it because of vista incompability?
 
Replies
  • Currently Being Moderated
    May 31, 2007 7:10 PM   in reply to abhishek77
    CF probably does not have permission to access to your registry

    Locate the following reg key

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<your data source>\

    do you see a string called "Driver"?

    if not, create it with the value of "C:\WINDOWS\System32\odbcjt32.dll"

    if this works, credit Rob D.
     
    |
    Mark as:
  • Currently Being Moderated
    Aug 8, 2007 12:18 PM   in reply to Cole
    I did the exact same thing, but it's not working for me. I still get the following error:

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

    Any ideas anyone?
     
    |
    Mark as:
  • Currently Being Moderated
    Aug 8, 2007 1:42 PM   in reply to Cole
    Thank you Rob D. :)
    *****************************************
    CF probably does not have permission to access to your registry

    Locate the following reg key

    HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<your data source>\

    do you see a string called "Driver"?

    if not, create it with the value of "C:\WINDOWS\System32\odbcjt32.dll"

    if this works, credit Rob D.
     
    |
    Mark as:
  • Currently Being Moderated
    Jun 11, 2009 8:32 AM   in reply to abhishek77

    I had same problem with x64 vista found answer

     

    Open C:\Windows\SysWOW64\odbcad32.exe and create a System DSN using the Microsoft Access Driver (*.mdb).

    Then open the ColdFusion Admin and create a datasource using the ODBC Socket driver.

    Check the Trusted connection checkbox and it should work.

     
    |
    Mark as:
  • Currently Being Moderated
    Oct 3, 2010 9:33 AM   in reply to jimmoos

    @jimmoos

     

    Your solution is clean and works! No messing around with registry entries.

     

    I have x64 Windows 7. I took myself backwards and was able to reinstall my ColdFusion MX 6.1 software. It was also my first time to use the  "ODBC Socket driver" option. Upto this point I had always used the other drivers (native ones)

     

    Thx buddy

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 20, 2011 11:02 AM   in reply to kkhisa

    Thanks so much for the info!  I have Windows 7 x64bit with

    Coldfusion 6.1.  I'm just developing for myself so didn't want to upgrade.  This solution worked perfectly.  Thanks again!

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 1, 2011 5:52 AM   in reply to jimmoos

    I'm having the same problem, but when I try to create a SYSTEM DSN, I don't have a Microsoft Access option.  I only have SQL Server and SQL Native Client.  Any suggestions?  Thanks!

     
    |
    Mark as:
  • Currently Being Moderated
    Sep 1, 2011 11:42 PM   in reply to jimmoos

    That's a clean solution, but the MS Access DSN I add in System DSN does not show up in the "ODBC DSN" select box in the Datasource creation form in the CF Admin at

     

    Data & Services > Datasources > ODBC Socket

     

    so when I submit the form I get this error:

     

    A ODBC Datasource must be selected before submitting changes

     
    |
    Mark as:
  • Currently Being Moderated
    Nov 23, 2012 1:09 AM   in reply to aquarium.west

    I had similar issues. Fixed them by installing the 64-bit drivers from here: http://www.microsoft.com/en-us/download/details.aspx?id=13255

     

    Then I had to add the System DSN in the 64-bit ODBC Management Console, which causes it appear in the ODBC DSN drop-down on the CF Admin Data Source form.

     

    Then had to add the same System DSN to the 32-bit ODBC Management Console, to fix this error when CF attempts to connect to the database:

    Connection verification failed for data source: PABasketballSSJ
    java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application
    The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket]internal error: The specified DSN contains an architecture mismatch between the Driver and Application
     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points