Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to detect Latest VFP OleDB installed
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00950138
Message ID:
00950446
Vues:
27
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform