5 Replies Latest reply on Dec 19, 2012 11:44 AM by cfrasnelly@douglaselectric.com

    SQL linked server with FileMaker Pro Advanced via OBDC?



      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.