>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)?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
