Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to determine if SQL Native Client is installed?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01470331
Message ID:
01470335
Vues:
60
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform