Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect Latest VFP OleDB installed
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00950138
Message ID:
00950175
Views:
18
Gerard,

You can use sample code below to find location and version info of VFP oledb provider.
* uses Registry class from http://west-wind.com/wwvfppd.htm
oReg = NEWOBJECT("Registry", "registry.prg")
* Get CLSID for VFPOLEDB
lcCLSID = oReg.readregistrystring(HKEY_CLASSES_ROOT, ;
			"vfpoledb.1\CLSID", "")
IF ISNULL(lcCLSID) 
	* VFPOLEDB provider isn't installed/registered
	RETURN .F.
ENDIF
* Get full DLL name	
lcDllFullName = oReg.readregistrystring(HKEY_CLASSES_ROOT, ;
			"CLSID\" + lcCLSID + "\InprocServer32", "")	
DIMENSION laInfo[1]
* Extract version info
? AGETFILEVERSION(laInfo, lcDllFullName)
*browarr(@laInfo)
>I have downloaded and installed the latest VFPOLEDB driver, but am not sure if the latest one is in fact installed .
>
>Is there any way of checking what version I have.
>
>Documentation refers to two folders:
>..\Program Files\Common Files\Ssystem\OleDb
> which has a VFPOLDDB.DLL dated October 2003
>
>..\Program Files\Microsoft Visual Foxpro OleDB Provider
> which does not have any DLL's
>
>I understand from another thread that the VFPOLEDB was update Feb 2004
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform