Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

CF 9 vs MS Access

Guest
Apr 01, 2011 Apr 01, 2011

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.

TOPICS
Database access
618
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Apr 02, 2011 Apr 02, 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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Enthusiast ,
Apr 05, 2011 Apr 05, 2011
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources