A.) Here is a sample that assumes you have the databas in the "DATA" folder and named it "database1.mdb". Change this script as needed.

Set objCXN = Server.CreateObject("ADODB.Connection")
strPath = Server.MapPath("/DATA/database1.mdb")
strCXN = "Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath & ";User ID=;Password=;"
objCXN.Open strCXN 
.
.
objCXN.Close
Set objCXN = Nothing

A.) No charge. The nice thing about Access is that it is free, and also that it is file based so that you can simply copy the file to the webserver with you website.

The downside of Access is that it really is not designed to be used by many users at one time, and we have seen many issues with websites getting locked up due to the use of Access. SQL Server databases are much better suited for websites than Access.

A.) You should download the ".mdb" file via FTP back to your computer, and run the Access "Compact and Repair" function on your database.
Then upload the ".mdb" file back to your site.

It is recommended that you keep a backup of the database file before running the Compact and Repair function.

This is not the only possible cause, but we have seen the database become corrupt, and this should be attempted to rule out a damaged database.

• DNS1.AquestHosting.com
• DNS2.AquestHosting.com

A.) We are happy to answer specific questions about how to move a site, but are unable to provide you a detailed list of things to do, as this varies so much in each individual case. If you need help transferring your domain name please contact us using a Trouble Ticket.

In the Control Panel, you are able to add Domain Pointers. After establishing one of the names as a Domain on our servers, you can add additional domain names that point to the same site. See our price menu for current prices of adding domain pointers. Note that you can accomplish this using either "Domains" or "Domain Pointers". The main differences are that "Domain Pointers" cost less, but do not include the hosting of email for the domain name.

It only takes a few minutes from the time you create your account until you are able to FTP your files to your new account. The account setup is instant, but it may take a few minutes for your user permissions to take effect.

When you sign up, you will receive an email with our name server information. You can usually login to a control panel with your registrar to enter our name server information very easily. If you need any further assistance, just send us your registrar account information through the Trouble Ticket system and we will be happy to assist you. If you prefer to control your own dns records, and you have the access to do so, you will need to issue a trouble ticket to get the IP addresses that you should use for you DNS records.

1. Own the domain (you may purchase the name through us or any other source).
2. If the domain is purchased through another registrar, you will need to have them change the name server records to:
   DNS1.AquestHosting.com
   DNS2.AquestHosting.com
3. * If this is not the original domain for your account, you will use the "Domains" page in the control panel to create a new domain folder and setup the domain on our web server.

Note: Step 2 gets the domain's taffic to our datacenter. Step 3 gets the server setup on our servers so that the traffic is correctly routed to your account.

A.) You can connect to your site via FTP, and delete or rename the "default.htm" file that we placed there. Make sure that your default page's name matches one of the names listed as default documents. To see the pages that are recognized as default pages, open "Default Documents", in your control panel. You can edit the list as needed.

Our server doesn't know which page you want to have displayed when a page is not specified in your url. To fix this, make sure that your default page's name matches one of the names listed as default documents. To see the pages that are recognized as default pages, open "Default Documents", in your control panel. You can edit the list as needed.

A.)

• You can use FTP
  1. Open Internet Explorer.
  2. Enter the FTP address from your Welcome Letter in the address bar.
  3. Login with your username and password
  4. If you see a domain folder, double click the folder, otherwise you are probably already in the domain folder
  5. Copy the files from your computer, and paste them into the Internet Explorer window.
  6. See our tutorial http://www.aquesthosting.com/HowTo/General/HowToFTP.aspx.
• Or you can use FrontPage Extensions. See the FAQ's for FrontPage Extensions

Go to http://aquesthosting.myorderbox.com. Your user name is the email address you used to sign up, and your password is your Aquest password you had at the time the domain was ordered. If you don't remember your password, you can use the password recovery tool on that page.

A.) We bill monthly at the beginning of each month. Each billing covers the upcoming month. In other words, at the beginning of each month, you will be paying for that entire month in advance.

If you have ordered domains or extra services during we will typically bill those immediately or within a few days of your adding the items, especially in the case of a new accounts, or accounts that are spending more than usual in add on features.

A.) You can close your account at any time by creating a Trouble Ticket with the subject of 'Close Account'. For your protection, we require that it be cancelled using the Trouble Ticket system so that we can verify you are the owner of the account. You do not have to give us a reason for closing your account. We do appreciate any feedback that you offer.

Do not issue a request to close an account until you are ready for the account to be closed. We will close the account immediately when we process your Trouble Ticket.

We've had some people request that we close an account in '2 weeks' or some future date. We can NOT do that. Please issue the ticket the day you are ready to close the account.

A.) Yes, we accept MasterCard, Visa, and American Express. All charges are in U.S. dollars. We do not perform any currency conversions.

A.) At times we offer specials that allow you to pay for a year in advance and receive a discount. After the 1st year is over, you will be billed monthly. We do not offer quarterly billing.

A.) The "Recurring Charges" screen in the Control Panel under "Account Info" lists all the charges that you pay each month. This will include your regular hosting fee, as well as, any additional items you have added to your account such as SQL 2000 Databases.

A.) Yes, you can see your entire history of invoices from the Control Panel. Go to "Account Info | Invoices" and select the invoice you wish to review. It will show you all the details about the invoice.

A.) No. Sorry, but to keep our prices as affordable as possible all of our billing is done by credit card. There are no exceptions to this.

We do not mail out invoices. You can login to your control panel and view your invoices at any time.

A.) Yes, in the Control Panel, go to the "Account Info | Credit Card" screen and update the card. You will have to suppy all the information about the card. The change will take affect immediately.

A.) No, when we run our billing, we charge for any overages you have used, but you do not need to sign up for anything. You can upgrade to a larger package that include more space if you wish.

A.) We will only bill the owner of each account, which is you. If you want us to handle the billing to your customers, then your customer will need to create an account with us.

A.) The initial user name and password will be "admin/Password1" (that's the number one at the end of the password). You should immediately login your site and change the admin's password to something only you know.

You can manually reset the password for the admin account because by going into your SQL 2000 or SQL 2005 database, and change the password in the "aspnet_Membership" table to "Password1" or whatever password it should be.

Make sure you are setting the password for the right user by comparing the userID with the userID in the aspnet_Users table.

I also suggest that you copy and paste the existing password somewhere and save it until you have tested that you can login.

Also, see http://aquesthosting.headtreez.com/doc/0c193063-fe3b-46fa-b604-0917b450549d to see how to prevent this from happening again.

This is a common probem that is occuring in Community Server 2.1. It is caused because when the area was last edited and saved, an extra set of <div> tags got added to your text. The fix that I'm reading on the Community Server forums has been to delete the rows in the cs_content table for the affected data. You can find more details here: http://communityserver.org/forums/permalink/542732/548751/ShowThread.aspx#548751.

1. Login to your CS Adminstration pages.
2. Go to Membership > New Registration Settings, then set Password Recovery to "Link" instead of "Reset".

1. Connect to your database.
2. Open the 'aspnet_Users' table, find the user and note the userID.
3. Open the 'aspnet_Membership' table find the line with the matching userID, and type in the password in the password field.

Scenario:

I'm working on a CommunityServer site (v2.1 .Net 2), and need to add custom user fields. This site is for a professional organization where the members have a 'License #', so they want the 'Sign-Up' form to require the user to enter:

• License #     (store in cs_Users)

• First Name   (store in aspnet_Profile as commonname)

• Last Name   (store in aspnet_Profile as commonname)

in addition to the default fields required by CommunityServer at sign up. This will allow them to verify the user's credentials before activating their user account.

CS stores a ‘commonname’ value in the aspnet_Profile table, so I will take advantage of that to store my first and last name values. With the license# field, I have to get a little creative, and I will store that in the cs_Users table. In both cases, there is no need to alter the database as these tables store properties in arrays in a single field, so we can just add to the items in those arrays.

Process:

Part I: Changing the Sign up form.

In the web application:

1)      Change 'communityserver.config'  by adding this under "<CommunityServer>":

< ExtendedUserData >
   < add name = "LicenseNo" />
</ExtendedUserData>

*You could add more items if you want to store more custom properties in the ‘cs_Users’ table.

2)      In the CommunityServerControls20 project, open User\CreateUser.cs

a.       In the class variables, add:

TextBox LicenseNo;

            TextBox FirstName;

TextBox LastName;

b.      In AttachChildControls() add:

LicenseNo = (TextBox)FindControl("LicenseNo");

            firstname = (TextBox)FindControl("FirstName");

  lastname = (TextBox)FindControl("LastName");

c.       In SaveAdditionalProfileData(User user), add the first and last names to the user.Profile.CommonName before the user is saved (see red mods).

protected virtual void SaveAdditionalProfileData(User user)

            {

                  if (timezone != null)

                        user.Profile.Timezone = double.Parse(timezone.SelectedItem.Value);

            string commonname = "";

            if (firstname != null)

                commonname = firstname.Text.Trim() + " ";

            if (lastname != null)

                commonname += lastname.Text.Trim();

            user.Profile.CommonName = commonname.Trim();

                  if (csContext.SiteSettings.ShowContactCheckboxes)

                  {

                        if (allowSiteToContact != null)

                              user.AllowSiteToContact = allowSiteToContact.SelectedValue;

                        if (allowSitePartnersToContact != null)

                              user.AllowSitePartnersToContact = allowSitePartnersToContact.SelectedValue;

                  }

                  SetExtendedUserData(user);

                  Users.UpdateUser(user);

            }

      * If you are wondering why I’m not adding something for ‘LicenseNo’, the reason is that the ‘SetExtendedUserData(user)’ call will handle that without making any further mods to the code.

3)      In Themes\default\Skins\ Skin-CreateUser.ascx, I add the following html:

< tr >

            < td align="right">

                  < CS : ResourceControl runat="server" ResourceName="CreateNewAccount_LicenseNo" ID="Resourcecontrol12"/>

            </ td >

            < td align="left">

                  < div class="CommonFormField">

                        < asp : textbox id="LicenseNo" MaxLength="64" runat="server" columns="40" ></asp:textbox>

                        < asp : RequiredFieldValidator EnableClientScript="false" id="RequiredFieldValidator1" runat="server" ControlToValidate="LicenseNo" Cssclass="validationWarning">*</asp:RequiredFieldValidator>(from your membership card)                     

                  </ div >

            </ td >

      </ tr >

      < tr >

            < td align="right">

                  < CS : ResourceControl runat="server" ResourceName="CreateNewAccount_FirstName" ID="Resourcecontrol13"/>

            </ td >

            < td align="left">

                  < div class="CommonFormField">

                        < asp : textbox id="FirstName" MaxLength="64" runat="server" columns="40" ></asp:textbox>

                        < asp : RequiredFieldValidator EnableClientScript="false" id="RequiredFieldValidator2" runat="server" ControlToValidate="FirstName" Cssclass="validationWarning">*</asp:RequiredFieldValidator>                  

                  </ div >

            </ td >

      </ tr >

      < tr >

            < td align="right">

                  < CS : ResourceControl runat="server" ResourceName="CreateNewAccount_LastName" ID="Resourcecontrol14"/>

            </ td >

            < td align="left">

                  < div class="CommonFormField">

                        < asp : textbox id="LastName" MaxLength="64" runat="server" columns="40" ></asp:textbox>

                        < asp : RequiredFieldValidator EnableClientScript="false" id="RequiredFieldValidator3" runat="server" ControlToValidate="LastName" Cssclass="validationWarning">*</asp:RequiredFieldValidator>            

                  </ div >

            </ td >

      </ tr >

A note about the above html: The ‘id’ value of each of the textboxes much match the names I put in the config files exactly. These ARE case-sensitive. For the ‘LicenseNo’ textbox the name must match exactly what I put in ‘communityserver.config’.  For the ‘FirstName’ and ‘LastName’ textboxes, it must match exactly what was used in the previous step when altering  ‘CreateUser.cs’ file.

Also note that I put in RequiredFieldValidators on all 3 of these rows to make sure the user puts in the information requested.

4)      Now to set our labels, we need to edit Languages/en-US/Resources.xml in the web application.

Add the following resources in the appropriate sections:

 (*Add these to the section where they begin with ‘CreateNewAccount_’)

< resource name = "CreateNewAccount_LicenseNo">ADHA Member #</resource>

< resource name = "CreateNewAccount_FirstName">First Name:</resource>

< resource name = "CreateNewAccount_LastName">Last Name:</resource>

 (*Add this to the section where they begin with ‘EditProfile_’)

< resource name = "EditProfile_LicenseNo">ADHA Member #</resource>

Compile CommunityServerControls20, and put the updated dll CommunityServer.Controls.dll) in your website bin.

Now you are done changing the Sign up form.

Now we want to change the Administrators EditUser page so our new properties show up there and can be edited there by the administrator. This is dependent on some of the changes made in the earlier section.

Part II: Changing the Administrators EditUser page.

*Some of this is dependent on things we’ve done in Part I.

This will be much easier than Part I. What we need to do is change web\Controlpanel\Membership\UserEdit.aspx .

 1) In the html view, I find a location where I want to show my items and insert these 2 rows:

< tr >

< td class="CommonFormFieldName" width="45%">

            < cp : resourcecontrol runat="server" resourcename="EditProfile_CommonName" id="ResourceControl5" name="ResourceControl5" />

      </ td >

      < td class="CommonFormField">

            < asp : textbox id="CommonName" size="30" maxlength="50" runat="server" />

      </ td >

</ tr >

< tr >

      < td class="CommonFormFieldName" width="45%">

            < cp : resourcecontrol runat="server" resourcename="EditProfile_LicenseNo" id="ResourceControl2" name="ResourceControl2" />

      </ td >

      < td class="CommonFormField">

            < asp : textbox id="LicenseNo" size="30" maxlength="50" runat="server" />

</td>

</tr>

*The textbox id’s are again case sensitive.

We don’t need to make any changes to the code behind. Its not magic, but I’ll leave it you to read the code behind if you really want to see why this works without adding more code to the code behind page.

Here’s what the changed pages look like:

First of all, we only allow you to send authenticated email through our SMTP mail server so you must first setup your email domain so you will have a valid email account for validation.

1. Setup your email at Aquest Hosting if this hasn't been done.
   • Login the Aquest control panel.
   • Go to the 'Email' page.
   • Create your email domain.
2. Setup Email Settings in Community Server.
   • Use SMTP Authentication: true
   • SMTP Server: hostmail.aquesthosting.com
   • Port: 25
   • Authentication Required: true
   • User Name: [your full email address used to login to SmarterMail]
   • Password: [your password used to login SmarterMail]

   Note: The SMTP server above (hostmail.aquesthosting.com) is only accessible by code running on our servers, so if you are running code on a computer not on our network, you need to use your own SMTP server address.

You need to edit the line stated as:

wwwStatus = "Remove"

so that it reads:

wwwStatus = "Require"

Now save your file. Open and save your web.condfig file (make no changes to it) to force your site to reload.

Now all site visitors, whether using www in the URL or not, will be hitting the site with the www in the URL.

A.) If you are referring to .Net dlls, then yes. You simply upload the Dlls to your 'bin' folder, and your website can then use them.

If you are referring to COM dlls, then they would have to be registered by our staff on your web server. There is a charge for us to install COM dlls. Please refer to http://www.aquesthosting.com/addons.aspx for current pricing.

A.) No

A.) Use the "Server.MapPath" function:

C# sample
string path = Server.MapPath(@"~/Images/");

That will return the path of the "Images" folder under the root of your website.

<%string path = server.MapPath(".")%>

This returns the name fo the folder that the page is in.

Your code is looking to the root of your website for a folder called "/aspnet_client/system_web/1_1_4322/WebUIValidation.js". Since it isnt there, it goes on and does the post back.

Please copy and upload the folder "c:/inetpub/wwwroot/aspnet_client" from your computer to the root folder of your website on our server.

Your code is looking to the root of your website for a folder called "/webctrl_client/...". It works fine on your computer because the root of your site on your computer is C:\inetpub\wwwroot\, and the folder exists. On our server, the root of your site is your domain folder.

Please copy and upload the folder "c:/inetpub/wwwroot/webctrl_client" from your computer to the root folder of your website on our server.

The error you are getting is becuase we have Parent Paths disabled, so you cannot use the "../" to move backwards (up) your folders. Please try this: Server.MapPath("/myFolder/myfile.htm")

The above line begins at the root of your domain, and moves down to your folder. This method has the added benefit that you can move your script page to another folder, and it will still work, as long as you don't move "/myfolder/myfile.htm" because it will always start at the root instead of being dependent on the location of the script file.

A.) First of all, we only allow you to send authenticated email through our SMTP mail server so you must first setup your email domain so you will have a valid email account for validation.

1. Setup your email at Aquest Hosting if this hasn't been done.
   • Login the Aquest control panel.
   • Go to the 'Email' page.
   • Create your email domain.
2. Setup Email Settings in DotNetNuke by logging in with the 'host' account and going to the 'Settings' page (image below).
   • SMTP Server: hostmail.aquesthosting.com
   • SMTP Authentication: Basic
   • User Name: [your full email address used to login to SmarterMail]
   • Password: [your password used to login SmarterMail]

   Note: The SMTP server above (hostmail.aquesthosting.com) is only accessible by code running on our servers, so if you are running code on a computer not on our network, you need to use your own SMTP server address.
   

We provide our customers with email hosting for each domain we host (not for domain pointers). Email runs on SmarterMail, which is a truly outstanding email server, and has a great web interface allowing you to check your email from anywhere you have internet access.

1. Create your SmarterMail account for your domain:
   • Login to your Aquest Control Panel.
   • Go the 'Email Setup' page
   • Pick the domain from a list of your domains in the drop-down list.
   • Press the 'Setup Email' button.
2. Now you can login to your SmarterMail web interface to manage email.
   • If your domain has propagated to our servers, use http://mail.[yourdomain]
   • If your domain hasn't propagated, use http://mail.aquesthosting.com
3. *Your initial email user account is setup as the user that created the email account. When logging into SmarterMail, you need to use the full email address as the user name. For example, if your Aquest user name is 'jsmith' and your domain is 'abc.com', your SmarterMail user name is 'jsmith@abc.com'. Your password will be the same as your Aquest password.
4. For more details and email help, each page in the SmarterMail web interface has a 'Help' link to bring up page specific help.

First you need to create your email domain by logging into the Aquest Hosting control panel and using the 'Email' page to setup your domain in SmarterMail.

If your domain is already active at Aquest Hosting, you should now be able to access http://mail.[yourdomainNameHere].com. If you can not access your mail domain, then you can use http://mail.aquesthosting.com.

Login to SmarterMail:

• UserName: This will be a full email address of [yourAquestUserName]@[yourDomain].com. For instance, if your Aquest user name is 'bob' and your domain is 'abc.com' then your email user name is 'bob@abc.com'.
• Password: [your Aquest password]

We have a picture tutorial at http://www.aquesthosting.com/HowTo/General/OutlookPop3.aspx which shows how to setup Outlook 2003. Other email clients will be similar.

 The default list command of stServ doesn't work. Request from support@aquesthosting.com to have your list command changed to LIST. Once done you can send an email to list@YourDomain.com, subject line doesn't matter, and in body text type, without quotes, "subscribe NameOfYourList". For example, if your list is friends@YourDomain.com then your body text would read "subscribe friends".

The only defense against it is the utilization of what is known as a SPF record added to DNS. In essence, what this does is prevents anyone from sending email that does not originate from the IP address of the mail server for your domain.

There is a setup fee to have us setup the SPF record. Please submit a Trouble Ticket for current pricing or to have this setup.

Moved to http://aquesthosting.headtreez.com/doc/c709bdae-2163-443f-8f75-1ba423ad44c9

we have a C# code sample here: http://headtreez.com/site/AquestHosting/e8e7c128-4a59-4010-a463-fb808520f72a 

Moved to: http://aquesthosting.headtreez.com/doc/5f67fb22-62d6-4650-b213-79de62e97785

Moved to: http://aquesthosting.headtreez.com/doc/871b6ca4-a7d1-41a1-a21d-4d75cba8829f

1. You send us information required to generate CSR (see list below).
2. We setup your new IP address, generate your CSR and send it to you.
3. You purchase a SSL Certificate from a cetificate provider such as (www.instantssl.com).
4. We install the SSL Certificate to your domain.
5. We set the files or folders to require SSL.

Before you can purchase an SSL certificate, you will need a CSR to send to the SSL certificate store. We will generate this for you. In order to generate the CSR, we need from you:

1. Organization Name (ie: My Company). This must match the name of the owner of your domain as listed at your domain registrar.
2. Organizational Unit - (ie: Sales, or NorthCarolina, or mydomain.com) - This is fairly flexible.
3. Common Name - www.mydomain.com
4. Province - (ie: North Carolina)
5. City - (ie: Greensboro)
6. Country  - (ie: US)

Just letting you know what was the issue so you have it available for anyone else experiencing a similar issue. I tried Pasv and Port FTP settings for both a FTP client, explorer, and msdos FTP but that did not fix the issue. I tried the FTP from another machine on my ISP router and it worked fine. Then I tried the FTP test from a virtual PC on the machine I was have a problem with and it also worked. So after turning off windows xp firewalls as well as my router's firewall, I was still experiencing this issue. I then updated my windows XP to sp3 but that did not fix the issue.

I then noticed this problem was only occurring for 10k file or smaller.

Anything over 10k transferred sucessfully.

Finally, I began looking at the Net Nanny product installed on the machine having an issue. First I shut off Net Nanny, but that did not fix the issue.

Then I proceeded to uninstall Net Nanny and bingo issue has been resolved. I no longer have problem with 426 Connection Closed; Transfer Abort". So even though Net Nanny was turned off it still apparently interfered with FTP file transfers that interestingly were small in file size. I am not sure if Net Nanny gets got between timing something since the files are small and transfer in a second.

Our thanks to Patrick for sending us the cause and resolution to this issue.

This section of the Aquest Hosting HeadTree contains some ASP.NET code samples, mostly in C# that you may find useful as you are developing your own site.

To generate the script:

On your computer, open the ASP.Net command line and enter:

aspnet_regsql.exe -A all -sqlexportonly runproviders.sql

That generates the basic script for you, and puts into a file called runproviders.sql. Open that file and use the "Edit | Replace" feature of your text editor to replace every instance of "aspnetdb" with your own database name.

Connect to your SQL server and click the "New Script" button in SQL Server Studio, paste the script into the script text editor, and run it.

( *Note: you can also run the script directly from the command line against your remote SQL intance by setting the flags to your server, database, user name and password. Complete details about the command line flags can be found at http://msdn2.microsoft.com/en-us/library/x28wfk74.aspx. )

That has created all your Roles, which you can see under the "Security | Roles" part of your database.

Last part is to give your user account access to the roles with the following script (replace "YourUser" with your database user name), and run this little script. Then you are done with setting up SQL Server 2005 for the ASP.Net 2.0 Providers.

go

Aquest Hosting customers:

You must use smtp authentication when sending mail from our servers which means that you must first setup your email account on our system if you are using our SMTP server. 

• To setup your email account login to https://admin.aquesthosting.com, and use the 'Email' page. 

• Code running on our servers must use the smtp server: "hostmail.aquesthosting.com"
• Code running outside our network needs to use: "smtp.[yourDomainName].com"
• UserName: your full valid email address (ie: bob@abc.com)
• Password: your email password

Not an Aquest Hosting customer?

Well you should be :)
You can use this code, but you need to know your smtp server, user name and password. If you don't need to use authentcated mail, then comment out the lines that have to do with authentication.

And now, the code...

Sub SendCDOMail(MailTo, MailFrom, subject, body, smtpServer, mailUserName, mailPassword)

 Const cdoSendUsingMethod = "http://schemas.microsoft.com/cdo/configuration/sendusing"
 Const cdoSendUsingPort = 2
 Const cdoSMTPServer = "http://schemas.microsoft.com/cdo/configuration/smtpserver"
 Const cdoSMTPServerPort = "http://schemas.microsoft.com/cdo/configuration/smtpserverport"
 Const cdoSMTPConnectionTimeout = "http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout"
 Const cdoSMTPAuthenticate = "http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"
 Const cdoBasic = 1
 Const cdoSendUserName = "http://schemas.microsoft.com/cdo/configuration/sendusername"
 Const cdoSendPassword = "http://schemas.microsoft.com/cdo/configuration/sendpassword"

 Dim objConfig  ' As CDO.Configuration
 Dim objMessage ' As CDO.Message
 Dim Fields     ' As ADODB.Fields

 ' Get a handle on the config object and it's fields
 Set objConfig = CreateObject("CDO.Configuration")
 Set Fields = objConfig.Fields

 ' Set config fields we care about
 With Fields
  .Item(cdoSendUsingMethod)       = cdoSendUsingPort
  .Item(cdoSMTPServer)            = smtpServer 
  .Item(cdoSMTPServerPort)        = 25
  .Item(cdoSMTPConnectionTimeout) = 10

  .Item(cdoSMTPAuthenticate)      = cdoBasic
  .Item(cdoSendUserName)          = mailUserName 
  .Item(cdoSendPassword)          = mailPassword 

  .Update
 End With

 Set objMessage = CreateObject("CDO.Message")

 Set objMessage.Configuration = objConfig

 With objMessage
  .To       = MailTo  
  .From     = MailFrom  
  .Subject  = subject 
  .HTMLBody = body 
  .Send
 End With

 Set Fields = Nothing
 Set objMessage = Nothing
 Set objConfig = Nothing
 
End sub

The ASPMail component is used if you are using Classic ASP (NOT ASP.NET).

If you need to download the component for development use on your own computer, go to http://www.serverobjects.com/ and download the 30 day trial.

Here is a code sample. The only thing you will need to change is the To and From address in the code below. Use the RemoteHost that we have specified.

Note the following RemoteHost will not work until your code is on our server.

VBScript code:

You can find more details about the ASPMail component at http://www.serverobjects.com/

*This code is somewhat out of date. We now require all email to be authenticated. For some of our older customers (you signed up in 2003 or 2004), you may be able to use this because we don't require authentication from our early servers. New customers will not be able to use ASPMail because it does not support authentication. We assume you will probably be using ASP.Net anyway and it is easy to send mail from ASP.Net code.

At Aquest Hosting, we require mail to be authenticated to go through our SMTP server, but this function is setup to take a parameter specifying whether or not smtp authentication should occur. So if  you are an Aquest Hosting customer, you should use 'true' for that parameter, otherwise consult your system admin or web host to determine if you should use authentication.

Note that this code is in a code behind page with the appropriate text boxes in the first function to get data from the user. I'm leaving it up to you to create the page and or collect your data. The main point here is the 2nd function that actually is responsible for sending the email.

Here is the sample code in ASP.NET 2.0 C#:

• title
• CSS link (our default styles)
• CSS in-page styles (the site's override styles)
• description
• keywords

protected void AddHeaders(string Title, string Desc, string Keywords,string CssLink, string Css)

{

   try

   {

      HtmlHead myHeader = (HtmlHead)this.Page.Header;

 

      if (myHeader != null)

      {

         //Add base CSS sheet

         if(CssLink != null && CssLink.Length > 0)

         {

            HtmlLink myLink = new HtmlLink();

            myLink.Attributes.Add("href", CssLink);

            myLink.Attributes.Add("rel", "stylesheet");

            myLink.Attributes.Add("type", "text/css");

            myHeader.Controls.Add(myLink);

         }

         if (Title != null && Title.Length > 0)

         {

            HtmlTitle myTitle = new HtmlTitle();

            myTitle.Text = Title;

            try

            {

               /*not sure if this the best way to remove the old title, but works in my case*/

               myHeader.Controls.Remove(this.Page.Header.Controls[0]);

               myHeader.Controls.Add(myTitle);

            }

            catch

            { }

         }

         if (Desc != null && Desc.Length > 0)

         {

            HtmlMeta myDesc = new System.Web.UI.HtmlControls.HtmlMeta();

            myDesc.Attributes.Add("name", "description");

            myDesc.Attributes.Add("content", Desc);

            myHeader.Controls.Add(myDesc);

         }

         if (Keywords != null && Keywords.Length > 0)

         {

            HtmlMeta myKw = new System.Web.UI.HtmlControls.HtmlMeta();

            myKw.Attributes.Add("name", "keywords");

            myKw.Attributes.Add("content", Keywords);

            myHeader.Controls.Add(myKw);

         }

         //Add customized CSS

         if (Css != null && Css.Length > 0)

         {

            Literal litCss = new Literal();

            litCss.Text = "<style type=" + '"' + "text/css" + '"' + ">" + Css + "</style>";

            myHeader.Controls.Add(litCss);

         }

      }

    }

   catch

   {

      //Handle your unexpected error.

   }

}

 

 

Hope it helps you do this a little quicker than I did.

//This function returns the Application path, like http://www.JoesWebsite.com/, or if the project is running in a virtual directory it returns the Application path of the virtual directory, like http://www.JoesWebsite.com/forums/ .

public static string ApplicationPath
{
   get
   {
      string APP_PATH = System.Web.HttpContext.Current.Request.ApplicationPath.ToLower();
      if(APP_PATH == "/")      //a site
         APP_PATH = "/";
      else if(!APP_PATH.EndsWith(@"/")) //a virtual
         APP_PATH += @"/";

      return APP_PATH;

   }
}

This function returns the Mapped path, like "D:\Hosting\Smith\JoeSmithWebsite\"

public static string MappedApplicationPath
{
   get
   {
      string APP_PATH = System.Web.HttpContext.Current.Request.ApplicationPath.ToLower();
      if(APP_PATH == "/")      //a site
         APP_PATH = "/";
      else if(!APP_PATH.EndsWith(@"/")) //a virtual
         APP_PATH += @"/";

      string it = System.Web.HttpContext.Current.Server.MapPath(APP_PATH);
      if(!it.EndsWith(@"\"))
         it += @"\";
      return it;
   }
}

So how do you get the correct relative URL when you are in the html view? If you want to use server controls then there is the famous "~/folder/file" method, which is great because this allows you to get the application path and it works when being called from a page in the root of your site, or when used in a page in a subfolder, but it can only be used by Server Controls (ie: "<asp:Image id=myImage runat=Server imageurl="~/images/smile.gif" />"), but if you don't want to use a server control, you can use the code below in the Global.asax file's Session_Start function as shown below. When you add a Global.asax file to your project, the Session_Start function is already there, so you just add the inner function code.

void Session_Start(Object sender, EventArgs e)
{ 

   // Code that runs when a new session is started
   string APP_PATH = System.Web.HttpContext.Current.Request.ApplicationPath.ToLower(); 
   if (APP_PATH == "/") //a site 
      APP_PATH = "/";
   else if (!APP_PATH.EndsWith(@"/")) //a virtual 
      APP_PATH += @"/";
   Session["APP_Path"] = APP_PATH;  //stores the value to a session variable for us to use
}

Now, to use the session variable "APP_Path" that you've created in an html page, you will write your image tags like this:

<img src="<%=Session["APP_Path"] %>images/smile.gif" />

You can also get the value in your code-behind by accessing the session variable:

 string myPath = Session["APP_Path"].ToString();

There code can be reduced by taking out the functionality to check the file types, but I like to make sure that the file type is an expected type. The code below allows you to upload .gifs, .jpeg, .jpg, .swf, but not other types which is a safety precaution worth the extra lines of code.

This code saves the uploaded image to the "Images" folder of the web application which is set in the first couple of lines. You may need to alter that, an it determines the website folder at run time so it doesn't need to be changed to run in different websites.

On the HTML view of the page, you need to place a Text box with a browse button which can be done with the following html tag:
<INPUT id="filUpload" type="file" name="filUpload" runat="server">

Now put a button on the screen and call it "cmdUpload", then double click the button to go to the click event and add this code in your code behind file:

public class Person

{

    private int _ID;

    private string _Name;

    private string _Color;

    public override string ToString()

    {

        return _Name;

    }

    // Properties   

    public int ID

    {

        get { return _ID; }

        set { _ID = value; }

    }

    public string Name

    {

        get { return _Name; }

        set { _Name = value; }

    }

    public string Color

    {

        get { return _Color; }

        set { _Color = value; }

    }   

}

Ok so now we need a function in our ASP.net page that loads a <List> of Person's into the DropDownList.

Option 1) We set the DataTextField and the DataValueField. This relies on the public properties in Person

    protected void LoadList()

    {       

        List<Person> myPList = new List<Person>();

        Person p1 = new Person();

        p1.ID = 1;

        p1.Name = "Bob";

        p1.Color = "Blue";

        Person p2 = new Person();

        p2.ID = 2;

        p2.Name = "Joe";

        p2.Color = "Green";

        myPList.Add(p1);

        myPList.Add(p2);

        this.DropDownList1.DataSource = myPList;

        this.DropDownList1.DataTextField = "Color";

        this.DropDownList1.DataValueField = "ID";

        this.DropDownList1.DataBind();       

    }

The HTML output will be:

 <select name="DropDownList1" id="DropDownList1">
 <option value="1">Blue</option>
 <option value="2">Green</option>
 </select>

Option 2) Not setting the DataTextField and the DataValueField. This relies on the 'ToString() override in Person bind the text field.

protected void LoadList()

    {       

        List<Person> myPList = new List<Person>();

        Person p1 = new Person();

        p1.ID = 1;

        p1.Name = "Bob";

        p1.Color = "Blue";

        Person p2 = new Person();

        p2.ID = 2;

        p2.Name = "Joe";

        p2.Color = "Green";

        myPList.Add(p1);

        myPList.Add(p2);

        this.DropDownList1.DataSource = myPList;       

        this.DropDownList1.DataBind();       

    }

The HTML output will be the ToString() value for both the text and value.

<select name="DropDownList1" id="DropDownList1">
 <option value="Bob">Bob</option>
 <option value="Joe">Joe</option>
</select>

<div>
    <asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
    <asp:Literal ID="Literal1" runat="server"></asp:Literal>
</div>

You need to put a PlaceHolder in your ASP.net page where you want the control to appear. You don't need the literal, but in this sample is used to show that the linkbutton we add will actually fire it's click event.

Here is the code-behind page that will add the LinkButton and wire its click event.

protected void Page_Load(object sender, EventArgs e)
{ 
    LoadLinkButton();
}
protected void LoadLinkButton()
{ 
    LinkButton LinkButton1 = new LinkButton(); 
    LinkButton1.Text = "Button Text"; 
    LinkButton1.Click += new EventHandler(LinkButton1_Click); 
    this.PlaceHolder1.Controls.Add(LinkButton1);
}
protected void LinkButton1_Click(object sender, EventArgs e)
{ 
    this.Literal1.Text = "Link was clicked.";
}


In the LoadLinkButton function, we create a new linkButton control, assign it's Text and its Click event, and then add it to the placeHolder so it will be visible on the web form.

You can do this with any ASP.net control so don't limit yourself to linkButtons.

Cheers,
Marc Talcott
ASP.Net Host

    Value types are on the stack. When copied, the entire value is copied onto the stack again, so doubling the space used on the stack.

Built-in Types

(see table below) (All built in numeric types are 'value' types.)

Numeric Built-in types:

There are 300 more value types in the Framework, but above are the most common.

User-defined Types

Structs - Similar to class but stored on the stack.
Structs should:

1. Logically represent a single value
2. Has an instace size less than 16 bytes
3. Will not be changed after creation
4. Will not be caset to reference type

You can convert a struct to a class by changing the keyword 'struct' to 'class', and then it will be allocated on the managed heap instead of the stack. Structs generally perform better than classes if the size is 16 bytes or less.

Enumerations

// C#
enum Titles: int {Mr, Ms, Mrs, Dr};

represents a list for the developer to choose from.
-simplify code readability
-provides safety when users need to choose from specific values.
 

More on Value types:

 You don't use the 'new' keyword when creating an instance (int i = 0;)
 Best to assign a value when constructing, but not required.
 
 

New in .Net 2.0 - Nullable types

 Nullable<int> i = null;
 or
  int? i = null;

 With nullable types, you can use the 'HasValue' property to see if its null or not
 if(i.HasValue)
  //do something