May 2, 2023
The ColdFusion ODBC Server service is not running or has not been installed. You may also use the “MS Access with Unicode” driver to connect to MS Access datasources.
Comments
(0)
May 2, 2023
The ColdFusion ODBC Server service is not running or has not been installed. You may also use the “MS Access with Unicode” driver to connect to MS Access datasources.
Newbie 1 posts
Followers: 0 people
(0)

while create datasource with Ms access in cold fusion it give error as

The ColdFusion ODBC Server service is not running or has not been installed. You may also use the “MS Access with Unicode” driver to connect to MS Access datasources please help

i try with following approach still it getting same error

Step 1: Uninstall any existing “Microsoft Access database engine ” from addremove program.

Step2: Ensure that you don’t have any MS Access related data source defined in ColdFusion admin page(under Data Source).

Step 3: Ensure that you have removed all the DSN entries from odbc administrator(both 32 bit and 64 bit under system DSN).

64 bit odbc path: C:WindowsSystem32odbcad32.exe
32 bit odbc path: C:WindowsSysWOW64odbcad32.exe

Step 4: Download and install 64 bit MS Access Database Engine from the link: http://www.microsoft.com/download/en/details.aspx?id=13255

Step 5: Once the installation is completed, you will have to define the DSN using 64 bit drivers.

Use 64 bit odbc path: C:WindowsSystem32odbcad32.exe

Step 6:  Go to the ColdFusion Admin page and map that DSN using MS Access drivers and verify.

 

 

.
0 Comments
Add Comment