The first one is version independent ProgID. The second one is version specific ProgID. In case of VFP OLE DB provider there ever was only version 1 so either one will work.
In general, when version independent ProgID is specified, Windows will use the lates instaled version of the COM server/ActiveX control.
>When specifying ConnectionString before opening AdoDb object I have seen two different syntax-es:
>
>
>loConn = Createobject("Adodb.connection")
>loConn.ConnectionString = "Provider=VFPOLEDB;Data Source="+Sys(2023)
>
>or
>
>loConn = Createobject("Adodb.connection")
>loConn.ConnectionString = "Provider=VFPOLEDB.1;Data Source="+Sys(2023)
>
>
>Note the difference in the Provider name. In one case it is VFPOLEDB and in the other case it is VFPOLEDB.1. Is this a significant difference? Which name will make the code better?
--sb--