>>>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.

>>>2. How do you find out the version of ODBC driver from the VFP 9 application (that is, at run-time)?
>>>
>>>TIA