Hi,
I'm trying to make a simple ASP.NET page to display data from some VFP6 free tables....
I am getting the following error whenever I try to access the table:
OleDbException (0x80040154): No error information available: REGDB_E_CLASSNOTREG(0x80040154).]
[InvalidOperationException: The 'VFPOLEDB.1' provider is not registered on the local machine.]
System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr)
System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr)
System.Data.OleDb.OleDbConnection.Open()
The code fragment that generates this is:
Dim strConnect As String
strConnect = "User ID=;DSN=;Collating Sequence=MACHINE;Data Source='D:\DATA';Provider='VFPOLEDB.1';Cache Authentication=False;Mask Password=False;persist security info=False;Mode='Read|Share Deny None';Extended Properties=;Encrypt Password=False"
Dim VFP8Connection = New OleDbConnection
VFP8Connection.ConnectionString = strConnect
' next line throws error...
VFP8Connection.Open()
My config is a fully patches Win 2000 Server, VFP OLE DB Provider for V Foxpro 8.0, Visual Studio 2003.
The IIS Users IUSR_xxx and IWAM_xxx have read access to the D:\WDATA folder.
Any assistance appreciated.
Thanks
Jon Nelson