IIS 7.0, Access 2007 and ASP.NET 2.0

I don’t get a chance to write webpage code very often, but in my early days of doing samples, it was common to use an Access database.  Access 2007 is the latest version available.  The drivers weren’t installed on my Windows Server 2008 server when I was trying to run an example.  I got the following error.


The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.


A quick search found the add-on, the link is listed below.  I don’t recommend using Access for medium or higher volume applications, SQL Server or another database is appropriate.  This was a fun exercise and I wanted to share my experience.  Hope this helps.


2007 Office System Driver: Data Connectivity Components
—————–
http://www.microsoft.com/downloads/thankyou.aspx?familyId=7554f536-8c28-4598-9b72-ef94e038c891&displayLang=en


My sample
—————–
http://iislogs.com/articles/access2007/authors.aspx


Download the code
—————–
http://iislogs.com/articles/access2007/authors.zip


Sample Code
—————–
<%@ Page Language=”VB” AutoEventWireup=”false” CodeFile=”authors.aspx.vb” Inherits=”_IISLogscom” %>


<!DOCTYPE html PUBLIC “-//W3C//D
TD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd“>


<html xmlns=”http://www.w3.org/1999/xhtml“>
<head runat=”server”>
    <title>Untitled Page</title>
</head>
<body>
    <form id=”form1″ runat=”server”>
   


   
                    AllowSorting=”True” AutoGenerateColumns=”False” DataKeyNames=”ID”
            DataSourceID=”SqlDataSource1″>
           
               
                                    ReadOnly=”True” SortExpression=”ID” />
                                    SortExpression=”Field1″ />
                                    SortExpression=”Field2″ />
                                    SortExpression=”Field3″ />
           
       
                    ConnectionString=””
            ProviderName=””
            SelectCommand=”SELECT [ID], [Field1], [Field2], [Field3] FROM [Authors]”>
       
   
   


    </form>


</body>
</html>


Code Behind
—————–
Partial Class _IISLogscom
    Inherits System.Web.UI.Page


End Class



Web.config file
—————–
<?xml version=”1.0″?>
<configuration>
    <connectionStrings>
        <add name=”ConnectionString” connectionString=”Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot;/App_Data/authors.accdb&quot;” providerName=”System.Data.OleDb” />
    </connectionStrings>
</configuration>


Cheers,


Steve Schofield
Microsoft MVP – IIS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s