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?