>>Hi,
>>
>>Is it possible (and if yes, how) to determine from VFP code if SQL Server Native Client (for use with CursorAdapter DataSourceType = 'ADO') is installed?
>>
>>TIA
>
>Hi Dmitry,
>
>Something like:
>
>
>sqlsetprop(0,'DispLogin',3)
>localPC=ALLTRIM(LEFT(SYS(0),AT("#", SYS(0))-1))
>release gn
>store SQLSTRINGCONNECT(;
> 'Driver={SQL Native Client};'+;
> 'SERVER='+localPC+'\SQLEXPRESS;'+;
> 'Trusted_Connection=Yes');
> TO gn
>if gn<=0
>* not installed
>.....
>>
>There are differences in the native driver={Name} depending on SQL Version.
>
>Good Luck
Thank you, Yuri. I will try this approach.
"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
