AnsweredAssumed Answered

SQL linked server with FileMaker Pro Advanced via OBDC?

Question asked by kyle on Oct 3, 2012
Latest reply on Dec 19, 2012 by


SQL linked server with FileMaker Pro Advanced via OBDC?


     I have a client with FileMaker Pro 11 Advanced.

     I need to be able to connect to the filemaker database via SQL. I am using MS SQL Server 2008 R2, or Server 2012 can be used.

     These are the steps I have tried


     0) Turned on ODBC/JDBC sharing  in File -> Sharing on FileMaker Pro 11 Advanced for "All Users"

     1)  installed the FileMaker OBDC driver included on the filemaker disc

     2) odbcad32.exe in C:\Windows\SysWOW64 and added a new filemaker System DSN and directed it to the filemaker database.

     3) Attempted to add a linked server to SQL using Provider Microsoft OLE DB Provider for OBDC Drivers and the System DSN name i created for Data Source. I left all other fields blank.

     I get this error:


          Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "FILEMAKER2".
          OLE DB provider "MSDASQL" for linked server "FILEMAKER2" returned message "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application". (Microsoft SQL Server, Error: 7303)


     FILEMAKER2 is the what i called the Systenn DSN.


     What am I doing wrong/What do I need to correct in order to connect to filemaker with SQL?

     Is there a connection string to put in for Provider String?


     I have the same mismatch error trying to do a test connect with access.


     Thank you for any help.