I was trying to setup my SQL Server 2008 to connect to a FileMaker file (much like linked servers can connect to Excel or Access files) but I am having problems.
I installed the DataDirect SequeLink 5.5 ODBC drivers and this piece seems to be working fine (at least the Test Connection is working).
The linked server is actually working since I see all the tables but I cannot seem to be able to access the records inside it.
When I do a usual "SELECT * FROM [FileMakerLinkedServer]...[TableInFileMaker]" it give me :
OLE DB provider "MSDASQL" for linked server "FileMakerLinkedServer" returned an invalid index definition for table "TableInFileMaker".
My linked server is configured as such:
@server = 'FileMakerLinkedServer'
@srvproduct = 'FileMaker',
@datasrc='Name Of ODBC Data Source";
@rmtsrvname = 'FileMakerLinkedServer' ,
@useself = 'FALSE',
@locallogin = NULL,
@rmtuser = 'admin', @rmtpassword = 'FileMakerAdminPassword'
Is there anyway to make this work?