AnsweredAssumed Answered

64bit xDBC driver for use with Micorosoft Office 2010 64bit applications

Question asked by Narcan on Jun 23, 2011
Latest reply on Jul 14, 2011 by JonJ

Summary

64bit xDBC driver for use with Micorosoft Office 2010 64bit applications

Product

FileMaker Pro

Version

11

Operating system version

Windows 7 64bit

Description of the issue

Installing the current supplied xDBC driver does not show as an ODBC driver in the 64bit Windows 7 operating environment. When using the 32bit ODBC driver with Microsoft Office 2010 64bit applications report: "The specified DSN contains an architecture mismatch between the Driver and Application"

Does an Filemaker 64bit xDBC driver exist so we can use MS Office 2010 64bit applications to query our Filemaker database hosted on a Filemaker Server Advanced server?

Steps to reproduce the problem

Install the xDBC driver on a 64bit W7 operating system. Install MS Office 2010 Pro 64bit

Run C:\Windows\SysWOW64\odbcad32.exe to configure the ODBC connection to the Filemaker Server hosted database

Start MS Excel or MS Access and try to connect to the database using the previously configured 32bit driven ODBC connection

Expected result

Import of Filemaker hosted data

Actual result

"The specified DSN contains an architecture mismatch between the Driver and Application"

Exact text of any error message(s) that appear

"The specified DSN contains an architecture mismatch between the Driver and Application"

Workaround

None

access.JPG

Outcomes