﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Knowledgebase » Knowledgebase » Programming » ASP.NET</title><generator>InstantKB.NET 2.0.4</generator><description>Knowledgebase</description><link>http://www.webhost4life.com/HostingKB/</link><webMaster>kb@webhost4life.com</webMaster><lastBuildDate>Fri, 20 Nov 2009 18:56:33 GMT</lastBuildDate><ttl>20</ttl><item><title>How do I change my asp.net script to use Session State instead of InProc?</title><link>http://www.webhost4life.com/HostingKB/Goto50079.aspx</link><description>&lt;font size="2"&gt;All of our servers have State Server enabled.&lt;br /&gt;&lt;br /&gt;To use it, you just need to edit your web.config session state section. Below is an example:&lt;br /&gt;&lt;br /&gt;&amp;lt;configuration&gt;&lt;br /&gt;    &amp;lt;system.web&gt;&lt;br /&gt;        &amp;lt;sessionState mode="StateServer"&lt;br /&gt;                      stateConnectionString="tcpip=127.0.0.1:42424"&lt;br /&gt;                      cookieless="false"&lt;br /&gt;                      timeout="20"&gt;&lt;br /&gt;        &amp;lt;/sessionState&gt;&lt;br /&gt;    &amp;lt;/system.web&gt;&lt;br /&gt;&amp;lt;/configuration&gt;&lt;/font&gt;&lt;br /&gt;</description><pubDate>Mon, 19 Oct 2009 15:15:12 GMT</pubDate><dc:creator>Tim</dc:creator></item><item><title>Sending Email using SMTP Authentication</title><link>http://www.webhost4life.com/HostingKB/Goto50203.aspx</link><description>&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;span class="Highlight"&gt;You need to:&lt;br /&gt;1. use your email server as the smtp, this is usually mail.yourdomain.com&lt;br /&gt;2. authenticate to the smtp server&lt;br /&gt;3. make sure your "From" address is exactly the same as your login address in your code&lt;/span&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;PHP&lt;/font&gt;&lt;/p&gt;&lt;font face="Arial" size="1"&gt;&lt;font size="2"&gt;Sample php code using ASPEMAIL COM . (aspemail COM  is supported by us) Please refer to &lt;a href="KnowledgebaseArticle50141.aspx"&gt;this article&lt;/a&gt;.&lt;br /&gt;If you like to use PHPMAILER, please refer to &lt;a href="KnowledgebaseArticle50140.aspx"&gt;this article&lt;/a&gt;.&lt;/font&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;C# 1.1&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;private void Page_Load(object sender, System.EventArgs e)&lt;br /&gt;{&lt;br /&gt; MailMessage mail = new MailMessage();&lt;br /&gt; mail.To = "&lt;a href="mailto:me@mycompany.com"&gt;me@mycompany.com&lt;/a&gt;";&lt;br /&gt; mail.From = "&lt;a href="mailto:you@yourcompany.com"&gt;you@yourcompany.com&lt;/a&gt;";&lt;br /&gt; mail.Subject = "this is a test email.";&lt;br /&gt; mail.Body = "Some text goes here";&lt;br /&gt; mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"&gt;http://schemas.microsoft.com/cdo/configuration/smtpauthenticate&lt;/a&gt;", "1"); //basic authentication&lt;br /&gt; mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/sendusername"&gt;http://schemas.microsoft.com/cdo/configuration/sendusername&lt;/a&gt;", "my_username_here"); //set your username here&lt;br /&gt; mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/sendpassword"&gt;http://schemas.microsoft.com/cdo/configuration/sendpassword&lt;/a&gt;", "super_secret"); //set your password here&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt; SmtpMail.SmtpServer = "mail.mycompany.com";  //your real server goes here&lt;br /&gt; SmtpMail.Send( mail );&lt;br /&gt;}&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;C# 2.0&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;static void Authenticate()&lt;br /&gt;{&lt;br /&gt;//create the mail message&lt;br /&gt;MailMessage mail = new MailMessage();&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;//set the addresses&lt;br /&gt;mail.From = new MailAddress("&lt;a href="mailto:me@mycompany.com"&gt;me@mycompany.com&lt;/a&gt;");&lt;br /&gt;mail.To.Add("&lt;a href="mailto:you@yourcompany.com"&gt;you@yourcompany.com&lt;/a&gt;");&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;//set the content&lt;br /&gt;mail.Subject = "This is an email";&lt;br /&gt;mail.Body = "this is the body content of the email.";&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;//send the message&lt;br /&gt;SmtpClient smtp = new SmtpClient("mail.yourdomain.com");&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;//to authenticate we set the username and password properites on the SmtpClient&lt;br /&gt;smtp.Credentials = new NetworkCredential("username@yourdomain.com", "secret"); &lt;br /&gt;smtp.Send(mail);&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;}&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;VB.net 1.1&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;Private Sub Page_Load(sender As Object, e As System.EventArgs)&lt;br /&gt;   Dim mail As New MailMessage()&lt;br /&gt;   mail.To = "&lt;a href="mailto:me@mycompany.com"&gt;me@mycompany.com&lt;/a&gt;"&lt;br /&gt;   mail.From = "&lt;a href="mailto:you@yourcompany.com"&gt;you@yourcompany.com&lt;/a&gt;"&lt;br /&gt;   mail.Subject = "this is a test email."&lt;br /&gt;   mail.Body = "Some text goes here"&lt;br /&gt;   mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"&gt;http://schemas.microsoft.com/cdo/configuration/smtpauthenticate&lt;/a&gt;", "1") 'basic authentication&lt;br /&gt;   mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/sendusername"&gt;http://schemas.microsoft.com/cdo/configuration/sendusername&lt;/a&gt;", "my_username_here") 'set your username here&lt;br /&gt;   mail.Fields.Add("&lt;a href="http://schemas.microsoft.com/cdo/configuration/sendpassword"&gt;http://schemas.microsoft.com/cdo/configuration/sendpassword&lt;/a&gt;", "super_secret") 'set your password here&lt;br /&gt;   SmtpMail.SmtpServer = "mail.mycompany.com" 'your real server goes here&lt;br /&gt;   SmtpMail.Send(mail)&lt;br /&gt;End Sub 'Page_Load&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;VB.net 2.0&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;&amp;lt;%@ Import Namespace="System.Net.Mail" %&amp;gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;Sub Authenticate()&lt;br /&gt;'create the mail message&lt;br /&gt;Dim mail As New MailMessage()&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;'set the addresses&lt;br /&gt;mail.From = New MailAddress("&lt;a href="mailto:me@mycompany.com"&gt;me@mycompany.com&lt;/a&gt;")&lt;br /&gt;mail.To.Add("&lt;a href="mailto:you@yourcompany.com"&gt;you@yourcompany.com&lt;/a&gt;")&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;'set the content&lt;br /&gt;mail.Subject = "This is an email"&lt;br /&gt;mail.Body = "this is the body content of the email."&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;'send the message&lt;br /&gt;Dim smtp As New SmtpClient("mail.yourdomain.com")&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;'to authenticate we set the username and password properites on the SmtpClient&lt;br /&gt;smtp.Credentials = New NetworkCredential("username@yourdomain.com", "secret")&lt;br /&gt;smtp.Send(mail)&lt;br /&gt;End Sub 'Authenticate&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;ASP&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt; &amp;lt;%&lt;br /&gt; Dim ObjSendMail&lt;br /&gt; Set ObjSendMail = Server.CreateObject("Persits.MailSender")&lt;br /&gt; &lt;br /&gt; ObjSendMail.Host = "mail.somesite.com"&lt;br /&gt; ObjSendMail.From = "someone@somesite.com"&lt;br /&gt; ObjSendMail.FromName = "someone"&lt;br /&gt; ObjSendMail.AddAddress "somebodyelse@somesite.com"&lt;br /&gt; ObjSendMail.Subject = "your subject"&lt;br /&gt; ObjSendMail.Body = "your email body"&lt;br /&gt;  &lt;br /&gt;Our email server requires SMTP Authentication. Replace the username and password below.&lt;br /&gt;ObjSendMail.Username = "SMTPUsername"&lt;br /&gt;ObjSendMail.Password = "SMTPPassword"&lt;br /&gt; &lt;br /&gt; On Error Resume Next&lt;br /&gt; &lt;br /&gt; ObjSendMail.Send&lt;br /&gt; If Err &amp;lt;&gt; 0 Then&lt;br /&gt;    Response.Write "Error encountered: " &amp;amp; Err.Description&lt;br /&gt; End &lt;/font&gt;&lt;/font&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;If&lt;br /&gt; &lt;br /&gt; Set ObjSendMail = nothing&lt;br /&gt;%&gt; &lt;/font&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;Perl&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;&lt;font size="2"&gt;Please refer to &lt;a href="KnowledgebaseArticle50120.aspx"&gt;this article&lt;/a&gt;&lt;/font&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&lt;font face="Arial" size="4"&gt;Coldfusion&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;&amp;lt;Cfmail server="&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;SMTPUsername&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;:&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;SMTPPassword&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;@mail.&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;somesite.com"&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;&lt;br /&gt;             from="&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;someone@somesite.com&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;"&lt;br /&gt;             to="&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;somebodyelse@somesite.com&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;"&lt;br /&gt;             subject="&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;your subject&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;your email body&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 0);"&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;&lt;br /&gt;&amp;lt;/CFMAIL&gt;&lt;/font&gt;&lt;/font&gt;&lt;font style="background-color: rgb(255, 255, 255);"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/p&gt;&lt;br /&gt;&lt;font face="Arial" size="1"&gt;&lt;font style="background-color: rgb(255, 255, 255);" /&gt;&lt;/font&gt;</description><pubDate>Wed, 26 Aug 2009 10:21:57 GMT</pubDate><dc:creator>Tim</dc:creator></item><item><title>How to publish asp.net project by Visual Web developer 2008 by ftp/http</title><link>http://www.webhost4life.com/HostingKB/Goto50503.aspx</link><description>You can publish your asp.net project by either ftp or http. This article will show you how to publish your asp.net project to web server using visual web developer express edition. If your web application is a &lt;em&gt;&lt;strong&gt;Web Site&lt;/strong&gt;&lt;/em&gt; rather than &lt;em&gt;&lt;strong&gt;Project &lt;/strong&gt;&lt;/em&gt;in visual web developer, you may refer to &lt;a href="http://www.asp.net/learn/hosting/tutorial-04-cs.aspx" target="_blank"&gt;this article&lt;/a&gt; for publishing. &lt;br /&gt;&lt;br /&gt;&lt;br /&gt;For http, &lt;br /&gt;1. You will have to log in hosting control panel &gt; site admin &gt; install Frontpage extension to the domain/subdomain IIS entry.&lt;br /&gt;2. Open Visual Web developer &gt; Open your project &gt; Click on "Build" on the top panel &gt; Click on "Publish Webapplication" &lt;br /&gt;3. Input the url, for example, http://webapp1.domain.com &lt;br /&gt;4. Select "Only files need to run the application". If you select "all project files", it will include everything inside your project folder, which will take much longer time to publish.&lt;br /&gt;5. You will see a log in prompt. Please input username and password to be the same as your control panel log in credential. It will start publishing if you have installed Frontpage Extension properly in steps 1. If it is failed, you are suggested to recalculate or reinstall Frontpage extension under hosting control panel &gt; site admin &gt; Frontpage &lt;br /&gt;6. After publish complete, the output panel on the bottom of your visual web developer will show you successful result.&lt;br /&gt;&lt;br /&gt;For ftp,&lt;br /&gt;&lt;br /&gt;1. Open Visual Web developer &gt; Open your project &gt; Click on"Build" on the top panel &gt; Click on "Publish Webapplication"&lt;br /&gt;2. Input the ftp host, for example, ftp://webapp1.domain.com or if your site doesn't resolve to your web server IP, you will have to input ftp host with your server IP, for example, ftp://10.10.10.1.&lt;br /&gt;3. Select "Only files need to run the application". If you select "allproject files", it will include everything inside your project folder,which will take much longer time to publish.&lt;br /&gt;4. You will see a log in prompt. Please input your ftp account as the log in credential. Please make sure you are publishing to the right path because this will overwrite the existing files in the publish folder. Let's say if you would like to publish to site webapp1.domain.com which mapped to physical path D:\hosting\member\memberA\site1, if you are using a ftp account which root path mapped to physical path D:\hosting\memebr\memberA, in step 2, you will have to input the ftp host as ftp://webapp1.domain.com/site1. Otherwise, it will publish to wrong path and overwrite the existing files.&lt;br /&gt;5. After publish complete, the output panel on the bottom of your visual web developer will show you successful result.&lt;br /&gt;&lt;br /&gt;</description><pubDate>Tue, 11 Aug 2009 16:59:01 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Why cannot upload file through my web site?</title><link>http://www.webhost4life.com/HostingKB/Goto50493.aspx</link><description>When upload file through web site, web site user need to have write permission for the folder which used to store file.&lt;br /&gt;Please click &amp;lt;&lt;a href="http://www.webhost4life.com/HostingKB/KnowledgebaseArticle50482.aspx"&gt;here&lt;/a&gt;&gt; for instruction of how to set permission.&lt;br /&gt;&lt;br /&gt;Windows Account :&lt;br /&gt;For ASP.NET application, web user is "Network Service" (for win2003 &amp;amp; win2008) and "ASPNET" (for win2000)&lt;br /&gt;For other applications, web user is "IUSR_memberID"&lt;br /&gt;&lt;br /&gt;Linux Account:&lt;br /&gt;Please change folder permission to 777&lt;br /&gt;&lt;br /&gt;*For security reason, please only grant write permission for the folder(s) which need it.&lt;br /&gt;</description><pubDate>Mon, 29 Jun 2009 05:22:57 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How do I connect MySQL DB with MySQL .NET connector</title><link>http://www.webhost4life.com/HostingKB/Goto50491.aspx</link><description>There is no installation required on server,  you only need to &lt;span class="t_tag" onclick="tagshow(event)" href="http://evening.mysite4now.com/tag.php?name=upload"&gt;upload&lt;/span&gt; the Mysql.Data.&lt;span class="t_tag" onclick="tagshow(event)" href="http://evening.mysite4now.com/tag.php?name=dll"&gt;dll&lt;/span&gt; to the site "bin" folder. &lt;br /&gt;You can download the MySQL .NET connector in '&lt;a href="http://dev.mysql.com/downloads/connector/net/6.0.html"&gt;http://dev.mysql.com/downloads/connector/net/6.0.html&lt;/a&gt;'.&lt;br /&gt;The MySQL.Data.dll locates on the "Installation path\Assemblies". Default path is "C:\Program Files\MySQL\MySQL Connector Net 6.0.3\Assemblies".&lt;br /&gt;&lt;br /&gt;********************************************************************&lt;br /&gt;[Sample .aspx]&lt;br /&gt;&amp;lt;%@ Page Language="VB" debug="true" %&amp;gt;&lt;br /&gt;&amp;lt;%@ Import Namespace = "System.Data" %&gt;&lt;br /&gt;&amp;lt;%@ Import Namespace = "MySql.Data.MySqlClient" %&gt;&lt;br /&gt;&amp;lt;script language="VB" runat="server"&gt;&lt;br /&gt;&lt;br /&gt;Sub Page_Load(sender As Object, e As EventArgs)&lt;br /&gt;&lt;br /&gt;    Dim myConnection  As MySqlConnection&lt;br /&gt;    Dim myDataAdapter As MySqlDataAdapter&lt;br /&gt;    Dim myDataSet     As DataSet&lt;br /&gt;&lt;br /&gt;    Dim strSQL        As String&lt;br /&gt;    Dim iRecordCount  As Integer&lt;br /&gt;&lt;br /&gt;        myConnection = New MySqlConnection("Server=mysqlxxx.mysite4now.com;Database=DBname;Uid=DB_ID;Pwd=DB_pw")&lt;br /&gt;&lt;br /&gt;        strSQL = "SELECT * From [table name];"&lt;br /&gt;&lt;br /&gt;    myDataAdapter = New MySqlDataAdapter(strSQL, myConnection)&lt;br /&gt;    myDataSet = New Dataset()&lt;br /&gt;        myDataAdapter.Fill(myDataSet, "[table name]")&lt;br /&gt;&lt;br /&gt;    MySQLDataGrid.DataSource = myDataSet&lt;br /&gt;    MySQLDataGrid.DataBind()&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;&amp;lt;/script&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;html&gt;&lt;br /&gt;&amp;lt;head&gt;&lt;br /&gt;&amp;lt;title&gt;MySQL test&amp;lt;/title&gt;&lt;br /&gt;&amp;lt;/head&gt;&lt;br /&gt;&amp;lt;body&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;form id="Form1" runat="server"&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;asp:DataGrid id="MySQLDataGrid" runat="server" /&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;/form&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;/body&gt;&lt;br /&gt;&amp;lt;/html&gt; &lt;br /&gt;********************************************************************&lt;br /&gt;&lt;br /&gt;In some application you require to add the following lines in web.config. &lt;br /&gt;[web.config]&lt;br /&gt;&lt;br /&gt;&amp;lt;system.web&gt;&lt;br /&gt;                &amp;lt;compilation de&lt;span class="t_tag" onclick="tagshow(event)" href="http://evening.mysite4now.com/tag.php?name=bug"&gt;bug&lt;/span&gt;="true" urlLinePragmas="true"&gt;&lt;br /&gt;                        &amp;lt;assemblies&gt;&lt;br /&gt;                                &amp;lt;add assembly="MySql.Data,Version=6.0.3.0, Culture=neutral,PublicKeyToken=C5687FC88969C44D"/&gt;&amp;lt;/assemblies&gt;&amp;lt;/compilation&gt;&lt;br /&gt;                &amp;lt;authentication mode="Windows"/&gt;&lt;br /&gt;                &amp;lt;customErrors mode="Off"/&gt;&lt;br /&gt;        &amp;lt;/system.web&gt;&lt;br /&gt;        &amp;lt;system.data&gt;&lt;br /&gt;    &amp;lt;DbProviderFactories&gt;&lt;br /&gt;      &amp;lt;add name="My&lt;span class="t_tag" onclick="tagshow(event)" href="http://evening.mysite4now.com/tag.php?name=SQL"&gt;SQL&lt;/span&gt; Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for My&lt;span class="t_tag" onclick="tagshow(event)" href="http://evening.mysite4now.com/tag.php?name=SQL"&gt;SQL&lt;/span&gt;"type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,Version=6.0.3.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"/&gt;&lt;br /&gt;    &amp;lt;/DbProviderFactories&gt;&lt;br /&gt;&amp;lt;/system.data&gt;</description><pubDate>Wed, 24 Jun 2009 08:57:35 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Sample Connection String for ASP.NET</title><link>http://www.webhost4life.com/HostingKB/Goto50487.aspx</link><description>&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;We support several types of databases such as MSSQL, MySQL, Excel, Excel 2007 and Access in ASP.net application. Here are some sample connection strings.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;&lt;u&gt;&lt;font size="3"&gt;MSSQL&lt;/font&gt;&lt;/u&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;font color="#000000" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana" size="2"&gt; ASP.net connection&lt;/font&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="Verdana"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;&lt;span&gt;&lt;span class="Quote"&gt;"Server=&lt;font color="#ff0000"&gt;DB Server&lt;/font&gt;;Database=&lt;font color="#ff0000"&gt;DB NAME&lt;/font&gt;;uid=&lt;font color="#ff0000"&gt;DB ID&lt;/font&gt;;pwd=&lt;font color="#ff0000"&gt;DB Password&lt;/font&gt;;" providerName="System.Data.SqlClient" &lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text" /&gt;&lt;/span&gt;&lt;/font&gt;&lt;font face="Verdana" size="2"&gt;OLE DB                                  connection string (DSNless Connection):&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;font face="Verdana"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;&lt;span&gt;&lt;span class="Quote"&gt;"Provider=SQLOLEDB;Data Source=&lt;font color="#ff0000"&gt;DB Server&lt;/font&gt;;User Id=&lt;font color="#ff0000"&gt;DB ID;&lt;/font&gt;Password=&lt;font color="#ff0000"&gt;DB Password&lt;/font&gt;;Initial Catalog=&lt;font color="#ff0000"&gt;DB NAME&lt;/font&gt;;"&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;font face="Verdana" size="2"&gt;&lt;br /&gt;&lt;font face="Verdana" size="2"&gt;&lt;br /&gt;ODBC connection string &lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;span&gt;&lt;span class="Quote"&gt;"DSN=&lt;font color="#ff0000"&gt;ODBC Name&lt;/font&gt;;User Id=&lt;font color="#ff0000"&gt;DB ID&lt;/font&gt;;Password=&lt;font color="#ff0000"&gt;DB Password&lt;/font&gt;;Initial Catalog=&lt;font color="#ff0000"&gt;DB NAME&lt;/font&gt;;"&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;Please replace the word in red color into your database information. If you don't know your database information, you can read this &lt;a target="_blank" href="http://www.webhost4life.com/HostingKB/KnowledgebaseArticle50066.aspx"&gt;article&lt;/a&gt;.&lt;br /&gt;For example:&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;ODBC Name : The name of ODBC you created in control panel &gt; database &gt; ODBC&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;DB Server : sql3xx.mysite4now.com&lt;br /&gt;DB Name : mydemodb_12345&lt;br /&gt;DB ID : mydemoid_12345&lt;br /&gt;DB Password : mydemopw&lt;br /&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;strong&gt;&lt;br /&gt;&lt;font size="3"&gt;&lt;u&gt;MySQL&lt;/u&gt;&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;OLE DB connection string (DSNless Connection):&lt;br /&gt;&lt;br /&gt;&lt;span&gt;&lt;span class="Quote"&gt;"DRIVER={MySQL}; SERVER=&lt;font color="#ff0000"&gt;DB Server&lt;/font&gt;; DATABASE=&lt;font color="#ff0000"&gt;DB Name&lt;/font&gt;; USER=&lt;font color="#ff0000"&gt;DB ID&lt;/font&gt;; PASSWORD=&lt;font color="#ff0000"&gt;DB PASSWORD&lt;/font&gt;; OPTION=3;"&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;ODBC connection string (Requires a ODBC to be created first):&lt;br /&gt;&lt;br /&gt;&lt;span&gt;&lt;span class="Quote"&gt;"DSN=&lt;font color="#ff0000"&gt;ODBC Name&lt;/font&gt;;User=&lt;font color="#ff0000"&gt;DB ID&lt;/font&gt;;Password=&lt;font color="#ff0000"&gt;DB PASSWORD&lt;/font&gt;;Database=&lt;font color="#ff0000"&gt;DB NAME&lt;/font&gt;;"&lt;/span&gt;&lt;/span&gt;&lt;strong&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;br /&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;Pleasereplace the word in red color into your database information.&lt;br /&gt;For example:&lt;br /&gt;ODBC Name : The name of ODBC you created in control panel &gt; database &gt; ODBC&lt;br /&gt;IP Address : mysqlxxx.mysite4now.com&lt;br /&gt;DB Name : mysqldemo_12345&lt;br /&gt;DB ID : mysqldemo_12345&lt;br /&gt;DB Password : mysqlpw&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;strong&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;b&gt;&lt;br /&gt;&lt;br /&gt;&lt;u&gt;&lt;font size="3"&gt;Excel&lt;/font&gt;&lt;/u&gt;&lt;br /&gt;&lt;br /&gt;&lt;/strong&gt; &lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;span&gt;&lt;span class="Quote"&gt;"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&lt;font color="#ff0000"&gt;path of excel&lt;/font&gt;;Extended Properties=Excel 8.0"&lt;/span&gt;&lt;/span&gt;&lt;br /&gt; &lt;br /&gt;Replace &lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font color="#ff0000"&gt;path of excel&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt; by the actual path of your excel file.&lt;br /&gt;Example : d:\hosting\member\memberID\myexcel.xls&lt;br /&gt;&lt;br /&gt;PS. If you need to write data into your excel database, please grant write permission to the excel file.&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;strong&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;b&gt;&lt;br /&gt;&lt;br /&gt;&lt;font size="3"&gt;&lt;u&gt;Excel 2007&lt;/u&gt;&lt;/font&gt;&lt;br /&gt;&lt;/strong&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;span disabled="disabled"&gt;&lt;span&gt;&lt;span class="Quote"&gt;&lt;font face="Verdana"&gt;"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&lt;font color="#ff0000"&gt;path of excel&lt;/font&gt;;Extended Properties=Excel 12.0"&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;br /&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;Replace &lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font color="#ff0000"&gt;path of excel &lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;by the actual path of your excel 2007 file.&lt;br /&gt;Example : d:\hosting\member\memberID\myexcel2007.xlsx&lt;br /&gt;&lt;br /&gt;PS. If you need to write data into your excel database, please grant write permission to the excel file.&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;strong&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;b&gt;&lt;br /&gt;&lt;font size="3"&gt;&lt;u&gt;Access&lt;/u&gt;&lt;/font&gt;&lt;/strong&gt;&lt;/font&gt;&lt;br /&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;span disabled="disabled"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;For Access DB WITHOUT password protection:&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="Verdana"&gt; &lt;/font&gt;&lt;span&gt;&lt;font face="Verdana"&gt;&lt;span class="Quote"&gt;&lt;font face="Verdana"&gt;"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=&lt;/font&gt;&lt;font face="Verdana" color="#ff0000"&gt;path of access db&lt;/font&gt;&lt;font face="Verdana"&gt;"&lt;/font&gt;&lt;/span&gt;&lt;font face="Verdana" /&gt;&lt;/font&gt;&lt;/span&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;For Access DB WITH password protection:&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;span class="Quote"&gt;&lt;font face="Verdana"&gt;&lt;span&gt;&lt;font face="Verdana"&gt;"Provider=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=&lt;/font&gt;&lt;font face="Verdana" color="#ff0000"&gt;path of access db&lt;/font&gt;&lt;font face="Verdana"&gt;;password=&lt;/font&gt;&lt;font face="Verdana" color="#ff0000"&gt;password of db&lt;/font&gt;&lt;font face="Verdana"&gt;"&lt;/font&gt;&lt;/span&gt;&lt;font face="Verdana" /&gt;&lt;/font&gt;&lt;/span&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;Replace &lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;&lt;font color="#ff0000"&gt;path of access db &lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;by the actual path of your excel 2007 file.&lt;br /&gt;Example : d:\hosting\member\memberID\myAccessDB.mdb&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;Replace &lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;font face="Verdana" color="#ff0000"&gt;password of db&lt;/font&gt;&lt;font face="Verdana"&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font size="2"&gt;&lt;font color="#ff0000"&gt; &lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;by the database password of your Access database.&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;font face="Verdana"&gt;&lt;strong&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;b&gt;&lt;span disabled="disabled"&gt;&lt;br /&gt;&lt;span disabled="disabled"&gt;&lt;span class="Article_Text" /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/b&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="Verdana" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/span&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2"&gt;&lt;font face="MS Sans Serif" size="2" /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;</description><pubDate>Sun, 31 May 2009 14:25:26 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Can I use ASP.NET Ajax Control Toolkit on your hosting?</title><link>http://www.webhost4life.com/HostingKB/Goto50485.aspx</link><description>The ASP.NET AJAX Control Toolkit is an open-source project built on topof the Microsoft ASP.NET AJAX framework. It is a joint effort betweenMicrosoft and the ASP.NET AJAX community that provides ASP.NETAJAX extenders and controls. You can see all the available control samples here:&lt;br /&gt;&lt;a href="http://www.asp.net/ajax/ajaxcontroltoolkit/samples/"&gt;http://www.asp.net/ajax/ajaxcontroltoolkit/samples/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;Our Windows hosting customers can simply download the suitable version of toolkit. Then upload the correct dll to application /bin folder to usethat. &lt;br /&gt;&lt;br /&gt;If you are using .NET Framework 2.0 and Visual Studio 2005 then you should use Toolkit version 1.0.20229:&lt;br /&gt;Version 1.0.20229&lt;br /&gt;&lt;a href="http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121" target="_blank"&gt;http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;For .NET Framework 3.5 and Visual Studio 2008:&lt;br /&gt;Version 3.0.20229&lt;br /&gt;&lt;a href="http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121" target="_blank"&gt;http://www.codeplex.com/AjaxControlToolkit/Release/ProjectReleases.aspx?ReleaseId=11121&lt;/a&gt;&lt;br /&gt;2008-02-29 release of the AJAX Control Toolkit targets the official release of &lt;br /&gt;&lt;br /&gt;For  .NET Framework 3.5 SP1 and Visual Studio 2008 SP1:&lt;br /&gt;Version 3.0.30512&lt;br /&gt;&lt;a href="http://ajaxcontroltoolkit.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=27326"&gt;http://ajaxcontroltoolkit.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=27326&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;If you are using it in your project already, you can check the version by checking the &lt;u&gt;AjaxControlToolkit.dll&lt;/u&gt; file. &lt;br /&gt;All our Windows hosting server have ASP.NET 2.0, 3.5 and 3.5sp1 installed.&lt;br /&gt;&lt;br /&gt;&lt;font color="#000000"&gt;&lt;font color="Red"&gt;&lt;font color="Red"&gt;&lt;font color="#ff0000"&gt;* Notice that only our Advance plan or above support ASP.NET. You need ASP.NET to run this control toolkit.&lt;/font&gt;&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;/font&gt;</description><pubDate>Tue, 26 May 2009 11:46:12 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Why is my ASP.NET not running?</title><link>http://www.webhost4life.com/HostingKB/Goto50114.aspx</link><description>&lt;font face="MS Sans Serif" size="2"&gt;1. Please make sure you purchase an Advance Hosting plan or above.  Basic hosting plan doesn't support asp.net&lt;br /&gt;&lt;br /&gt;2. Please make sure your .net is in right version. To check or change .NET version, you may go to control panel -&gt; Site admin -&gt; .NET application&lt;br /&gt;&lt;/font&gt;</description><pubDate>Wed, 20 May 2009 18:42:12 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How to encrypt my web.config file?</title><link>http://www.webhost4life.com/HostingKB/Goto50475.aspx</link><description>Before encrypting your file, please make a backup copy first&lt;br /&gt;&lt;br /&gt;Below are the basic steps to encrypt your web.config file.&lt;br /&gt;1) Generate a RSA key&lt;br /&gt;2) Input the generated key in your web.config &lt;br /&gt;3) Encrypt your web.config&lt;br /&gt;4) Export the key&lt;br /&gt;5) Upload the key and the encrypted web.config to our server&lt;br /&gt;6) We install the key for you.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Step 1) Generate a RSA key&lt;/strong&gt;&lt;br /&gt;To generate a RSA key, please open the command prompt and input the following command:&lt;br /&gt;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -pc "&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;" -exp&lt;br /&gt;&lt;br /&gt;Replace &lt;strong&gt;&lt;em&gt;&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt; with your own member ID. You will be able to see this message:&lt;br /&gt;&lt;div align="left"&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;Creating RSA Key container....&lt;/span&gt;&lt;br style="font-style: italic;" /&gt;&lt;span style="font-style: italic;"&gt;Succeeded!&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;It means you generated a RSA key called "&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;" successfully.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Step 2) Input the generated key in your web.config&lt;br /&gt;&lt;/strong&gt;Please download the web.config in your local machine first. &lt;br /&gt;In step 1, we generated a RSA key called "&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;". &lt;br /&gt;Open your web.config file and search "&amp;lt;/configSections&gt;". Paste the following code right after &amp;lt;/configSections&gt;.  Remember to replace the RSA key name in your code. &lt;br /&gt;&lt;br /&gt;&lt;table&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td&gt; &amp;lt;configProtectedData&gt;&lt;br /&gt;  &amp;lt;providers&gt;&lt;br /&gt;  &amp;lt;add keyContainerName="&lt;font color="#000000" style="background-color: rgb(255, 255, 255);"&gt;&lt;em&gt;&lt;strong&gt;dotnetRSAkey_&lt;font color="#ff0000"&gt;memberID&lt;/font&gt;&lt;/strong&gt;&lt;/em&gt;&lt;/font&gt;" &lt;br /&gt;           useMachineContainer="true"&lt;br /&gt;           description="Uses RsaCryptoServiceProvider to encrypt and decrypt"&lt;br /&gt;           name="CustomProvider"      type="System.Configuration.RsaProtectedConfigurationProvider,System.Configuration,Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /&gt;&lt;br /&gt;  &amp;lt;/providers&gt;&lt;br /&gt;&amp;lt;/configProtectedData&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;br /&gt;&lt;strong&gt;Step 3) Encrypt your web.config&lt;/strong&gt;&lt;br /&gt;Assume you put your web.config file in &lt;font color="#a52a2a"&gt;&lt;strong&gt;C:\site1&lt;/strong&gt;&lt;/font&gt; of your local computer now. To encrypt the "&lt;font color="#ffa500"&gt;&lt;strong&gt;connectionStrings&lt;/strong&gt;&lt;/font&gt;" &lt;font color="#ffa500"&gt;&lt;strong&gt; &lt;/strong&gt;&lt;/font&gt;of your web.config file, please run the following command:&lt;br /&gt;&lt;br /&gt;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -pef "&lt;font color="#ffa500"&gt;&lt;strong&gt;connectionStrings&lt;/strong&gt;&lt;/font&gt;" &lt;font color="#a52a2a"&gt;&lt;strong&gt;C:\site1&lt;/strong&gt;&lt;/font&gt; -prov "CustomProvider" &lt;br /&gt;&lt;br /&gt;You will see the following message:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;Encrypting configuration section...&lt;/span&gt;&lt;br style="font-style: italic;" /&gt;&lt;span style="font-style: italic;"&gt;Succeeded!&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Step 4) Export the key&lt;/strong&gt;&lt;br /&gt;To export the RSA key, please open the command prompt and run the following command&lt;br /&gt;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis -px "&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;" "C:\&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;.xml" -pri&lt;br /&gt;&lt;br /&gt;You will be able to see this message:&lt;br /&gt;&lt;br /&gt;&lt;span style="font-style: italic;"&gt;Exporting RSA key to file...&lt;/span&gt;&lt;br style="font-style: italic;" /&gt;&lt;span style="font-style: italic;"&gt;Succeeded!&lt;/span&gt;&lt;br /&gt;&lt;br /&gt;In this example, your key file is exported to C:\ and filename &lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;.xml&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Step 5)&lt;/strong&gt; &lt;strong&gt;Upload the key and the encrypted web.config to our server&lt;/strong&gt;&lt;br /&gt;Please upload the encrypted web.config and the RSA key (&lt;strong&gt;&lt;em&gt;dotnetRSAkey_&lt;font color="Red"&gt;memberID&lt;/font&gt;&lt;/em&gt;&lt;/strong&gt;.xml) to the corresponding folder in our server.&lt;br /&gt;&lt;br /&gt;&lt;strong&gt;Step 6) We install the key for you&lt;br /&gt;&lt;/strong&gt;Finally, open a ticket and ask us to install the RSA key in our server now. Please tell us the place that you uploaded the RSA key file.&lt;br /&gt;&lt;strong&gt;&lt;br /&gt;&lt;br /&gt;&lt;/strong&gt;&lt;font size="1"&gt;ref:&lt;br /&gt;How To: Encrypt Configuration Sections in ASP.NET 2.0 Using DPAPI&lt;br /&gt;&lt;a href="http://msdn2.microsoft.com/en-us/library/ms998280.aspx"&gt;http://msdn2.microsoft.com/en-us/library/ms998280.aspx&lt;/a&gt;&lt;/font&gt;&lt;strong&gt;&lt;br /&gt;&lt;/strong&gt;&lt;br /&gt;&lt;/div&gt;</description><pubDate>Mon, 18 May 2009 11:25:39 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level</title><link>http://www.webhost4life.com/HostingKB/Goto50460.aspx</link><description>If your ASP.NET site get following error:&lt;br /&gt;&lt;br /&gt;&lt;font color="#ff0000"&gt;&lt;em&gt;Configuration Error&lt;br /&gt;Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.&lt;br /&gt;&lt;br /&gt;Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.  This error can be caused by a virtual directory not being configured as an application in IIS.&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;br /&gt;and your website is built under a subfolder (e.g. http://www.domain.com/application/). It could be caused by your subfolder not being set as .NET application. You can set it up by login Hosting Control Panel -&gt; Site Admin -&gt; .net Application.&lt;br /&gt;</description><pubDate>Thu, 07 May 2009 13:49:06 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Using SQL Server for ASP.Net session state</title><link>http://www.webhost4life.com/HostingKB/Goto50455.aspx</link><description>&lt;font size="2"&gt;Setup/use SQL Server for ASP.Net session state&lt;br /&gt;&lt;br /&gt;This tutorial will go through steps to setup/install the session state service for ASP .Net application with custom database.&lt;br /&gt;1.) Create the MSSQL Database for session state&lt;br /&gt;2.) Tool to install the session state template&lt;br /&gt;3.) &lt;/font&gt;&lt;font size="2"&gt;Installation the session state service on custom database&lt;br /&gt;4.) Update the web.config file&lt;br /&gt;5.) Create the job to delete expired sessions&lt;br /&gt;&lt;br /&gt;&lt;hr /&gt;&lt;/font&gt;&lt;font size="2"&gt;1.) Create the MSSQL Database for session state&lt;br /&gt;&lt;br /&gt;Create MSSQL database for the session state service.&lt;br /&gt;control panel -&gt; databases -&gt; MSSQL Admin -&gt; Create New DB&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/01_create_db3.JPG" /&gt;&lt;br /&gt;&lt;br /&gt;This tutorial will go through with follow MSSQL DB info:&lt;br /&gt;Database Server Address: &lt;font color="#c71585"&gt;sql999.mysite4now.com&lt;/font&gt;&lt;br /&gt;Database name:&lt;font color="#c71585"&gt; &lt;/font&gt;&lt;font color="#c71585"&gt;statedemoDB_62760&lt;/font&gt;&lt;br /&gt;Database User ID: &lt;font color="#c71585"&gt;statedemoUser_62760&lt;/font&gt;&lt;br /&gt;Database Password:&lt;font color="#c71585"&gt; statepassword&lt;br /&gt;&lt;/font&gt;&lt;/font&gt;&lt;font size="2" color="#ff0000"&gt;*&lt;/font&gt;&lt;font size="2"&gt;&lt;font color="#ff0000"&gt;You should create/use your database to setup the session state service&lt;/font&gt;&lt;br /&gt;&lt;br /&gt;&lt;hr /&gt;2.) Tool to install the session state template&lt;br /&gt;You can install the session state service to custom database with the installation template query:&lt;br /&gt;&lt;/font&gt;&lt;font size="2" color="#ff0000"&gt;InstallSqlStateTemplate.sql&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;br /&gt;By default, &lt;font color="#ff0000"&gt;InstallSqlStateTemplate.sql&lt;/font&gt; located in following folders:&lt;br /&gt;C:\Windows\Microsoft.NET\Framework\&lt;font color="#c71585"&gt;version_ID&lt;/font&gt;\&lt;br /&gt;&lt;br /&gt;For example:&lt;br /&gt;&lt;/font&gt;C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallSqlStateTemplate.sql&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/02_installsqlstatetemplate_location.JPG" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Copy this sql file to another location, and update the template file:&lt;br /&gt;- find and replace all reserved string &lt;font color="#ff0000"&gt;DatabaseNamePlaceHolder &lt;/font&gt;within the template&lt;br /&gt;- replace this string to the database name which install the session state service, for this tutorial - &lt;font color="#c71585"&gt;statedemoDB_62760&lt;/font&gt;&lt;br /&gt;&lt;br /&gt;&lt;img height="420" width="785" src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/03_update_template.JPG" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;br /&gt;&lt;hr /&gt;3.) &lt;/font&gt;&lt;font size="2"&gt;Installation the session state service on custom database&lt;br /&gt;Connect the database with Microsoft SQL Server Management Studio&lt;br /&gt;&lt;br /&gt;Currently, this database is a blank database:&lt;br /&gt;&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/04_blank_db.JPG" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Execute the &lt;/font&gt;&lt;font size="2" color="#ff0000"&gt;InstallSqlStateTemplate.sql &lt;/font&gt;&lt;font size="2"&gt;via the Management Studio&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/05_run_the_query.JPG" /&gt;&lt;br /&gt;1 - Click "New Query"&lt;br /&gt;2 - Copy and paste the contents of updated &lt;/font&gt;&lt;font size="2"&gt;&lt;font color="#ff0000"&gt;InstallSqlStateTemplate.sql &lt;/font&gt;&lt;/font&gt;&lt;font size="2"&gt;as sql query&lt;br /&gt;3 - "Execute" the query&lt;br /&gt;&lt;/font&gt;&lt;font size="2"&gt;4 - The result of the query execution&lt;br /&gt;&lt;br /&gt;Query execution result:&lt;br /&gt;&lt;/font&gt;&lt;blockquote&gt;&lt;font size="2"&gt;&lt;em&gt;-------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;Starting execution of InstallSqlStateTemplate.SQL&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;-------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt; &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;--------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;Note:                                             &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;This file is included for backward compatibility  &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;only.  You should use aspnet_regsql.exe to install&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;and uninstall SQL session state.                  &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt; &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;Run 'aspnet_regsql.exe -?' for details.         &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;--------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;Msg 229, Level 14, State 5, Procedure sp_delete_job, Line 1&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;The EXECUTE permission was denied on the object 'sp_delete_job', database 'msdb', schema 'dbo'.&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;If the category already exists, an error from msdb.dbo.sp_add_category is expected.&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;Msg 229, Level 14, State 5, Procedure sp_add_category, Line 1&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;The EXECUTE permission was denied on the object 'sp_add_category', database 'msdb', schema 'dbo'.&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;Msg 229, Level 14, State 5, Procedure sp_add_job, Line 1&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;&lt;font color="#ff0000"&gt;The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.&lt;/font&gt;&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt; &lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;--------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;Completed execution of InstallSqlStateTemplate.SQL&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;font size="2"&gt;&lt;em&gt;--------------------------------------------------&lt;/em&gt;&lt;/font&gt;&lt;br /&gt;&lt;/blockquote&gt;&lt;font size="2"&gt;&lt;br /&gt;Normally, the core tables/stored procedures have installed on the database after execution&lt;br /&gt;Above error message due to insufficient user privilege to add the scheduled job. &lt;br /&gt;Which is a scheduled job to delete expired session state record of the session state database.&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;/font&gt;&lt;font size="2"&gt;&lt;font color="#ff0000"&gt;&lt;font color="#0000ff"&gt;Execution of&lt;/font&gt; InstallSqlStateTemplate.sql &lt;/font&gt;&lt;/font&gt;&lt;font size="2"&gt; installed &lt;/font&gt;&lt;font size="2"&gt;session state related tables/stored procedures:&lt;br /&gt;&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/06_installed_db.JPG" /&gt;&lt;/font&gt;&lt;font size="2"&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;hr /&gt;4.) Update the web.config file&lt;br /&gt;&lt;br /&gt;Update the web.config to use the custom session state server/database:&lt;br /&gt;Update/insert sessionState code:&lt;br /&gt;&lt;br /&gt;&amp;lt;sessionState&lt;br /&gt;        mode="&lt;font color="#ff0000"&gt;SQLServer&lt;/font&gt;"&lt;br /&gt;       &lt;font color="#ff0000"&gt; allowCustomSqlDatabase="true"&lt;/font&gt;&lt;br /&gt;        sqlConnectionString="data source=&lt;font color="#c71585"&gt;sql999.mysite4now.com&lt;/font&gt;;initial catalog=&lt;font color="#c71585"&gt;statedemoDB_62760&lt;/font&gt;;user id=&lt;font color="#c71585"&gt;statedemoUser_62760&lt;/font&gt;;password=&lt;font color="#c71585"&gt;statepassword&lt;/font&gt;"&lt;br /&gt;        cookieless="false"&lt;br /&gt;        timeout="20"&lt;br /&gt;/&gt;&lt;br /&gt;&lt;br /&gt;** Use mode = &lt;font color="#ff0000"&gt;SQLServer&lt;/font&gt;&lt;br /&gt;** To use custom DB instead of default database "ASPSTATE" , &lt;font color="#ff0000"&gt;need to enable option allowCustomSqlDatabase="true"&lt;/font&gt;&lt;br /&gt;** session&lt;font color="#c71585"&gt;S&lt;/font&gt;tate : &lt;font color="#c71585"&gt;S&lt;/font&gt; is uppercase, case sensitive&lt;br /&gt;** sql&lt;font color="#c71585"&gt;C&lt;/font&gt;onnection&lt;font color="#c71585"&gt;S&lt;/font&gt;tring :  &lt;font color="#c71585"&gt;C &lt;/font&gt;, &lt;font color="#c71585"&gt;S&lt;/font&gt; are uppercase, case sensitive&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Session state record update within the table:&lt;br /&gt;&lt;br /&gt;&lt;img src="/HostingKB/Uploads/Images/kb_aspnet_sql_session_state/07_state_record.JPG" /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&lt;hr /&gt;5.) Create the scheduled job to delete expired sessions record in the database&lt;br /&gt;&lt;br /&gt;Refer to steps 3.)&lt;br /&gt;To setup the scheduled job for the session state database,&lt;br /&gt;you need to purchase the scheduled Task service via control panel:&lt;br /&gt;control panel -&gt; Site Admin -&gt; Schedule Task&lt;br /&gt;&lt;br /&gt;After that submit a ticket to our support team and they will give further assistance to setup the schedule job.&lt;br /&gt;&lt;/font&gt;</description><pubDate>Wed, 06 May 2009 16:41:08 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>SELECT command denied to user 'user@'xxx.xxx.xxx.xxx' 'for table 'proc'</title><link>http://www.webhost4life.com/HostingKB/Goto50449.aspx</link><description>&lt;span style="line-height: normal; white-space: pre;"&gt;Below solution is applied for MySQL Connector/ODBC 5.1.&lt;br /&gt;&lt;br /&gt;When users connect their Mysql database with Mysql .Net connector and try to create stored procedure, Mysql will return error :&lt;/span&gt;&lt;div&gt;&lt;span style="line-height: normal; white-space: pre;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="line-height: normal; white-space: pre;"&gt;SELECT command denied to user 'user@'xxx.xxx.xxx.xxx' 'for table 'proc'&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="line-height: normal; white-space: pre;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="line-height: normal; white-space: pre;"&gt;It is a bug in Mysql&lt;span style="line-height: 18px; white-space: normal;"&gt; (&lt;a href="http://"&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;http://bugs.mysql.com/bug.php?id=33455&lt;/span&gt;&lt;/a&gt;)&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;To fix it, please a&lt;span style="font-size: 14px; border-collapse: collapse; line-height: 22px;"&gt;dd "Use Procedure Bodies=false;" to the connection string:&lt;span&gt;     &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style="line-height: normal; white-space: pre;"&gt;&lt;span style="font-size: 14px; white-space: normal; border-collapse: collapse; line-height: 22px;"&gt;&lt;br style="line-height: normal;" /&gt;"server=mysqlxxx.mysite4now.com;user id=dbuser; password=dbpassword; database=&lt;span href="tag.php?name=dbname" onclick="tagshow(event)" class="t_tag" style="border-bottom: 1px solid rgb(255, 0, 0); line-height: normal; cursor: pointer; white-space: nowrap;"&gt;dbname&lt;/span&gt;; Use Procedure Bodies=false;"&lt;br style="line-height: normal;" /&gt;&lt;br style="line-height: normal;" /&gt;ref: &lt;a href="http://bugs.mysql.com/bug.php?id=35938" target="_blank" style="text-decoration: none; line-height: normal;"&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;http://&lt;/span&gt;&lt;span href="tag.php?name=bug" onclick="tagshow(event)" class="t_tag" style="border-bottom: 1px solid rgb(255, 0, 0); line-height: normal; cursor: pointer; white-space: nowrap;"&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;bug&lt;/span&gt;&lt;/span&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;s.mysql.com/&lt;/span&gt;&lt;span href="tag.php?name=bug" onclick="tagshow(event)" class="t_tag" style="border-bottom: 1px solid rgb(255, 0, 0); line-height: normal; cursor: pointer; white-space: nowrap;"&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;bug&lt;/span&gt;&lt;/span&gt;&lt;span style="color: rgb(0, 0, 0);"&gt;.php?id=35938&lt;/span&gt;&lt;/a&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;</description><pubDate>Sun, 12 Apr 2009 16:58:12 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Do you support ASP.NET MVC?</title><link>http://www.webhost4life.com/HostingKB/Goto50443.aspx</link><description>Yes, we support ASP.NET MVC as we installed .net 3.5 sp1 on our servers. &lt;br /&gt;&lt;br /&gt;Please download the ASP.NET MVC via &lt;a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=53289097-73ce-43bf-b6a6-35e00103cb4b&amp;amp;displaylang=en" target="_blank"&gt;this link&lt;/a&gt; and install it to your local computer. Then upload the assembly file "System.Web.Mvc.dll" to the bin folder under your application. If you used default path for the MVC installation, it should be located in [system drive]\Program Files\Microsoft ASP.NET\ASP.NET MVC 1.0\Assemblie&lt;br /&gt;&lt;br /&gt;Also, your website IIS entry need to setup asp.net wildcard extension. Please submit a ticket to us, so that we can help you to setup asp.net wildcard for the mvc application.</description><pubDate>Tue, 31 Mar 2009 18:51:27 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>What is my physical path?</title><link>http://www.webhost4life.com/HostingKB/Goto50124.aspx</link><description>&lt;font face="MS Sans Serif" size="2"&gt;                    &lt;/font&gt;You can see your physical path by logging into your Hosting Control Panel -&gt; Account. You should see your physical path under "Base Directory:" section&lt;strong&gt;&lt;font face="verdana, arial" size="1"&gt;&lt;br /&gt;&lt;/font&gt;&lt;/strong&gt;</description><pubDate>Thu, 26 Feb 2009 16:59:56 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How to Display Reporting Service Reports with asp.net reportviewer control?</title><link>http://www.webhost4life.com/HostingKB/Goto50047.aspx</link><description>&lt;p&gt;&lt;font face="Arial" size="2"&gt;To use ReportViewer control remote modeto display reports deployed to SQL reporting server, you will need tosign up with SQL Reporting service from your hosting control panel, andhave your reports deployed to the report server.&lt;br /&gt;You may also want to know "How to use SQL Reporting Service web service to generate report in specific file format"&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;Summary to write your report viewer:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;1. Using Visual Studio drag the ReportViewer control to the form&lt;br /&gt;2. create a class that implements the Microsoft.Reporting.WebForms.IReportServerCredentials class.&lt;br /&gt;3. override the NetworkCredentials property of the new class, you can put your login information here&lt;br /&gt;4. initiate an object from the new class and assign to your ReportViewer.ServerReport.ReportServerCredentials property.&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;Example:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;a href="http://webho_demo.mysite4now.com/reportviewer/default.aspx"&gt;http://webho_demo.mysite4now.com/reportviewer/default.aspx&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;Source code:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;a href="http://webho_demo.mysite4now.com/reportviewer/reportviewer.zip"&gt;http://webho_demo.mysite4now.com/reportviewer/reportviewer.zip&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;MSDN reference:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;a href="http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials%28VS.80%29.aspx"&gt;http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;Known issue:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;1. If you see asp.net session exception, try to set the reportviewer control Async property to False.&lt;/font&gt;&lt;/p&gt;</description><pubDate>Wed, 24 Dec 2008 11:34:28 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>My web.config files are not working. I cannot see errors remotely?</title><link>http://www.webhost4life.com/HostingKB/Goto50093.aspx</link><description>&lt;font size="2"&gt; Please use this copy of a web.config file to allow error showing remotely. Remember make a backup of original copy first.&lt;br /&gt;&lt;br /&gt;&lt;span class="Code"&gt;&amp;lt;!-- Web.Config Configuration File --&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;configuration&gt;&lt;br /&gt;    &amp;lt;system.web&gt;&lt;br /&gt;        &amp;lt;customErrors mode="Off"/&gt;&lt;br /&gt;    &amp;lt;/system.web&gt;&lt;br /&gt;    &amp;lt;appSettings&gt;&lt;br /&gt;    &amp;lt;/appSettings&gt;&lt;br /&gt;&amp;lt;/configuration&gt;&lt;/span&gt;&lt;br /&gt;&lt;/font&gt;</description><pubDate>Wed, 24 Dec 2008 11:06:37 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Cannot run Microsoft SilverLight application</title><link>http://www.webhost4life.com/HostingKB/Goto50075.aspx</link><description>&lt;p&gt;&lt;font face="Arial" size="2"&gt;1) on client side, make sure the player is installed - &lt;a href="http://www.microsoft.com/silverlight/downloads.aspx" target="_blank"&gt;http://www.microsoft.com/silverlight/downloads.aspx&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;2) on server side, make sure your application run asp.net version 2.0&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;3) on server side, make sure the required MIME types are set up for your application:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;Extension    MIME type&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;.xaml          application/xaml xml &lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;.xap            application/x-silverlight-app&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;You can get more information from &lt;a href="http://www.silverlightshow.net/items/4247.aspx" target="_blank"&gt;http://www.silverlightshow.net/items/4247.aspx&lt;/a&gt;&lt;/font&gt;&lt;/p&gt;</description><pubDate>Wed, 24 Dec 2008 11:04:49 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Parser Error Message: Could not load type</title><link>http://www.webhost4life.com/HostingKB/Goto50102.aspx</link><description>&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;Please note that this is a general FAQ for the error "Parser Error Message: Could not load type..."&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;You get this error because you did notpublish your .net project via Visual Studio so the .net bin folder and therequired DLLs wasn't created.&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;The best solution for this is &lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;1) Publish the application to your local machine and then upload it via ftp including the bin folder.&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;Or&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;2) Use your &lt;/font&gt;&lt;font face="MS Sans Serif" size="2"&gt;Visual Studio&lt;/font&gt;&lt;font face="MS Sans Serif" size="2"&gt; and publish theapplication directly to your site. (This require you to have a workingurl that's already pointed to our server. Frontpage extension need to enable on this URL, too)&lt;/font&gt;&lt;/p&gt;</description><pubDate>Wed, 24 Dec 2008 11:04:00 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How to connect sql database from ASP.net Web Site Administration Tool</title><link>http://www.webhost4life.com/HostingKB/Goto50086.aspx</link><description>Before you connect the sql database from ASP.net Web Site Administration Tool:&lt;br /&gt;&lt;br /&gt;   1. You need to following this &lt;a target="_self" href="KnowledgebaseArticle50085.aspx"&gt;KB&lt;/a&gt; to populate the data for asp.net's membership class&lt;br /&gt;   2. Open your Visual Studio 2005&lt;br /&gt;   3. Open your project&lt;br /&gt;   4. Edit the web.config file from your localhost&lt;br /&gt;   5. Assume you had the connection string named "conn" from your web.config. Then, please add the following tab within the &amp;lt;system.web&gt;&amp;lt;/system.web&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;membership&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;providers&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;clear /&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;add connectionStringName="conn" minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0" applicationName="membershipSampleApp" name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" /&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;/providers&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;/membership&gt;&lt;br /&gt;&lt;br /&gt;   6. Save it and click the “Website” from the Visual Studio 2005 menu bar&lt;br /&gt;   7. Choose ASP.NET Configuration&lt;br /&gt;   8. Your ASP.net Web Site Administration Tool should able to connect your SQL server</description><pubDate>Wed, 24 Dec 2008 11:01:30 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>What version of .NET do you support?</title><link>http://www.webhost4life.com/HostingKB/Goto50110.aspx</link><description>&lt;font face="MS Sans Serif" size="2"&gt;We are currently support ASP.NET Framework v.1.1, v. 2.0, v3.0 and v3.5&lt;/font&gt;</description><pubDate>Wed, 24 Dec 2008 11:00:05 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Why i get invalid view state exception</title><link>http://www.webhost4life.com/HostingKB/Goto50080.aspx</link><description>&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;Error message:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;Exception Inner Exception:System.Web.HttpException: Invalid_Viewstate&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;Reason:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="MS Sans Serif" size="2"&gt;1. These error messages are most likelygenerated by requests coming from buggy robot (or search engine).  &lt;br /&gt;2. Itmight also caused by incompatibility of the client's web browser.&lt;br /&gt;3. If you click any button on .net form before loading complete, it is possible incomplete viewstate returns and cause above error.&lt;br /&gt;&lt;/font&gt;&lt;/p&gt;</description><pubDate>Wed, 24 Dec 2008 10:59:31 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>Can I host a dot net application under a sub folder of my domain?</title><link>http://www.webhost4life.com/HostingKB/Goto50074.aspx</link><description>&lt;font face="Arial" size="2"&gt; The subfolder that contains the BINfolder must be turned to a web application. You can use the tool called"Set IIS Application". Login Hosting Control Panel -&gt; Site admin -&gt; .NET application. Do not turn the binfolder itself. &lt;/font&gt;</description><pubDate>Wed, 24 Dec 2008 10:57:25 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How to solve "This collection already contains an address with scheme http. There can be at most one address per scheme in this collection" error?</title><link>http://www.webhost4life.com/HostingKB/Goto50088.aspx</link><description>&lt;h4&gt;&lt;font face="Arial" size="2"&gt;You may encounter following error when you are running WCF related script on server:&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;&lt;font color="#ff0033"&gt;&lt;em&gt;This collection already contains an address with scheme http.  There can be at most one address per scheme in this collection. &lt;br /&gt;Parameter name: item&lt;/em&gt;&lt;/font&gt;&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;It is because our IIS setting,by default, each IIS entry will hold more then one hostheader. (i.e.more then one address) It can be solved by customize your .svc file tospecific a custom ServiceHostFactory. &lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;Let's say your entry have two hostname listed:&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;&lt;u&gt;domain.com&lt;br /&gt;www.domain.com&lt;/u&gt;&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;If you like to use "www.domain.com" asServiceHostFactory. You can now inherit from ServiceHostFactory andoverride it like follow sample:&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;&lt;font face="Tahoma"&gt;    class CustomHostFactory : ServiceHostFactory &lt;br /&gt;    {&lt;br /&gt;        protected override ServiceHost CreateServiceHost(Type serviceType, Uri[] baseAddresses)&lt;br /&gt;        {&lt;br /&gt;              CustomHost customServiceHost =&lt;br /&gt;                new CustomHost(serviceType, baseAddresses[1]);&lt;br /&gt;            return customServiceHost;&lt;br /&gt;        }&lt;br /&gt;    }&lt;/font&gt;&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;&lt;font face="Tahoma"&gt;    class CustomHost : ServiceHost&lt;br /&gt;    {&lt;br /&gt;        public CustomHost(Type serviceType, params Uri[] baseAddresses)&lt;br /&gt;            : base(serviceType, baseAddresses)&lt;br /&gt;        { }&lt;br /&gt;        protected override void ApplyConfiguration()&lt;br /&gt;        {&lt;br /&gt;            base.ApplyConfiguration();&lt;br /&gt;        }&lt;br /&gt;    }&lt;/font&gt;&lt;/font&gt;&lt;/h4&gt;&lt;h4&gt;&lt;font face="Arial" size="2"&gt;&lt;br /&gt;If you like to use "domain.com" as ServiceHostFactory, you should replace  baseAddresses[1] with baseAddresses[0].&lt;/font&gt;&lt;/h4&gt;&lt;font face="Arial" size="2"&gt;                    &lt;/font&gt;</description><pubDate>Wed, 24 Dec 2008 10:49:44 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How do I send email using asp.net 1.1</title><link>http://www.webhost4life.com/HostingKB/Goto50081.aspx</link><description>&lt;font face="Arial" size="2"&gt;You need to:&lt;br /&gt;1. use your email server as the smtp, this is usually mail.yourdomain.com&lt;br /&gt;2. authenticate to the smtp server&lt;br /&gt;3. make sure your "From" address is exactly the same as your login address in NetworkCredential class&lt;/font&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&lt;br /&gt;Sample code for asp.net 1.1:&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&amp;lt;%@ Page Language="C#" Debug="True" %&amp;gt;&lt;br /&gt;&amp;lt;%@ Import Namespace="System.Web.Mail"%&gt;&lt;br /&gt;&amp;lt;script  runat="server"&gt;&lt;br /&gt;private void Page_Load(object sender, System.EventArgs e)&lt;br /&gt;{&lt;br /&gt; MailMessage mail = new MailMessage();&lt;br /&gt; mail.To = "receive@ReceiverDomain.com";&lt;br /&gt; mail.From = "&lt;strong&gt;postmaster@YourDomain.com&lt;/strong&gt;";&lt;br /&gt; mail.Subject = "this is a test email.";&lt;br /&gt; mail.Body = "Some text goes here";&lt;br /&gt; mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "&lt;strong&gt;1&lt;/strong&gt;"); //basic authentication&lt;br /&gt; mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "&lt;strong&gt;postmaster@YourDomain.com&lt;/strong&gt;"); //set your username here&lt;br /&gt; mail.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "&lt;strong&gt;postmasterPassword&lt;/strong&gt;"); //set your password here&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt; SmtpMail.SmtpServer = "&lt;strong&gt;mail.YourDomain.com&lt;/strong&gt;";  //your real server goes here&lt;br /&gt; SmtpMail.Send( mail );&lt;br /&gt;}&lt;br /&gt;&amp;lt;/script&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&amp;lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;&lt;/font&gt;&lt;/p&gt;&lt;p&gt;&lt;font face="Arial" size="2"&gt;&amp;lt;html xmlns="http://www.w3.org/1999/xhtml" &gt;&lt;br /&gt;&amp;lt;head runat="server"&gt;&lt;br /&gt;    &amp;lt;title&gt;Test mail page&amp;lt;/title&gt;&lt;br /&gt;&amp;lt;/head&gt;&lt;br /&gt;&amp;lt;body&gt;&lt;br /&gt;    &amp;lt;form id="form1" runat="server"&gt;&lt;br /&gt;    &amp;lt;div&gt;Success&lt;br /&gt;    &lt;br /&gt;    &amp;lt;/div&gt;&lt;br /&gt;    &amp;lt;/form&gt;&lt;br /&gt;&amp;lt;/body&gt;&lt;br /&gt;&amp;lt;/html&gt;&lt;/font&gt;&lt;/p&gt;</description><pubDate>Mon, 01 Dec 2008 13:14:03 GMT</pubDate><dc:creator>Mark</dc:creator></item><item><title>How do I send email using asp.net 2.0</title><link>http://www.webhost4life.com/HostingKB/Goto50082.aspx</link><description>You need to:&lt;br /&gt;1. use your email server as the smtp, this is usually mail.yourdomain.com&lt;br /&gt;2. authenticate to the smtp server&lt;br /&gt;3. make sure your "From" address is exactly the same as your login address in NetworkCredential class&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;Sameple code for asp.net 2.0:&lt;br /&gt;&lt;br /&gt;&amp;lt;%@page Language="VB" %&amp;gt;&lt;br /&gt;&amp;lt;%&lt;br /&gt;Dim objMM As New System.Net.Mail.MailMessage()&lt;br /&gt;Dim msg as String = "OK"&lt;br /&gt;&lt;br /&gt;try&lt;br /&gt;    ' configure your mail appearance&lt;br /&gt;    objMM.To.Add("tom@recipient.com")&lt;br /&gt;    objMM.From = New System.Net.Mail.MailAddress("&lt;font color="#0000ff"&gt;info@sender.com&lt;/font&gt;")&lt;br /&gt;    objMM.IsBodyHtml = False&lt;br /&gt;    objMM.Subject = "asp.net 2.0 test mail"&lt;br /&gt;    objMM.Body = "asp.net 2.0 test mail body"&lt;br /&gt;&lt;br /&gt;    ' define smtp and authentication credential&lt;br /&gt;    Dim smtp As New System.Net.Mail.SmtpClient()&lt;br /&gt;    smtp.Host = "&lt;font color="#0000ff"&gt;mail.sender.com&lt;/font&gt;"&lt;br /&gt;    smtp.Credentials = New System.Net.NetworkCredential("&lt;font color="#0000ff"&gt;info@sender.com&lt;/font&gt;","&lt;font color="#0000ff"&gt;password&lt;/font&gt;")&lt;br /&gt;&lt;br /&gt;    ' send the mail now&lt;br /&gt;    smtp.Send(objMM)&lt;br /&gt;catch e as exception&lt;br /&gt;    msg = e.message &lt;br /&gt;end try&lt;br /&gt;&lt;br /&gt;response.write(msg)&lt;br /&gt;%&gt;&lt;br /&gt;</description><pubDate>Mon, 01 Dec 2008 13:10:11 GMT</pubDate><dc:creator>Mark</dc:creator></item></channel></rss>