Posted by Martin on 04/02/07 10:31

I want to use Filemaker PRO/Server as a linked server in SQL Server (2000)
I have a ODBC Driver (DataDirect ODBC 5.4) for Filemaker database

When I run a query using the linked server and the selected columns are
text-fields from Filemaker, I get the following error:

Server: Msg 7341, Level 16, State 2, Line 1
Could not get the current row value of column
'[MSDASQL].fld_articleoption1' from the OLE DB provider 'MSDASQL'.
[OLE/DB provider returned message: Requested conversion is not supported.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetData returned
0x80040e1d].

When I use only numeric fields or datefields in my query, the query gives
normal result. So the problem is only with text-fields.

select * from openquery(FM, 'SELECT id_article, fld_articleoption1 FROM
Articles WHERE id_article < 97')

I searched all over the internet, but nowhere there is an answer for this
problem.

Anyone can help me?

Thanks

Martin

• Next in forum: SQL server 2005 Express - Vista - Invalid object name '#spdbdesc'
• Prev in forum: Linked Server and FilemakerPRO
• Thread view: Linked Server and FilemakerPRO

[Reply to this message]