>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.