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?
KEVINMCLAURINAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
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)
0
 
jvaldesConnect With a Mentor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.