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

Knowledge Base - Hosting FnQ

Windows Server - 03

1	Data Base
		How to create MYSQL DB
		MYSSQL Administer with PHP Myadmin
		Database Patch (ODBC connection)

2	E - Mails
		How to send email using ASP.NET2 VB
		Pop E-mail Account Settings
		CDOSYS (formerly CDONTS)

3	FTP
		Problems with FTP Connection
		Upload Files
		FTP Username

1) DataBase:

How to create MYSQL DB

Solution

You need to create your databases first using your our Site Control Panel (Ensim):
login and from the left menu
go to Services->MySQL->Configure (pencil icon)->Change Password.
Setup your password first, then go to Create Database link in the same area of the control panel.

After you are done with the database creation you can use the phpMyAdmin tool to manipulate the database including SQL query execution and table manupulation.

You can access the phpMyAdmin tool from your Ensim control panel - under section MySQL -> Database Administration

MYSSQL Administer with PHP Myadmin

Solution

You can access the phpMyAdmin tool from your Ensim control panel - under section MySQL -> Database Administration.

NOTE: Before you can use phpMyAdmin you need to setup your MySQL password and create your databases using our Site Control Panel (Ensim).

Database Patch (ODBC connection)

Solution

The database path for ODBC is c:\inetpub\vhosts\domain.com\ or d:\inetpub\vhosts\domain.com\ where, domain.com is your domain.

You need to add the actual directory name to that path. There is also a private\ directory that you can use as well. In addition you can create directory in your webroot - httpdocs\ and then password protect it from Plesk.

2) Email:

How to send email using ASP.NET2 VB

Solution

'This is an example only, and needs to be modified with proper information

'Sub SendEmail()

'create the mail message
Dim nmail As New System.Net.Mail.MailMessage

'set the addresses
nmail.To.Clear()
nmail.To.Add(New System.Net.Mail.MailAddress("recipient name "))
nmail.From = New System.Net.Mail.MailAddress("my name ")

'set the content
nmail.Subject = "This is an email"
nmail.Body = "this is the body content of the email."

'prepare to send the message
Dim smtp As System.Net.Mail.SmtpClient = New System.Net.Mail.SmtpClient("mail.mydomain.tld")

'you need to use the credentials of an existing mail account
smtp.Credentials = New System.Net.NetworkCredential("me@mydomain.tld", "mypassword")

Try
smtp.Send(nmail)
Catch ex As Exception
Response.Write("Error: " & ex.ToString())
End Try

End Sub

Pop Email Account

Solution

Incoming (POP3)	mail.your-domain.com
Outgoing (SMTP)	mail.your-domain.com
Outgoing SMTP	Authentication needs to be ENABLED
Outgoing port	default
Username	Your full email address

CDOSYS (formerly CDONTS)

Solution

The CDOSYS mailing component is supported and recommended. Below is an example of how to use the mailing component in ASP:

Dim Subject, Body, SenderEmail, RecipientEmail, SMTPServer, SMTPusername, SMTPpassword

SenderEmail = "me@mydomain.tld"
RecipientEmail= "someone@somedomain.tld"
SMTPserver = "mail.mydomain.tld"
SMTPusername = "me@mydomain.tld"
SMTPpassword = "mypassword"

Subject = "Hello"
Body = "This is a test. Please ignore."

sch = "http://schemas.microsoft.com/cdo/configuration/"
Set cdoConfig = CreateObject("CDO.Configuration")
With cdoConfig.Fields
.Item(sch & "sendusing") = 2
.Item(sch & "smtpserver") = SMTPserver
.Item(sch & "smtpserverport") = 587
.Item(sch & "smtpauthenticate") = 1
.Item(sch & "sendusername") = SMTPusername
.Item(sch & "sendpassword") = SMTPpassword
.Item(sch & "smtpusessl") = False
.Item(sch & "connectiontimeout") = 100
.update
End With
Const cdoSendUsingPickup = "c:\inetpub\mailroot\pickup"
Set cdoMessage = CreateObject("CDO.Message")
With cdoMessage
Set .Configuration = cdoConfig
cdoMessage.From = SenderEmail
cdoMessage.To = RecipientEmail
cdoMessage.Subject = Subject
cdoMessage.TextBody = Body
cdoMessage.Send
End With
Set cdoMessage = Nothing
Set cdoConfig = Nothing

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:

FTP Username

Solution

Please note that when connecting to our Windows servers you need to include the server name before the username that you have specified in the format: "SERVER\username"

Exclusive Offer

Knowledge Base (FAQ)

Support Form

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