DataSource creation errors

[Silk Trial Site]

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.

[Anit_Kumar]

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

[Silk Trial Site]

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]

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

[Silk Trial Site]

I downloaded the 32 bit AccessDatabaseEngine and installed it as directed.  All worked fine .  I ran the odbcad32.exe and chose the Microsoft Access Driver and then I created the Datasource Administrator and created the Datasource with the same name.  All worked correctly and the Datasource shows that it is working properly.  But when I tried to run my Login routine on my Login Page I got an error message in the code generated by the ColdFusion Login Wizard.  When Inspecting the code I don't seen any errors on line 5 which is flagged as containing an error.  I screen captured the Code and the Error message and attached them to this discussion.  Could you look at it and see what you 

can determine

[Silk Trial Site]

Correction in my last message.  I meant to say error was on line 6 of code not line 5!

[Anit_Kumar]

That sounds great.

Silk Trial Site wrote:

All worked correctly and the Datasource shows that it is working properly.

Change the "FORM.EAA Number" to "FORM. EAANumber" in line number 6, in the select eaanumber, password from EAAMembers. Change the same on all the places where applicable (like in line# 2)

Silk Trial Site wrote:

But when I tried to run my Login routine on my Login Page I got an error message in the code generated by the ColdFusion Login Wizard.

Regards,

Anit Kumar