• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Variable DRIVERPATH is undefined Error

Guest
May 31, 2007 May 31, 2007

Copy link to clipboard

Copied

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?

Views

12.5K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Explorer , May 31, 2007 May 31, 2007
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.

Votes

Translate

Translate
Explorer ,
May 31, 2007 May 31, 2007

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Aug 08, 2007 Aug 08, 2007

Copy link to clipboard

Copied

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?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Aug 08, 2007 Aug 08, 2007

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Jun 02, 2007 Jun 02, 2007

Copy link to clipboard

Copied

That does work. but has to be done each time an access datasource is added. Is there anyway to give coldfusion permission to access the registry automatically?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 11, 2009 Jun 11, 2009

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 03, 2010 Oct 03, 2010

Copy link to clipboard

Copied

@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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 20, 2011 Mar 20, 2011

Copy link to clipboard

Copied

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!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 01, 2011 Jun 01, 2011

Copy link to clipboard

Copied

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!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Sep 01, 2011 Sep 01, 2011

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 23, 2012 Nov 23, 2012

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation