>>>>>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?
>>>>
>>>>The ODBC driver on PC where application runs.
>>>>
>>>>
>>>
>>>Thank you. Too bad I can't have a code in my application to "alert" the user that his/her ODBC driver is not compatible with my app.
>>
>>See message#
1627108. You can add code to alert the user if lcDriver is empty.
>>
>
>I ran the code (and thank you again for it). And in my case (my PC), the laODBCData returns one item "SQL Server". How does it tell me the ODBC driver version?
If I am not mistaken, 10, 11 and 11.0 respectively is the version number.