>There are lots of issues with the SQL Server native client when you connect from FoxPro. I think the problem is that the ODBC driver uses newer types that aren't supported by FoxPro and that causes problems. I seem to remember similar issues with Dates (vs DateTimes) and XML fields. The regular SQL Server ODBC driver tends to work better all around but there are a few things that don't work with it that work with the SQL Native Client. So neither one of the solutions offers 100% compatibility of the supported features unfortunately and which is which is not documented anywhere.
>
>In my experience though I've been using the SQL Server driver which works with the most of the stuff I care about.
>
Thanks, Rick. We also use SQL Server driver and it works for us. We don't use date/time types in our application.
If it's not broken, fix it until it is.
My Blog