::. Hosting Partner .::. Domain Registration, Web Hosting, Reseller Account , Karachi

Knowledge Base - Hosting FnQ

Windows Server - 01

1	Data Base / Programming
		DSN-less Connect
		SQL Database Connection String
		Error '80004005
		Install CDONTS mail component on an IIS server

2	E - Mails
		How to add email accounts?
		Emails in bulk/spam mail boxes
		Do you have any sample script of using ASPEmail to send mail?
		Set up of Pop 3 and SMTP accounts

3	FTP
		Problems with FTP Connection
		Upload Files

1) DataBase:

Create a DSN-less Connect to my Access database?

Solution

- Upload your .mdb file to the Data folder parallel to the wwwroot folder.

- Create the server connection object:
Set adoCon = Server.CreateObject("ADODB.Connection")

- Define the path:
strDbPath = "d:\websites\yourdomain.com\data\yourdatabase.mdb"

- Define the driver and connection:
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPath

Note: Your database can reside anywhere inside your domain; placing it in the Data folder outside of the wwwroot folder is more secure. If your database resides in different folder under your wwwroot, adjust the path to: strDbPath = "d:\websites\yourdomain.com\wwwroot\datafolderpath\yourdatabase.mdb"

SQL Database Connection String

Solution

db_server = "<SQL server name/IP>,<Port No>"
db_user = "username"
db_pass = "password"
db_name = "database name"
conn_str = "Provider=SQLOLEDB;Data Source=" & db_server & ";User ID=" & db_user & ";Password=" & db_pass & ";Initial Catalog=" & db_name

OLE DB Provider for ODBC Drivers error '80004005"

Solution

The folder where you stored the database has to have read/write permission.

Install CDONTS mail component on an IIS server

Solution

We have both CDONTS and ASPmail installed.

2) Email:

How to add email accounts?

Solution

First goto http://mailadmin.yourdomainname.com

login to admin id

Emails in bulk/spam mail boxes

Solution

You need to add Mail.Helo = "yourdomain mail"
That line will transmit the handshake header to keep it out of spam/bulk email boxes

Do you have any sample script of using ASPEmail to send mail?

Solution

Set Mail = Server.CreateObject("Persits.MailSender")
Mail.Host = "mail.yourdomain.com"
Mail.From = "user@yourdomain.com"
Mail.Username = "user@yourdomain.com"
Mail.Password = "password"
Mail.FromName = "Your Name"
Mail.AddAddress "to@otherdomain.com"
Mail.AddBCC "cc@otherdomain.com"
Mail.Subject = "Subject of the email"
Mail.Body = "Body of the email"
On error resume next
Mail.Send
set Mail = nothing
If Err <> 0 Then
Response.Write "Error when trying to send mail"
end if

Pop 3 & SMTP setup

Solution

Due to a number of providers blocking the SMTP port (port 75) in order to try to deter spammers and unsolicited bulk email, we have set up a second SMTP server to be used by those that cannot send with port 75. The main differences between the two servers are:

Description	Normal Connection
Outgoing SMTP Server	mail.domainname.com
Outgoing SMTP Port	75
SMTP Authentication	Yes

Be sure to replace domainname.com with the domain name you are setting up e-mail for.

3) FTP

Problems with FTP Connection

Solution

Please note that our Windows FTP servers require Passive Mode to be enabled in your FTP client. If you are having problems connecting or listing directory contents, then it is likely that Passive Mode is not enabled in your FTP client. The exact way to enable this will be specific to your chosen software, so you should check the documentation which comes with your software for further details.

If you are using FileZilla 2.x, you can find this option in the Site Manager, by selecting a site and clicking on the Advanced button. In FileZilla 3.x, you can globally select the transfer mode by using the Settings -> Connection menu

Upload Files

Solution

We support FTP (along with FTP compatible software) and Frontpage to upload files

you can also used File Manager for uploading files through control panel

FTP :-

ftp.yourdomianname.com

user name:- user name

pass:

port : 281

Exclutsive Offer

Knowledge Base (FAQ)

Support Form

Designed & Hosted by YounazSoft & HostingPartner
A Project of Y I - Group