Hi,
I have installed MDAC 2.7 refresh but still can't run the example provided 
with Beginning ASP.NET with C#.
The errors I have got is:

Testing the data connection Provider=Microsoft.Jet.OleDb.4.0;Data 
Source=C:\Inetpub\wwwroot\Northwind.mdb
Connection failed to open.

System.InvalidOperationException: The .Net Data OLE DB Provider
(System.Data.OleDb) requires Microsoft Data Access Components(MDAC). 
Please install Microsoft Data Access Components(MDAC) version 2.6 or 
later. ---> System.Runtime.InteropServices.COMException (0x80040154): 
Class not registered at 
System.Data.Common.UnsafeNativeMethods.CoCreateInstance(Guid& rclsid, 
IntPtr pUnkOuter, Int32 dwClsContext, Guid& riid) at 
System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() --- End of inner 
exception stack trace --- at 
System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() at 
System.Data.OleDb.OleDbConnection.GetObjectPool(Boolean parsing) at 
System.Data.OleDb.OleDbConnection.CreateProvider() at 
System.Data.OleDb.OleDbConnection.Open() at 
ASP.oledb_connection_aspx.Page_Load() in C:\Inetpub\wwwroot\6152 C# 
Code\C# Code\12\oledb_connection.aspx:line 13

Other than MDAC, what else do I need?

I see that your database is in the Web Server root directory.  Ensure that
you have enabled write permissions in IIS.  Right click on the root
directory for your web server and select properties.


Michael A. Bednarz
Programmers Lead The Way
----- Original Message -----
From: "TAL" <tan_ai_leen9@h...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Saturday, January 25, 2003 11:11 AM
Subject: [ado_dotnet] Problem accessing database


> Hi,
> I have installed MDAC 2.7 refresh but still can't run the example provided
> with Beginning ASP.NET with C#.
> The errors I have got is:
>
> Testing the data connection Provider=Microsoft.Jet.OleDb.4.0;Data
> Source=C:\Inetpub\wwwroot\Northwind.mdb
> Connection failed to open.
>
> System.InvalidOperationException: The .Net Data OLE DB Provider
> (System.Data.OleDb) requires Microsoft Data Access Components(MDAC).
> Please install Microsoft Data Access Components(MDAC) version 2.6 or
> later. ---> System.Runtime.InteropServices.COMException (0x80040154):
> Class not registered at
> System.Data.Common.UnsafeNativeMethods.CoCreateInstance(Guid& rclsid,
> IntPtr pUnkOuter, Int32 dwClsContext, Guid& riid) at
> System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() --- End of inner
> exception stack trace --- at
> System.Data.OleDb.OleDbConnection.CreateInstanceMDAC() at
> System.Data.OleDb.OleDbConnection.GetObjectPool(Boolean parsing) at
> System.Data.OleDb.OleDbConnection.CreateProvider() at
> System.Data.OleDb.OleDbConnection.Open() at
> ASP.oledb_connection_aspx.Page_Load() in C:\Inetpub\wwwroot\6152 C#
> Code\C# Code\12\oledb_connection.aspx:line 13
>
> Other than MDAC, what else do I need?
> ===
> Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using ADO.NET
in your applications. The book covers DataSets and Typed DataSets, accessing
data using DataReaders and DataAdaptors, the close relationship between
ADO.NET and XML, how and where to use ADO.NET in your enterprise
applications, and how to use Web Services and ADO.NET to easily pass data
between applications.
> http://www.wrox.com/books/1861007604.htm
>

Yes. I have enable write permission to that folder. This problem still 
exist even after I have uninstalled and reinstalled the .NET Framework.