Filemaker 9 Linked Server on SQL Server 2005
Posted on 2007-07-31
Im trying to create a Linked Server within SQL Server 2005, to Filemaker 9 Server. I can sucessfully create it and make a query like: select count(*) from OPENQUERY(FILEMAKER,'select * from test') .
However, if instead i make a select * it will return me:
OLE DB provider "MSDASQL" for linked server "FILEMAKER" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].idpais" from OLE DB provider "MSDASQL" for linked server "FM".
that request conversion is not allowed. I think it have to do with text -> varchar mapping. If i select integer fields, all is ok.
How can I solve this? Anyone knows a reliable ODBC driver for filemaker other than Sequelink? Is there any dedicated provider to filemaker? is any workaround to use a linked server with JDBC instead of ODBC?
I have the DSN properly configured using DataDirect SequeLink 5.5 Client for ODBC.
Im doing this at Microsoft SQL Server Management Studio Express