>Hi
>
>I am having problems with switching from ODBC to OLE DB.
>
>I have MDAC 2.8 installed along with the latest VFP OLEDB drivers running on Win2k with all the current SP and critical updates installed.
>
>I am getting the following error message whenever I try to open an OLE DB connection:
>
>--------
>
>ADODB.Connection (0x800A0E7A)
>Provider cannot be found. It may not be properly installed.
>/wr2003/test2004/oledb/page1.asp, line 17
>
>--------
>
>The offending code is as follows:
>
>dim cConnectString, oRS, oConn
>cConnectString = "Provider=VFPOLEDB.1;Data Source=\\fileserver\fsvacancies\newdata.dbc;Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE"
>Set oConn = CreateObject("ADODB.Connection")
>oConn.ConnectionString = cConnectString
>oConn.ConnectionTimeout = 30
>oConn.Open
>
>-----------
>
>I have tried reinstalling the OLEDB drivers which has not helped.
>
>Anyone have any ideas?
Try manually registering with regsvr32 and remove .1
Cetin