Skip to main content
Participant
November 28, 2013
Question

DataSource creation errors

  • November 28, 2013
  • 1 reply
  • 1369 views

I'm creating a simple Login page in Dreamweaver but I am having trouble creating the Datasource in the Datasource Administrator.  I am using a Miscroft Access Database.  When I access the Adminstrator and go to Data Services/Datasources and select the Microsoft Access database driver type I am prompted to input a "path" to the Database File and a "path" to the System Database File.  I understand what is required for the path to the database file but do not know what is required for the System Database path.  I tried inserting the same path as the database file and also tried inserting the path to the MS Access EXE file as the path to the System database file but when I submit the Datasource for updating I get 2 error messages. The first states that the "NT registry" could not be updated and the second states that the variable "DRIVERPATH" is not defined.  Any help would be appreciated.  Without a good connection to that datasource I cannot complete the connection to the Login Page.  The ColdFusion environment for Dreamweaver set up perfectly and the test page pulled the data from the database flawlessly.

This topic has been closed for replies.

1 reply

Anit_Kumar
Community Manager
Community Manager
November 28, 2013

Hello Silk Trial Site,

First of all, you will need the 32-bit AccessDatabaseEngine (http://www.microsoft.com/download/en/details.aspx?id=13255) installed.  Then, create the datasource in Datasource Administrator. Run C:\Windows\SYSWOW64\odbcad32.exe. Select the "System DSN" tab and Click "Add". Choose "Microsoft Access Driver (*.mdb)". Click "Finish". Use the same Data Source Name, which was provided in CF Admin/Datasource administrator. Click "Select" and browse to your .mdb (or .accdb) file. Click "OK" twice.

That should work.

Regards,

Anit Kumar

Participant
November 28, 2013

I'm running Windows 7 64 bit.  Will I need 64 bit AccessDatabaseEngine instead of the 32bit version?

I'm also running ColdFusion 10, MS Access 2002 and Dreamweaver 6.0

Anit_Kumar
Community Manager
Community Manager
November 29, 2013

Usually we get that error with CF10 64-bit with MSAccess. ColdFusion doesn't support MSAccess in 64bit. ColdFusion 10 is only supported with Microsoft Access 2007 and 2010.

Regards,

Anit Kumar