• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Can establish ODBC connection to .mdb database file after upgrading to CF9

Bringing up a new Windows 2008 server with CF9, going to retire the server with CF7MX.  Copied the .mdb file from the old server and uploaded to the new server but I cannot seem to get CF9 to attach to the database file.

When I attempt to use the javascript functionality to browse to the file I get and error message which I have taken a screenshot and attached here.

When I attempt to manually enter the path to the file I get the following error message:

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

Any help?
  • 3
1 Solution
EricHomaAuthor Commented:
Should say: Can not establish ODBC connection to .mdb database file after upgrading to CF9
Do you need DSN's for that ODBC connection?  

I know anytime we do anything over ODBC we have to update/replace our DNS's related to the ODBC connections.
EricHomaAuthor Commented:
With MX7 you could click on datasources and then click add datasource.  Pull down the correct driver and hit add.  That was all it took, it would connect and verify.
(no points .. just a quick comment)

I don't use Access, but I've seen that error message (and possible fixes) bandied about a lot.  Seems related to using the 64 bit version. Here are a few threads turned up by a quick search (but there are lots more)


HTH. Best of luck.
EricHomaAuthor Commented:
It seems that we had to uload the 64 bit version of CF9 and load the 32 bit version in order to use a .mdb file as a datasource.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now