Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to determine if SQL Native Client is installed?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01470331
Message ID:
01470335
Views:
59
>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		&& database master
if gn<=0 
* not installed
.....
There are differences in the native driver={Name} depending on SQL Version.

Good Luck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform