Skip to main content
April 2, 2011
Question

CF 9 vs MS Access

  • April 2, 2011
  • 2 replies
  • 602 views

OK I give- it seems virtually impossible to create a MS Access datasource in CF 9- do I have to go backwards here (revert to ealier CF server), or is there a solution- i.e. step by step??

Connection verification failed for data source: consumer.mdb
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

over and over.

This topic has been closed for replies.

2 replies

Inspiring
April 5, 2011

You may find this blog post helpful as a temporay band-aid: http://wardlawclaims.blogspot.com/2011/01/connecting-to-access-2007-database.html

I also agree with Adam Cameron.  MS Access is generally not a good choice as the backend to a web site and I would recommend that you migrate your data to a different database.

Inspiring
April 2, 2011

Sounds to me like you're trying to use 32-bit drivers on a 64-bit system? That's not a CF problem: that's just trying to do something that simply won't work.

I don't think there •are• 64-bit ODBC drivers are there? Or maybe just not Access ones.

Do you need to be using Access? It's not really an appropriate tool for a back-end for a web-app, as it's just a desktop application (so like single-user, etc).

--

Adam