469,077 Members | 1,415 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,077 developers. It's quick & easy.

Linked Server and FilemakerPRO

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
Apr 2 '07 #1
0 1326

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by David Gray | last post: by
4 posts views Thread by pheonix1t | last post: by
11 posts views Thread by bofh1234 | last post: by
6 posts views Thread by Neil | last post: by
reply views Thread by Martin | last post: by
1 post views Thread by BillCo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.