I did have it on a network drive to start with and then moved it to the local hard drive (D:).... still no luck.
I have found a solution to my problem though - it isn't something I can use in a live environment but it works for now... Still looking for the correct way to handle this is a secure manner...
My fix is to change the MACHINE.CONFIG file and change the
element attributes for username and password from
username=machine password=AutoGenerate
to (wait for it)
username=administrator password=xxxxxxx
Yes it sucks - but it works for me....
Any other suggestions welcome.
Jon
>One thing I noticed is that you have the data in the D: drive. If this is a network drive, you might have the access rights issue, as you already figured, I am sure. I would, for testing, copy the data to the local drive (C:) and test is that way. In my experience, if you installed .NET framework on the web server, it automatically configured ASPNET account with access rights to all local folders. And of course, I would unregister and then register the VFP OLE DB provider, just in case.
>
>HTH.
>
>>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
