Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to check if SQL Server Native Client are installed?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01616877
Message ID:
01616878
Views:
69
>Hi All
>
>I'm using a SQL Azure Db in a project with VFP.
>Everything works well so far. Now, accessing the SQL Azure DB needs SQL Server Native Client drivers v10 or V11.
>
>The idea is to check for the drivers and if not installed, install them.
>
>a) How can I check from VFP if the drivers are installed? (other than trap the error, which I'm doing already).
>
>b) How to install them programmatically if needed?
>I'm thinking on including the sqlnclix32.msi in the VFP exe and then extracting it and running it, but I'm wondering if there is a best way.
>
>Thanks in advance!
>
>Max

Hi Max,

they are in the registry at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.

The FFC registry class is your friend. :)

Hank
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform