>>I just successfuly run following select in Query Analyzer
>>Can you access that table with ODBC?
>
>Yes, I tried it on a different SQL server and it worked fine. Not sure why it works on one and not the other.

Did you compare MDAC and VFP ODBC driver versions on those servers?