|
|
Posted by Martin on 04/02/07 10:29
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
Navigation:
[Reply to this message]
|