FYI v3.50.0305 of the SQL Server ODBC driver is not the most recent. The latest is 3.60.0319, released with MDAC v2. You can get it along with all of the other latest ODBC drivers and OLE DB components at www.microsoft.com/data. I'm not saying the newer version will solve the problem, but you might want to try it.

>Visual Foxpro 5.0 does not seem to translate Currency (Money) values from MS SQL Server v6.5, using the most recent MSSQL ODBC driver 3.50.0305.
>
>I would really like to find *anyone* who's had any success using VFP Client for SQL Server 6.5, using this ODBC driver to access many fields defined as either SQL Money or SmallMoney. After much trial and error, I've gotten my application working OK, using a combination of Remote Views and SPT statements. Often the Remote Views didn't work for Inserts or Updates and I finally wrote much of this code in stored procedures on the server, called with SQLExec() from VFP.
>
>MS Support/Knowledge Base has acknowledged certain bugs in the ODBC driver with VFP. I say here's another one unless someone else has a solution, I've tried about everything. You can't open a Remote cursor in VFP 5.0, (either SPT or View), Select fields which are SmallMoney on SQL Server... and edit, update, or even see the data!
>
>I did find a workaround to *see* the data: You define defaults in a Remote View, for fields which are Money/SmallMoney on the Server - as Numeric. Then you can see the data. If you define the VFP Remote View defaults as "Currency" the ODBC driver won't translate properly and all you see are zero's. However I still cannot edit or update, or even use the data in VFP reports... so the VFP client is rather limited it seems.