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:
00950446
Views:
25
>Hi.
>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
>
>Regards,
>
>Gerard

Try this:
local lcPath as String, loConn as adodb.connection

loConn = CREATEOBJECT('ADODB.Connection')
lcPath = _vfp.DefaultFilePath
loConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source="+lcPath +";Mode=ReadWrite;Password='';Collating Sequence=MACHINE"
loConn.Open()
? loConn.Properties('Provider version').value 
loConn.Close()
return 
Latest released version is 8.00.0000.3117. The VFP9 public beta installs 9.0.0.1720
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform