Step 1: Download the latest WordPress installation file from the http://wordpress.org/download/ , download it by clicking on "Download" button.

Step 2: You could upload it via FTP or the DNP control panel File Manager and unzip the file. For your information, if you upload the file to wwwroot folder, after the installation is completed, the file script will appear once you visit your website is http://yourdomainname.com

Another option is to create a subfolder in your hosting account and upload the file in it. The WordPress installation will be accessible at http://yourdomainname.com/subfolder

Step 3: Create a MySQL database for WordPress in Do Net Panel.

Step 4: Open the URL http://domainname.com in Internet browser. Then click on the "Create a Configuration File" button. Fill in the database detail and site detail then finish the installation.

<?php
//Code for connection on Arvixe
$myServer = "localhost\SQLEXPRESS";
$myUser = "Database User Name"; // replace with your values
$myPass = "Database Password"; // replace with your values
$myDB = "Database Name"; // replace with your values

//create an instance of the ADO connection object
$conn = new COM ("ADODB.Connection")
or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB;
$conn->open($connStr); //Open the connection to the database
?>

EMS SQL Manager for SQL Server is a high performance tool for Microsoft SQL Server database development and administration. It can be used as an alternative to Microsoft SQL Server Management Studio.

# Make sure you have installed "Microsoft ® SQL Server ® 2008 R2 Native Client" to download this link http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=ceb4346f-657f-4d28-83f5-aae0c5c83d52

The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.

Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008.

SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 R2 features.

This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 R2 features, and optionally installs the header files needed to develop an application that uses the SQL Server Native Client API.

Yes. We do allow remote access to the MSSQL. It is offered on the regular port 1433.

Yes. Please use the following connection string and fill in the necessary spots with your database's information:

<add name="strConn" connectionString="Data Source=localhost;Initial Catalog=DBNAME;Integrated Security=false;User ID=DBUSERNAME;Password=DBPASSWORD" />

DBNAME is what you specified as your database name in the control panel
DBUSERNAME is the username you created to connect to the database (and was associated with the database in the control panel)
DBPASSWORD is the password you associated with the username above

An example script:

<%@ Import Namespace="System.Data.SqlClient" %>
<%
Dim conn As SqlConnection
Dim sqlQuery As SqlCommand
Dim dtrTbl As SqlDataReader
conn = New SqlConnection( "Server=localhost;uid=USERNAME;pwd=PASSWORD;database=DBID" )
conn.Open()
sqlQuery = New SqlCommand( "Select COLLUMN_NAME From TABLE_NAME", condDBID)
dtrTbl = sqlQuery.ExecuteReader()
While dtrTbl.Read()
Response.Write(“<li>" )
Response.Write(dtrTbl( "COLUMN_NAME" ) )
End While
dtrTbl.Close()
conn.Close()
%>

If, when opening Microsoft SQL Server Management Studio, you receive the following error: The server principal <username> is not able to access the database <databasename> under the current security context. (Microsoft SQL Server, Error: 916)

The following steps should fix the problem:

1. In Object Explorer, click Databases
2. Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
3. Right click the column headers and deselect “collation”
4. Refresh Databases

For users using Visual Studio 2005 with an SQL 2008 database, you may run into the following error:

This server version is not supported. Only servers up to Microsoft SQL Server
2005 are supported.

If you have a specific need Visual Studio 2005 which Visual Studio 2008 does not provide you, then you should be able to by pass this error by running the following hotfix provided by Microsoft:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en

To connect to your MSSQL database remotely, please use a client that is capable of communicating with our MSSQL 2008 server on the TCP protocol. A free client is provided by Microsoft at: http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

We recommend using Microsoft SQL Server 2008 Management Studio (link above) as many other tutorials and knowledgebase articles are written around supporting this free client by Microsoft. Only the 2008 version will be able to connect to our MSSQL servers. If you have the 2005 version, please upgrade. The 2008 client is backwards compatible with 2005 servers so you will still be able to connect to your MSSQL 2005 servers with the 2008 version.

Are you getting this error when you try to change any of the information in your database?

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

To fix this error, go to *Tools* -> *Options* -> *Designers* -> *Table and Database Designers* and uncheck the Prevent saving changes that require table re-creation checkbox. This will remove the block that was enabled.

The instance name of the MSSQL 2008 server on any of our Windows accounts is "SQLEXPRESS". This is good to have when trying to connect to the specific instance locally when the instance was not installed as the Default Instance on the server. Please refer to the knowledgebase article on classic ASP connection strings in the ASP .NET category for more information.

Login to the Hosting control panel
1. Click Domains
2. Click Add Domain
3. Click Sub-domain
4. Give the Sub Domains Name Example "Forum"
5. Click Add Domain
You are Done!

To send an email from .NET, use this code:

Dim msg As New MailMessage("to@example.com", "<emailaddress in your domain>")
msg.Subject = "Subject here"
msg.Body = "Body here"

Dim client As New SmtpClient("localhost")
client.Credentials = New Net.NetworkCredential("<email address in your domain>", "<password of this emailaccount>")
client.Send(msg)

C# Version

System.Net.Mail.MailMessage eMail = new System.Net.Mail.MailMessage();
eMail.IsBodyHtml = true;
eMail.Body = body;
eMail.From = new System.Net.Mail.MailAddress(fromEmail);
eMail.To.Add(toEmail);
eMail.Subject = subject;
System.Net.Mail.SmtpClient SMTP = new System.Net.Mail.SmtpClient();

SMTP.Credentials = new System.Net.NetworkCredential("user","pass");
SMTP.Host = "localhost";
SMTP.Send(eMail);