title: SQL linked server with filemaker
body: <p>I have a client with FileMaker Pro 11 Advanced.</p>
  
  <p>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.</p>
  
  <p>These are the steps I have tried</p>
  
  <p>0) Turned on ODBC/JDBC sharing  in File -> Sharing on FileMaker Pro 11 Advanced for "All Users"</p>
  
  <p>1)  installed the FileMaker OBDC driver included on the filemaker disc</p>
  
  <p>2) odbcad32.exe in C:\Windows\SysWOW64 and added a new filemaker System DSN and directed it to the filemaker database.</p>
  
  <p>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.</p>
  
  <p>I get this error:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>FILEMAKER2 is the what i called the System DSN.</p>
  
  <p>What am I doing wrong/What do I need to correct in order to connect to filemaker with SQL?</p>
  
  <p>Is there a connection string to put in for Provider String?</p>
  
  <p>I have the same mismatch error trying to do a test connect with access.</p>
  
  <p>Thank you for any help.</p>