Hi, Phil-
>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
Do, definitely, leave off the ".1" of the Provider clause. Have you by any chance tried this in a small test Fox PRG on a simple table? Bit of a desperate suggestion, I admit.
>I have tried reinstalling the OLEDB drivers which has not helped.
Did you first try to unregister the provider and the reinstall the provider--from the setup file, not just run regsrv32?
>Anyone have any ideas?
I don't know if it helps, here's what I did recently when I has having trouble downgrading my provider...
1. ran regsrv32 -u vfpoledb.dll
2. rebooted,
3. renamed the vfpoledb.dll (in the "Program Files\Common Files\System\OLEDB" directory)
4. wrote a test program in Fox to assure myself there was no provider
5. Downloaded and ran a fresh copy of the provider setup from
http://tinyurl.com/lv4a