Do you twitter? I have an account now.

I must say, I missed out on the Web 2.0 social networking scene.  Is it just ME?  I was hanging with some speakers at the Grand Rapids Day of .NET Friday evening, I was amazed the amount of discussion on twitter.  Dan Hounshell mentioned the speaker badge has a spot for a twitter ID, well I have one now.  It’s SteveSchofield so join my network now.


I would be really curious to here from people are on twitter and were skeptical at first then transformed to a ‘twitter’ nut.

IIS 7.0, Classic ASP and Access 2007.

I’m having too much fun thinking of the old days of Classic ASP.  Here is an example of using a Classic ASP page along with IIS 7.0 and Access 2007.  PS: The example shows how to get it working, it’s not meant to be production ready, you should add error coding to block sql injection attacks and other ‘bad’ things that can happen. 


Here is the sample code.
Download here


<%
‘ create conn as adodb.connection and open it
dim strconn
dim conn
dim rs


strconn = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” & Server.MapPath(“App_Dataauthors.accdb”)
set conn = server.createobject(“adodb.connection”)
conn.open strconn
sql = “select * from Authors”
set rs = conn.execute(sql)


%>
<html>
<head><title></title>
</head>
<body>
<table border=”1″>
<%
do while not rs.eof
    response.write “<tr><td><b>” & rs(“Field1”) & “</td><td>” & rs(“Field2”) & “<td></tr>”
    rs.movenext
loop


conn.close
Set conn = nothing
set rs = nothing


%>
</table>
</body>
</html>

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

IIS 7.0 Shared configuration.

One of my favorite features in IIS 7.0 is shared configuration.  It makes setting up and maintaining a web-farm a piece of cake.  Here are some articles I found on the topic.


Shared configuration
http://learn.iis.net/page.aspx/264/shared-configuration/


Introduction
http://learn.iis.net/page.aspx/211/shared-configuration/


Configuring a Web Farm Using IIS Shared Configuration
http://learn.iis.net/page.aspx/453/configuring-a-web-farm-using-iis-shared-configuration/