Skip to main content
A
Anonymous
August 31, 2011
Question

New User Testing CF9 on Win7 local machine with Access db datasource issue

  • August 31, 2011
  • 1 reply
  • 840 views

New User Testing CF9 (with current Hotfix) on Win7 local machine (current with updates) with Access db datasource issue:

I've followed a few posts on other users with similar issue, but not the same. I'm not knowledgable enough about database drivers or CF to totally understand or alter the solutions to my my situation

In short, I am exploring using CF for a front end to a couple of our companies databases (both older .mdb files and access 2007 .accdb). This has been a long process (years) and I have started taking the final steps.  In order to create a test environment, I've installed CF9 on my Win7 64 bit computer to work as my personal Web server.  Everything was working great until I got to creating an Access Dataasource. While Access is available as a datasource type, I get an error, "Unable to update the NT registry. Variable DRIVERPATH is undefined."  If I ignore the error, and test the connection I made, I get the error: "Connection verification failed for data source: HPBLeads 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"

Am I doing something wrong, or is there a reasonably easy to explain work-around or might a fix be coming in the future?

Any help woudl be greatly appreciated!

*I know Access is a "beginner" solution, but it works for our company (I use a local front end on each users computer with a shared back-end and everything has run clean for years).  We have less than 10 users so the load shouldn't be bad and they don't need to use it overnight so I can do clean backups of hte database and have a time to make changes to the database if needed...

This topic has been closed for replies.

1 reply

Owainnorth
Owainnorth
Inspiring
August 31, 2011

What solutions have you tried so far? I searched for your error string and found a fix on these very forums.

However I do feel the need to comment on this:

might a fix be coming in the future?

and

*I know Access is a "beginner" solution, but it works for our company (I use a local front end on each users computer with a shared back-end and everything has run clean for years).  We have less than 10 users so the load shouldn't be bad and they don't need to use it overnight so I can do clean backups of hte database and have a time to make changes to the database if needed...

The problems with accessing Access are far beyond what you're having here - I don't really understand how the drivers work, but IIRC Microsoft are simply not making a 64-bit JET driver for Access. It's not that Access is a "beginner" solution at all, it's that it's an ancient, antiquated one from the days before you could get MySQL, SQL Server or Oracle for free. Microsoft show absolutely no interest in developing it as a product.

As an aside to your specific issue here I'd point out that your problems will only get worse (and your data harder to migrate) as time goes on, and I'd seriously recommend you start looking at moving to a proper database engine. You'll kick yourself if you don't

A
Anonymous
August 31, 2011

Thanks for the help and direction. While I have looked at a number of other posts, I get worried because I could see myself making some changes and "breaking" something especially since my setup isn't exactly like most of the ones posted about.

Assuming that changing from Access is not an option right now, would it make sense to uninstall CF9 from my Win7 64 bit machine, then install it on a virtual machine that is setup as a 32 bit OS? If I understand correctly, I could develop on my Win7 64 bit machine, then make sure the virtual machine is running (so in effect, my personal web server is on a virtual machine)?

If what I said above would work, then when I get something built that is ready for other users, can I then move my cf files up to a 3rd party host who offers CF server (and make sure they are doing it on a 32 bit server)?

Thanks again.

Owainnorth
Owainnorth
Inspiring
August 31, 2011

If you have access to virtualisation and licensing, that is absolutely what I'd do. I'd create yourself something simple like a Server 2003 machine, and create the development environment on that. I'd then map a network drive to it so I could run CFBuilder locally. Run IIS or whatever your host will use so it's as similar as possible to the live environment.

Like you, I don't like messing around with stuff on my PC, so always offload as much software as possible.

One thing I would say (working for a hosting company myself) - find the hosting beforehand, and make sure it works. Server 2008R2 has been the norm for a couple of years now, and it's 64-bit only; we simply do not have the mechanism any more for putting customers onto 32-bit hosting. Make sure you're aware of that, else you really could end up kicking yourself doing months of development on your Access DB, just to find no-one can host it. If you think you're paranoid about editing registries and the suchlike, hosting companies are even more reluctant

O.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices