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 cfrasnelly@douglaselectric.com

Title

SQL linked server with FileMaker Pro Advanced via OBDC?

Post

     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.

Outcomes