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
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).
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.
2
Replies
AdChoices