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?
Kind regards
Phi Hollingworth.