Set to Multiple and enable Local and remote connections.Open your database, this can be a FM database on a remote server over TCP/IP, connect up as you normally would to access the file.The linked server connection only works via the local client, so for the linked server to work you have to have your Filemaker Pro database loaded and remotely accessible. In the provider choose “Microsoft OLE DB Provider for ODBC Drivers”.Expand to “Server Objects” :: “Linked Servers”.Tick “Use Remote Connection” and add the loop back IP address, 127.0.0.1.On the General Tab give the connection a generic name, (can be anything), i used FMPro.Go start :: administrative tools :: Data Source (ODBC).This installs the 32-bit filemaker pro driver to allow you to create an ODBC data source. I had a 64-bit machine, and I could run the 32-bit odbc datasource tool and set-up and test the connection but I could not get my 64-bit version of Sql Management studio to find the 32-bit System DSN I had created, so I jumped over to a 32-bit virtual machine with SQL 2008 on it and everything worked more easily.Įnsure that you have FileMaker pro installed on the box that you want to create the linked server connection on. I was only able to make this work on a 32-bit machine. The problem is that you want to extract data from a FileMaker Pro 6.0 database by creating a linked server connection from SQL Server.
This one may be a bit obscure but I had to do this for data conversion from a legacy system the other day and the FileMaker documentation was pretty light on, but I eventually got it to work.
0 kommentar(er)
