Windows 2012 Hosting - MVC 4 and SQL 2012 BLOG

Tutorial and Articles about Windows Hosting, SQL Hosting, MVC Hosting, and Silverlight Hosting

SQL 2014 Hosting Tutorial :: How to Create Histogram Chart in SQL

clock September 15, 2014 08:42 by author Ben

SQL Server 2014 will be an amazing release regarding all the various performance enhancements that are part of this new release. And know I wanna tell you about how to create Histogram Chart in SQL.

In this tips we will create a histogram chart in SQL 2014 to show how to aggregate data will very little effort.

Step 1
Let's create a sample table called Employee that has columns EmpID and EmpAge with the data as shown in the below screenshot.

Step 2
Create a new SSRS report and configure it to use the data from the table we just created. Add a bar chart to the report and configure it as shown in the below screenshot.

Step 3
Execute/Preview this report and your report should look like the below screenshot and you will see data listed for all fifteen employees.

In reality, an employee table can contain records for hundreds to thousands of employees and therefore if the requirement is to analyze age distribution this type of report won't serve the purpose. A typical approach to solve this issue would be to retrieve the count of employees falling into a few predefined age categories and show it in a distribution chart like a pie-chart. In the next few steps we will see how a histogram chart can be a much simpler approach.

Step 4
Select the EmpAge chart series and open the properties window. In the CustomAttribute category, select "ShowColumnAs" property and set the value as "Histogram" as shown in the below screenshot.

Step 5
Execute the report and you should find results similar to the below screenshot. This is a histogram chart, but the problem with this chart is that by default the chart has selected all fifteen distributions, so you get one employee for each age category which is not very helpful.

Step 6
Let's say we want to see the data in three age groups 20 - 25, 25 - 30 and 30 - 35 and the number of employees in each age group. In the CustomAttribute category, you will find a property "HistogramSegmentIntervalWidth" and the default value is zero. Change this value to "5", so that the age group we have is divided into 3 categories as desired. Execute the report and the report should look like the below screenshot. This chart shows 4 employees in the 20 - 25 group, 5 employees in the 25 - 30 group and 6 employees in the 30 - 35 group.

Also note that the "Percentage of Total" axis is generated and calculated automatically without any programming efforts and this axis is very useful in statistical analysis. This type of axis is not possible out-of-box in charts like pie-charts and hence charts such as histogram charts are preferred.



Reason Why you Must Choose ASPHostPortal.com
ASPHostPortal.com offers the newest Microsoft SQL 2014 database with all our hosting plans. We are your dependable SQL web hosting provider who will fulfill your needs!


Full Remote Access
We allow you full remote connectivity to your SQL Server 2014 Hosting database and do not restrict access in any way.

Easily transfer your existing SQL Server database
With our SQL Server hosting package, there's no need to rebuild your database from scratch should you wish to transfer an existing SQL Server database to us. If you already have a database hosted elsewhere, you can easily transfer the contents of your database using SQL Server Management Studio which is fully supported by our packages. SSMS provides you with an Import/Export wizard which you can use to upload your data and stored procedures with a couple of clicks.



ASP.NET MVC 4 Hosting - ASPHostPortal :: How to Fix Could not load file or assembly DotNetOpenAuth.Core, Version=4.0.0.0

clock September 8, 2014 09:33 by author Jervis

We have seen that many of our clients experience this problem and we have also found this issue on many forums. So, we decide to write the solution on this tutorial and hope it will fix your problem.

Error Message

Could not load file or assembly 'DotNetOpenAuth.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=2780ccd10d57b246' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

The Problem

The application was actually upgraded earlier from ASP.NET MVC 3, i.e. it was not autogenerated by Visual Studio 2012. The pre-binding info in the exception was:

=== Pre-bind state information ===
LOG: User = NT AUTHORITY\NETWORK SERVICE
LOG: DisplayName = DotNetOpenAuth.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=2780ccd10d57b246
 (Fully-specified)
LOG: Appbase = file:///
LOG: Initial PrivatePath = \bin
Calling assembly : Microsoft.Web.WebPages.OAuth, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35.
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: \web.config
LOG: Using host configuration file: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet.config
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\config\machine.config.
LOG: Post-policy reference: DotNetOpenAuth.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=2780ccd10d57b246
LOG: Attempting download of new URL file:////DotNetOpenAuth.Core.DLL.
LOG: Attempting download of new URL file:////DotNetOpenAuth.Core/DotNetOpenAuth.Core.DLL.
LOG: Attempting download of new URL file:////DotNetOpenAuth.Core.DLL.
WRN: Comparing the assembly name resulted in the mismatch: Minor Version
ERR: Failed to complete setup of assembly (hr = 0x80131040). Probing terminated.

The key pieces of information here are at lines 3 and 7. Basically, Microsoft.Web.WebPages.OAuth needs DotNetOpenAuth.Core 4.0.0.0. Please check your DotNetOpenAuth.Core version again. Basically the problem from the different version.

Solution

1. Add these lines under the <runtime>/<assemblyBinding> section of the root Web.config:

<dependentAssembly>
                <assemblyIdentity name="DotNetOpenAuth.AspNet" publicKeyToken="2780ccd10d57b246" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-4.3.0.0" newVersion="4.3.0.0" />
</dependentAssembly>
<dependentAssembly>
                <assemblyIdentity name="DotNetOpenAuth.Core" publicKeyToken="2780ccd10d57b246" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-4.3.0.0" newVersion="4.3.0.0" />
</dependentAssembly>

2. The above solution works for other packages that ASP.NET MVC 4 depends on. For example, if you upgrade WebGrease from 1.0.0.0 to 1.3.0.0, you have to add this to the <runtime>/<assemblyBinding> section:

<dependentAssembly>
                <assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-1.3.0.0" newVersion="1.3.0.0" />
</dependentAssembly>

 

 



SQL 2014 Hosting with ASPHostPortal.com :: Semantic Search Functions on SQL 2014 Hosting

clock September 8, 2014 05:59 by author Ben

Introductions Semantic Search

Text mining is also becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understand the meaning of documents.

The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft SQL Server 2014. Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases. Then it also uses these key phrases to identify and index documents that are similar or related.

For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description. Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios.

Semantic Search Functions on SQL 2014 Hosting

Here are some search function on semantic that we have to use to our program because it’s can make maximized sql 2014 features.

  •  semantickeyphrasetable (Transact-SQL)

Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table.

  •  semanticsimilaritydetailstable (Transact-SQL)

Returns a table of zero, one, or more rows of key phrases common across two documents (a source document and a matched document) whose content is semantically similar.

  •  semanticsimilaritytable (Transact-SQL)

Returns a table of zero, one, or more rows for those columns whose content is \semantically similar to a specified document.

How to install Semantic Search Functions on SQL 2014 Hosting

There are some steps that you must completely implemented before using semantic search

1. Install the semantic language statistics database.

Download the appropriate version of the Windows installer package named SemanticLanguageDatabase.msi. This file contains a compressed database file and log file.

Run the SemanticLanguageDatabase.msi Windows installer package to extract the database and log file. You should change the default destination directory to a location where SQL Server has necessary file permissions for attaching a database (SQL Server data folder for example). Optionally, you can move the extracted database file and log file to the preferred location in the file system.

2. Attach the semantic language statistics database.

Attach the database to the instance of SQL Server by using Management Studio or by calling CREATE DATABASE with the FOR ATTACH syntax. By default, the name of the database is semanticsdb. You can optionally give the database a different name when you attach it. You have to provide this name when you register the database in the following step:

CREATE DATABASE semanticsdb
ON (FILENAME = 'C:\Microsoft Semantic Language Database\semanticsdb.mdf')
FOR ATTACH;


Important

When the semantic language statistics database is extracted, restricted permissions are assigned to the database file and log file in the file system. As a result, the user may not have permission to attach the database. If an error is raised when you try to attach the database, check and fix file system permissions as appropriate.

3. Register the semantic language statistics database.

Call the stored procedure sp_fulltext_semantic_register_language_statistics_db and provide the name that you gave to the database when you attached it:

EXEC sp_fulltext_semantic_register_language_statistics_db @dbname = N'semanticsdb';
GO

Our Special SQL Server 2014 Hosting Complete Features
What we think makes ASPHostPortal.com so compelling is how deeply integrated all the pieces are. We integrate and centralize everything--from the systems to the control panel software to the process of buying a domain name. For us, that means we can innovate literally everywhere. We've put the guys who develop the software and the admins who watch over the server right next to the 24-hour Fanatical Support team, so we all learn from each other.



Comparison of Windows ASP.NET Hosting between ASPHostPortal.com Hosting Platform and Windows Azure Platform

clock August 25, 2014 07:43 by author Kenny

In this article, we wrote the review about Windows Azure Vs Shared Hosting. In this session we choose ASPHostPortal as a challenger of Windows Azure. ASPHostPortal.com is Microsoft No #1 Recommended Windows and ASP.NET Spotlight Hosting Partner in United States. While Windows Azure is Microsoft powered flexible Cloud service. It supports platforms such as Java, PHP& .NET. It is quite compatible with other Microsoft applications such as SharePoint, SQL server, & Microsoft Outlook.

ASPHostPortal offers the most bang for your buck: Just $5.00 per month, you get a Windows Server 2012 instance configured with 8GB RAM, 60GB of bandwidth and 5GB of storage. That price includes a generous support plan complete with 24/7 support from expert engineers, making it attractive for those who are completely new to hosted services.

Microsoft is currently offering a 30-day free trial of Azure. You receive a $200 credit to spend on Azure services during the trial. You can create and try out any combination of Azure resources you like. You will need to enter a credit card, though you won't bill during the period of the trial. One of the complaints sometimes leveled against Azure is its expense. You can spent more money for almost same service.

Check the service comparison between ASPHostPortal and Windows Azure below:

Provider

Spec

Price

Total

ASPHostPortal

5 GB Disk Space

$5.00/mo

$5.00/mo


60 GB Bandwidth


2 SQL Server


200 MB SQL Server / db


8 GB RAM or higher


Host Unlimited Sites

Windows Azure

20 GB Disk Space

$14.88/mo

$105.87/mo


60 GB Bandwidth

$6.60/mo


2 SQL Server

$9.99/mo


100 MB


1.6GHz CPU, 1.75GB RAM

$74.4/mo


500 Sites



SQL Server 2014 Hosting with ASPHostPortal.com :: How to Restart an Interrupted SQL Server Database Restore

clock August 23, 2014 09:53 by author Kenny

SQL Server is Microsoft's relational database management system (RDBMS). It is a full-featured databse primarily designed to compete against competitors Oracle Database (DB) and MySQL.

Like all major RBDMS, SQL Server supports ANSI SQL, the standard SQL language. However, SQL Server also contains T-SQL, its own SQL implemention. SQL Server Management Studio (SSMS) (previously known as Enterprise Manager) is SQL Server’s main interface tool, and it supports 32-bit and 64-bit environments.

In this article, we will tell you about how to restart an interrupted SQL Server Database Restore.
Have you ever restored a large database on a Failover Cluster Production Server and while the restore was in progress, due to network failure, the restore failed? Once the SQL Server came up on the other node all the databases came up, except for the database which you were restoring prior to the failover. In this tip we will take a look at the command RESTORE DATABASE...WITH RESTART to see how this command can be helpful during such scenarios.

Here is the solution

The RESTORE DATABASE...WITH RESTART command is a very useful command which is available in SQL Server 2005 and higher versions. A Database Administrator can use this command to finish restoring an interrupted database restore operation.

In the below snippet you can see that ProductDB is in a (Restoring...) state once the SQL Server came online after the unexpected failure.

During such scenarios one can execute the RESTORE DATABASE...WITH RESTART command to successfully complete the database restore operation.

Below are two commands.  The first gets a list of the backups on the file and the second does the actual restore with the restart option.

-- get backup information from backup file
RESTORE FILELISTONLY
FROM DISK ='C:\DBBackups\ProductDB.bak'
GO

-- restore the database
RESTORE DATABASE ProductDB
FROM DISK ='C:\DBBackups\ProductDB.bak'
WITH RESTART
GO

Below you can see that after running the RESTORE DATABASE...WITH RESTART command the database was successfully restored allowing user connectivity.



Windows Server 2008/2012 Hosting :: Unmanaged Dedicated Hosting vs Managed Dedicated Hosting

clock August 6, 2014 08:34 by author Jervis

We believe that you must very familiar with this word “Managed Hosting and Unmanaged Hosting”. What is it about? When you purchase VPS/cloud/dedicated server, you will see 2 option, do you want to use managed or unmanaged hosting. In this post, we will discuss differences between Managed Hosting & Unmanaged Hosting as well as advantages and disadvantages of both. We will more focus in managed hosting.

When you’re buying a house and you have two options. You can buy a home with no strings attached, so that YOU are responsible for cleaning, landscaping, security, and maintenance; OR, you can pay a little extra and have a self-sustaining house that completes all those tasks for you. You can purchase a home that has automatic security and fire protection built in–one that cleans itself, protects itself and magically keeps the lawn and flower beds looking great without any effort on your part. Sounds nice, right?

Well, there’s a chance you might be thinking: Why would I pay extra if I know how to lock the doors, put out a fire, mop the floors, mow the lawn and plant flowers on my own?

Now, imagine you don’t know how to do ANY

of those tasks: If you have no knowledge of how to manage a home, your house will be much better off in the long run if you purchase the fully managed, self-sustaining option. This scenario is much like what small business owners face when confronted with the hosting industry. Often they don’t have the tools or know-how to manage a server on their own, and a fully managed hosting plan can help.

It is same with hosting business. If you choose unmanaged hosting, you simply rent a server from a hosting provider, and the responsibility of managing that server falls on whoever has the most IT experience at a small business.

Well, managed hosting basically provides your small business with an exclusive, out-of-the-office IT department. This type of hosting plan means that a perfectly capable team professionals monitors your dedicated server 24/7/365, keeping your site performing at it’s best at all times. If you don’t have experience to manage the server, then you need to choose this managed service. Same like our description above. Just imagine it. 

Technical Knowledge

There is no doubt on the fact that technical knowledge is a requirement when it comes to managing dedicated and others among web hosting services. However, requirement of technical knowledge is different in managed and unmanaged hosting. The first option does not need you to be an expert in server management and its sections, as one team from your web-hosting provider will be there to manage your cloud or dedicated server. Although the full list may be quite long, main responsibilities of team include server configuration, maintenance, security, sufficient upgrades, firewall services, backup services etc. In other words, once you have purchased managed web server, you do not have to be concerned about managing the technical aspect of your server. So, when you want to manage your website, you can log into the control panel and do things as you do in shared web servers.

Nevertheless, unmanaged web hosting is quite opposite in this aspect! Things that come with an unmanaged dedicated are the physical server itself and initial installation procedure. This also means that you will have to do everything else except these. The list of tasks includes software upgrades, security, frequent maintenance, etc. Thus, an unmanaged dedicated needs you to be an expert in terms of server management, in its all aspects. So, we would say that you should go for managed hosting if you want to skip hassles of server management.

Security System

When it comes to the case of security of web server, managed dedicated grabs the first price, because the team behind the web host will be more than enough to keep your server and websites secure from almost every possible threat. But, unmanaged server cannot, even if you have hired an effective team for maintenance, guarantee that much security. So, when you want to be less concerned about security section of your web server, you should choose managed dedicated with no doubt.

What is Benefits of Managed Hosting:

Security:

Hosting providers have the tools and experience to monitor and handle your security issues properly: they filter spam, scan for viruses, run security audits, configure software firewalls, and provide OS updates.

Backups:

Lost data can be detrimental and expensive for a company. In many cases a natural disaster is to blame for a significant loss of data, but a hosting provider has procedures to deal with data loss and provide secure, backed up data after such a situation occurs.

Monitoring Server:

This is the process of constantly scanning the server for any problems or irregularities, and it’s crucial for your small business. System admins will ensure network availability for your clients by constant monitoring.

Managed Storage & Database:

System admins will save you money by managing your storage needs with the help of a managed services provider, so that the amount of space needed is managed properly and scaled properly. Managing of the database is more complicated, and it’s conducted by a database admin that can effectively design the best database to meet your company’s specific needs and requirements.

Pricing

Indeed, pricing is a significant factor while choosing between managed hosting and unmanaged hosting! As you may have guessed, managed web servers cost more than unmanaged web server, as such, servers offer assistance as well as support. However, if you do not have enough technical knowledge about web servers, purchasing an unmanaged web server means purchase of a team that is capable of maintaining the server in its optimum functional condition.

Conclusion

Whether you choose unmanaged and managed hosting, you don’t need to worry to spend a lot of money as we have affordable windows cloud dedicated server that we believe it will suits your requirement. Please visit cheap cloud dedicated server price on our site. Our cheap windows cloud dedicated server start from only $18.00/month. You can choose managed or unmanaged service.



Windows Server 2012 R2 Hosting with ASPHostPortal.com :: How to Reset Windows Server 2012 R2 Lost Admin Password Easily

clock August 6, 2014 06:28 by author Kenny

Windows Server 2012 R2 brings a host of new features that greatly enhance the functionality of the operating system. Many of these improvements expand on existing capabilities of Windows Server 2012.  The new product also benefits from having the capability of performing at a much higher level than previous servers and comes equipped with an integrated virtualization platform.

In this article I will tell you about how to reset Windows Server 2012 R2 lost admin password. The answer is not absolute. For example, if you have password reset disk or another administrator available, Windows server 2012 r2 lost admin password would be reset instantly.
Or if you have backup Windows system status with disk, such as Windows system restore disc, you could restore Windows server 2012 r2 to early system point.

Even though there are not anything available for recovering server 2012 r2 password, Windows system 2012 r2 installation disk and third-party recovery tool would help you too.

First, Windows system installation disk reset Windows server 2012 r2 admin password.

Preparation: a copy of Windows server 2012 r2 installation disk

The key step of resetting server 2012 r2 admin password with installation disk is to replace Utilman.exe.

  1. Boot off Windows disk and select the "Repair your computer" option from the lower left-hand corner.
  2. Get to the option to open the Command Prompt.
  3. Type the following commands to back up the utilman.exe file:
    MOVE C:WindowsSystem32Utilman.exe C:WindowsSystem32Utilman.exe.bak
  4. Copy cmd.exe and rename it Utilman.exe.
    COPY C:WindowsSystem32cmd.exe C:WindowsSystem32Utilman.exe

    Now you can go ahead and reboot your machine. When it's done booting up again and you are at the Logon screen click on the Ease of access icon.

    Now you have replaced Utilman.exe with cmd.exe.
  5. Command Prompt opens, type following commands:
    .net user administrator *

Once you press Enter, you will be asked to set a new password and then confirm it. When entering new one, don't worry if you can't see it, because it is invisible, however it has been remembered.
Once you're logged in again, don't forget to delete Utilman.exe and then rename Utilman.exe.bak back to plain old Utilman.exe.

Second, reset server 2012 r2 admin password with third-party Windows password genius.

Windows Password Genius has four versions available, standard, professional, and advanced and raid. And the raid version is special, because it works for raid server Windows domain or local admin password reset. The advanced is general version, working on both server and client computers.

So choose appropriate Windows password recovery version to burn a password reset disk and then recover Windows server administrator password.

Preparation: Windows Password Genius Advanced/Raid, available computer and bootable USB drive.

  1. Install Windows Password Genius Raid, and run it on available computer.
  2. Insert bootable USB drive into this available computer and choose USB, click "Begin burning" to create password reset disk with USB.
  3. Exit USB device after it is successfully burned with password reset disk.
  4. Plug USB into server 2012 r2 and boot server from USB.
  5. Recovery tool program runs, and then choose Windows system - Windows serve 2012 r2, and select user account - administrator.
  6. Click "Reset Password", the administrator would be set with new password "iSunshare@2012".
  7. At last, reboot server computer to finish Windows password reset. But remember to exit USB reset disk from server before your server computer boots from hard disk successfully.


Cheap YetAnotherForum.NET 1.9.6.2 Hosting :: Installing YetAnotherForum.NET 1.9.6.2 on Your Server

clock July 23, 2014 06:29 by author Ben

YetAnotherForum.NET (YAF) is a Open Source discussion forum or bulletin board system for web sites running ASP.NET with SQL Server as the back-end database. The source code is entirely written in C#, and is licensed with the GPL license. And now YetAnotherForum.NET (YAF) has release the new version YAF.NET 1.9.6.2

Here is the important features of YetAnotherForum.NET 1.9.6.2:

  • Added Admin Page to Import List of Banned Ip Adresses (You can find Huge list of Bot IP Lists here: StopForumSpam.com)
  • DNN YAF Whats New Menu List Item is now fully Templatable
  • Host Admins can control admin groups access to YAF event log by event type. They can set permissions to delete events by type too, i.e. readonly mode for each event.
  • Added New Host Admin Page for Host Admins to restrict simply admins to various admin pages individually.
  • Added New Notification Bar for System Messages (In the Host Settings you can choose Between Modal Dialog or Notification Bar for Messages, also the Display Duration can be defined there). Also added an option to show the alert dialog for messages on Mobile Devices.
  • Added new "Fancy" Theme
  • Added Keystroke For Quotes to the YAF BBCode Editor you can now use CTRL+Q for inserting and "[quote]"..."[/quote]"
  • Added Indicator to a Private Message if its an Reply
  • Added new BB Code Feature to the Editor for indent text
  • Added HoverCards to Username. If enabled it shows an Hover Card (Which shows some quick info about the user) when you hover an user name. This will also show an Hover Card on the Twitter & Facebook Profile Button.
  • Added Display Options for the Event Log, you can define Start and End Date and also Event Type
  • Added settings to control number of records in the event log.
  • Added Option to send PM to all Buddies of a User
  • Added DNN Option to Remove Tab Name/Title from the Current Page Title you can choose between "Dont Remove", "Always Remove", "Remove only if matches the Board Name". Default Value : "Always Remove"

This article will give you a step by step guide on how to install YetAnotherForum.NET on your server:

Make sure your server / Host has the following requirements:

  • Microsoft .NET Framework 3.5 SP1 (Use version 1.9.3 or earlier for .NET Framework 2.0) or the latest .NET Framework.
  • Microsoft SQL Server 2005 or above. SQL Server 2000 works, but requires removal of some SQL forum database optimizations.


1. Download YAF from http://www.yetanotherforum.net. Note that current version available is YAF 1.9.6.2 and my article is based on this version. For future versions the installation and Integration instructions may change.

2. Create a virtual directory in IIS pointing to D:\YAF-v1.9.6.2-FINAL-SRC\YetAnotherForum.NET. Above is the assumed path where you have downloaded YAF.

3. SQL Server database is required for installing the YAF. SO keep SQL Server installed on the machine. Then Create an empty SQL Server database for YAF named yafnet(say).

4. If Web.Config is not present in the forum root,copy one of the samples provided in the "webconfigs" folder into the root of the web application and rename it to web.config.

5. Setup a valid connection string in db.config as per the format provided by YAF.

6. Configure the SMTP settings in mail.config as per your hosting environment and as per the format provided by YAF.

7. Then try to open http://localhost/YetAnotherForum.NET/install/Default.aspx and install the forum as per instructions appearing on the installation wizard. It will create/update the forum database and create admin user. Note that all the passwords should have a special charector in it.

8. After the installation the URL will come something like http://localhost/yaf/default.aspx if the above page opens without any error that means your installation is complete.

9. Then you need to copy your installation folder to the root of your website.

10. Suppose you want the forum to appear on the Default.aspx Page, Then Merge the Default.aspx page from the forum with Default.aspx page from your website.Also you need the merge the web.config file from the forum to web.config file of existing website.

11. Now run the default.aspx page of the website and forum should appear on the page.


Best and Cheap YetAnotherForum.NET Web Hosting with ASPHostPortal.com


ASPHostPortal.com YetAnotherForum.NET optimised hosting infrastructure features independent email, web, database, DNS and control panel servers and a lightning fast servers ensuring your site loads super quick! Reason why you should choose us to host your YetAnotherForum.NET site:

  • Top of the line servers optimized for your YetAnotherForum.NET installation
  • 24/7/35 Technical support from YetAnotherForum.NET hosting experts
  • We provide full compatability with YetAnotherForum.NET hosting and all popular plug-in.
  • Free professional installation of YetAnotherForum.NET.
  • We provide 30 days money back guarantee

 



Windows WebSocket Hosting with ASPHostPortal.com :: Simple WebSocket Application

clock July 22, 2014 11:02 by author Kenny

In this article I will explain about Simple WebSocket Application. In order to a create a working application, you also need a server side implementation. It’s possible to use technologies like node.js, Java, .NET, Ruby, or C++ to create server side implementation. This section will show you how to create a simple application using WebSockets.

The sample application will allow the user to ask specific questions to server. The server side implementation is done using the Java jWebSocket framework on Windows 7. So, to get the environment set up follow these simple steps. I assume you have already installed the latest JDK (JDK 7)on your Windows 7 PC.

Step 1

Head over to jWebSocket Downloads and download the first zip which is marked as server.

Step 2

Unzip the archive, and place it somewhere in your C:. Then, create a new environment variable named JWEBSOCKET_HOME, which references the root of your jWebSocket installation. This is the path to the jWebSocket-1.0 folder. Add the following JARs to your class path:

JWEBSOCKET_HOME/libs/jWebSocketServer-1.0.jar
JWEBSOCKET_HOME/libs/jWebSocketServerAPI-1.0.jar
JWEBSOCKET_HOME/libs/jWebSocketCommon-1.0.jar

Step 3

Create a new Java Source file and name it SocketListener.java. Add the following code to this file.

import java.util.Date;
import java.text.SimpleDateFormat;
import org.jwebsocket.factory.JWebSocketFactory;
import org.jwebsocket.server.TokenServer;
import org.jwebsocket.kit.WebSocketServerEvent;
import org.jwebsocket.api.WebSocketServerListener;
import org.jwebsocket.api.WebSocketPacket;
import org.jwebsocket.config.JWebSocketConfig;
import org.jwebsocket.instance.JWebSocketInstance;
class JWebSocketListener implements WebSocketServerListener
{
  public void processOpened(WebSocketServerEvent event)
  {
    System.out.println("Connection Opened");
  }
  public void processPacket(WebSocketServerEvent event, WebSocketPacket packet)
  {
    switch(packet.getString())
    {
      case "1":        packet.setString("My Name is jWebSocketServer");
        break;
      case "2":        packet.setString("Windows 7 64 Bit");
        break;
      case "3":        SimpleDateFormat sdf=new SimpleDateFormat("hh:mm:ss");
        packet.setString(sdf.format(new Date()));
        break;
    }
    event.sendPacket(packet);
  }
  public void processClosed(WebSocketServerEvent event)
}
public class SocketListener
{
  public static void main(String[] args)
{
    JWebSocketFactory.printCopyrightToConsole();
    JWebSocketConfig.initForConsoleApp(new String[]{});
    JWebSocketFactory.start();
    TokenServer server = (TokenServer)JWebSocketFactory.getServer("ts0");
    if(server!=null) {      server.addListener(new JWebSocketListener());
    }
    while (JWebSocketInstance.getStatus() != JWebSocketInstance.SHUTTING_DOWN)
{
      try {
        Thread.sleep(250);
      }
      catch (InterruptedException e)
    }
  }
}

Explanation

The code implements the WebSocketServerListener interface. The interface declares the following three methods which should be implemented in our class, JWebSocketListener.

processOpened()
processPacket()
processClosed()

processOpened() is called once a connection is opened. An example use of this will be starting a thread that sends updates to client in regular intervals. Similarly, processClosed() is called when the connection closes so that you can perform any clean ups.

In our application, the major processing is done in processPacket(). This method is called whenever the browser sends a message to the server. It receives two objects, of types WebSocketServerEvent and WebSocketPacket. First, we use WebSocketPacket#getString() to read the message (which is a question asked by the client). Depending on the question the server sends an answer. The message to be sent is wrapped inside a WebSocketPacket using WebSocketPacket#setString(). Then, we call WebSocketServerEvent#sendPacket(), passing the packet as an argument. Next, we create a public class called SocketListener. This class starts a WebSocket implementation server and registers our custom listener to it.

Step 4

Compile SocketListener.java, and start your server using the command java SocketListener.

Step 5

Now that you have done the server side implementation, it’s time to create the client that will interact with the server. The following is our initial HTML markup:

<html>
  <head>
    <title>WebSocket Test</title>
    <style>      #response
{
        width: 200px;
        background: #F2F2F2;
        padding: 120px 0px 120px 0px;
        font-size:18px;
      }
    </style>
  </head>
  <body>
    <div align="center">
      Choose a question to ask:
      <select id="question" name="question" onchange="sendMessage(this.value);">
        <option value="1">What's Your Name</option>
        <option value="2">Which OS You Are Running On?</option>
        <option value="3">What Time Is It?</option>
      </select>
      <br/>
      <br/>
      <div id="response">
        My Name is jWebSocketServer
      </div>
    </div>
  </body>
</html>
Now, add the following JavaScript to the HTML:
<script type="text/javascript">
var connection = new WebSocket('ws://localhost:8787', 'json');
connection.onopen = function ()
{
  console.log('Connection Opened');};connection.onerror = function (error)
{
  console.log('WebSocket Error ' + error);};
connection.onmessage = function (e) {
  if(e.data.indexOf("subProtocol")==-1)    document.getElementById("response").innerHTML=e.data+"<br/>";};
function sendMessage(msg){  connection.send(msg);}
</script>

Explanation

We created an HTML file that allows users to choose questions from a drop down menu. When an onchange event fires, we take the value of the selected item and send that value to the server. The server then processes the request and sends back an answer to the browser. When the message from the server is received, the onmessage callback is executed, which shows the response in the response <div>. The line if(e.data.indexOf("subProtocol")==-1) is not mandatory. I have included it because initially when the connection is opened, the server sends a long string containing information to the browser. As we don’t want to show this string, I have included the above condition.



Cheap Web API 2.2 Hosting :: The Important Features on Web API 2.2

clock July 22, 2014 10:48 by author Ben

ASP.NET Web API 2.2 was released last week, and one of the key new features is the ability to extend and plug in your own custom logic into the attribute routing engine.

Commonly known as “attribute routing”, it’s actually officially called “direct routing”, because, as they are about to show here, it’s not necessary to use it with attributes at all, and you can plug in any route provider into it. The Web API 2.2 release is particularly noteworthy as it is the first Web API release with support for OData v4 with selected highly demanded features.

ASPHostPortal.com is Microsoft No #1 Recommended Windows and ASP.NET Spotlight Hosting Partner in United States. Microsoft presents this award to ASPHostPortal.com for the ability to support the latest Microsoft and ASP.NET technology, such as: WebMatrix, WebDeploy, Visual Studio 2012, .NET 4.5.2/ASP.NET 4.5.1, ASP.NET MVC 6.0/5.2, Silverlight 5 and Visual Studio Lightswitch. Click here for more information


Here is New features :

1. Protocol and format changes from V3 to V4.

2. OData attribute routing: This release allows you to define the routes in your controllers and actions using attributes.

3. Support for functions: This release allows you to define functions in your OData model and bind them to actions in your controller that implement them.

4. Model aliasing: This release allows to change the names of the types and properties in your OData model to be different than the ones in your CLR types.

5. Support for limiting allowed queries: This feature release the service to define limitations on the properties of the model that can be filtered, sorted, expanded or navigated across.

6. Support for ETags: This release allows to generate an @odata.etag annotation based on some properties of the entity that can be used in IfMatch and IfNoneMatch headers in following requests.

7. Support for Enums

8. Support for $format: Added support for $format, so clients are able to specify the desired format of the response in the URL.

The OData v4.0 protocol includes a lot of new features and many changes to existing ones that improve the protocol and the modeling capabilities for the services implementers, but at the same time, those changes make difficult to support multiple versions of the protocol in a single implementation.

For that reason, we have decided to create a new assembly to support the v4.0 version of the protocol while maintaining the current assembly for those people who want to implement services based on previous versions.

Here are the most important changes:

1. The package ID for the v4.0 is Microsoft.AspNet.OData.

2. The assembly name and the root namespace are now System.Web.OData instead of System.Web.Http.OData.

 3. All the extension methods have been moved to System.Web.OData.Extensions.

4. We have removed all the extension methods that used to exist for HttpRequestMessage like GetODataPath or GetEdmModel and we have added a single extension method, ODataProperties that returns an object containing the common OData properties that were accessible by the old extension methods, like the IEdmModel of the service or the ODataPath of the request.

5. MapODataRoute has been changed to MapODataServiceRoute.

6. QueryableAttribute has been changed to EnableQueryAttribute.


Recommended extras for your Web API 2.2 hosting website:

Feature Rich Services
Offering feature rich, on-demand reliable and secure web hosting services is why our customers stay here. We are constantly working to improve our services and the product line we offer. We firmly believe in a long lasting customer relationship. We want our customers to stay and grow their business with us.

Cost Effective Pricing
We provide our services at the lowest cost possible by utilizing our in house architecture coupled with carefully chosen software. We strive to keep our operating costs low so we can deliver quality web hosting services at very reasonable prices.

Money Back Guarantee
We are absolutely sure that you will be satisfied with our service that we offer our unconditional money back guarantee. Feel free to take a ride with us without any risk!



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions


Author Link


Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in