>>Two-fold question:
>>1. When using VFP 9 application with SQL Server database and the program executable resides on the application server (but run from the user's desktop), which ODBC driver is being used to connect to SQL Server? ODBC driver installed on the desktop/PC or the one installed on the application server where the application executable reside?
>>2. How do you find out the version of ODBC driver from the VFP 9 application (that is, at run-time)?
>>
>>TIA
>
>I ran the code (big thanks you for the suggestions to Tore and Antonio) that returns ODBC drivers I have installed on my computer. And here are the 3 drives I see:
>SQL Native Client / Version 09.00
>SQL Server Native Client 10.0 / Version 10.00
>SQL Server Native Client 11.0 / Version 03.80
>
>The word "native" confuses me since I thought that the SQL Server Native Client does not work with Varchar(MAX). But I do use Varchar(MAX) on this computer and it works. Does it mean that the first one listed above, SQL Native Client / Version 09.00 is the "old" ODBC driver that does work with Varchar(max)?
This post may be helpful:
http://blogs.msdn.com/b/sqlnativeclient/archive/2008/02/27/microsoft-sql-server-native-client-and-microsoft-sql-server-2008-native-client.aspx.
----------------------------------
António Tavares Lopes