[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 689
  • Last Modified:

Linked Server From SQL 2005 to FileMaker 9 Pro

I would like to create a linked server between an instance of SQL 2005 and FileMaker Pro 9 server.  What is the best way to do this?
2 Solutions
the best? don't make any link, have filemaker client to work on SQL direct via an odbc driver.
if you don't like the idea of having to setup the odbc driver on all clients machines, then use the odbc feature of filemaker server, but you need the advanced version then, much more expensive.
I have tested filemaker client using mysql5 as its data storage, and the speed is very decent, I expect even better results with MsSQL (generally faster than mysql)
To set up a table from the server you ned toserve the application from the server, Have the appropriate ODBC drivers on the server, Then point to the External Database from inside the Filemaker database. Once you have done that the MSSQL table will show up in your application's database relationship screen. Link the appropriate keys and you are off to the races.

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now