ASP.NET 2.0 Cookbook
by Michael A. Kittel and Geoffrey T. LeBlond

The unconfirmed error reports are from readers.  They have not yet been 
approved or disproved by the author or editor and represent solely the
opinion of the reader.

Here's a key to the markup:
        [page-number]: serious technical mistake
        {page-number}: minor technical mistake
        <page-number>: important language/formatting problem
        (page-number): language change or minor formatting problem
        ?page-number?: reader question or request for clarification

This page was updated April 17, 2007.


UNCONFIRMED  errors and comments from readers: 

(i)  1;
Depending on your configuration; in Web.Config and if you are getting
DB_E_ERRORSOCCURRED(0x80040E21) when trying to connect to SQL using OLEDB.

You may want to change your connection string to:

    <add key="dbConnectionString" value="Provider=SQLOLEDB;Data
Source=localhost\SQL_TEST1;Initial
Catalog=ASPNetCookbook;Trusted_Connection=Yes;UID=ASPNetCookbook_User;PWD=w0rk;Integrated
Security=SSPI" />

SSPI may solve your connecttion problem.

Note, my localhost has multiple instances of SQL.


{567}  1st paragraph;
Missing code C11QuickWebServiceVB2 or CS. Not found on download of product. Also,
sample point to a web service which doesn't exist


{969} C# code under //get the email server and send the email;
This is an error of not using the newer, ASP.NET 2.0, functionality. The code as written in the book WILL 
function correctly if the SMTP information is stored in appSettings instead of mailSettings.

To use the ASP.NET 2.0 functionality, the SMTP server settings should be stored in Web.config something 
like this (not in appSettings):

<system.net>
<mailSettings>
<smtp from="from@sample.com">
<network host="smtp.sample.com"
port="25"
password="emailaccountpassword"
userName="emailaccountusername" />
</smtp>
</mailSettings>
</system.net>

At that point, the code under "//get the email server and send the email" can be as listed below, because 
ASP.NET 2.0 will automatically pick up the SMTP settings if they're listed in the Web.config as per above. 
FWIW, it can also automatically pick up the emailMessage.From from the Web.config.

//get the email server and send the email
SmtpClient client = new SmtpClient();
client.Send(emailMessage);