Creating a Custom MojoPortal Solution: Part 1, Getting Started

Last Updated on Sunday, 10 July 2011 11:49 Written by Carole Bennett Tuesday, 28 June 2011 09:28

Hello! I’m Carole Bennett, one of the MojoPortal Community Liasons for Arvixe.  Ian McIntosh has been doing a great job of showing you how to get an “out of the box” MojoPortal installation configured, so that you can explore all the great built-in features it has to offer.  Since he’s working that area, I’m going to start by going over how to set up a custom MojoPortal solution, suitable for custom development.

In today’s post, we’ll cover downloading source code, setting up a Visual Studio project environment, a MSSQL database, and how to set up the publish profile that will generate the actual website you’ll install on a live server.

Upgrade/Upload a Microsoft Access Database to SQL Database Using DTS

Last Updated on Sunday, 30 January 2011 02:36 Written by Naveed Ashraf Thursday, 13 January 2011 03:26

The following article will give you steps to convert your existing Microsoft Access database to a SQL Server database using components of Microsoft SQL Server Management (available at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en). You will need to have a copy installed on your local computer.

Using the MSDN Clubsite with VS2010 and publishing it to Arvixe shared servers

Last Updated on Wednesday, 23 March 2011 11:20 Written by Ben Salisbury Monday, 3 January 2011 11:10

I recently decided to try the MSDN Clubsite with VS2010. The Clubsite can be downloaded HERE.

I chose to work with the starter kit due to its great prebuilt calendar feature. After following the directions HERE I was able to get the clubsite to work in VS2010. If you do not have a copy of 2008 you can still use it, it gives an error “Error HRESULT E_FAIL has been returned from a call to a COM component.” But it does not appear to actually affect the functionality.

Testing it on my local machine went flawlessly; it was not until I tried to upload the site to Arvixe that I realized there was an issue.

Upon going to the test site I was confronted with “Failed to generate a user instance of SQL Server due to failure in retrieving the user’s local application data path. Please make sure the user has a local user profile on the computer. The connection will be
closed.”

Online, there are many comments on how to fix this problem ranging from altering IIS permissions to manually adding the users to the default ASPNET database. Which in many cases works great, but it is not allowed with many shared hosting providers due to security issues

Here is my Step by Step to get the MSDN Clubsite to work on a shared host using Visual Studio 2010.

How to Set Up Forms Authentication for Your ASP.NET Web Site

Last Updated on Friday, 16 December 2011 02:11 Written by Craig Rorrer Friday, 31 December 2010 08:43

This article assumes you have developed an ASP.NET application that uses Forms Authentication that you wish to deploy on Arvixe. The process is quite simple and you will use tools that are available from the .NET framework and the Arvixe DotNetPanel.

1. Log in to your DotNetPanel.
2. From the menu, select Databases → SQL Server 2008.
3. Click the Create User button.
4. Enter a user name and password and click Save. In this demonstration, the user name is dotnetuser and the password is dotnetuserpass.
5. Click the Create Database button.
6. Enter a database name and grant access to the user you created above and click Save. In this demonstration the database is called DotNetAuthentication.

Using EMS SQL Server Manager to manage your Arvixe databases

Last Updated on Saturday, 11 December 2010 07:03 Written by Rick Hubka Saturday, 11 December 2010 06:54

If you CRUD your SQL Server database, this may interest you.

BTW,  CRUD stands for Create / Read / Update / Delete

What I really mean is: For those who need full access to their database to view and edit data, tables, views, stored procedures, export data, export database objects, import data and more, There are database tools available that allow you to access your remote SQL Server databases on your Arvixe hosting.  As a developer of Custom mojoPortal modules, I use tools like this daily and the tool I use most is EMS SQL Server Manager which available here.  I also use it to manage all the local SQL Server databases on my PC, laptop and the company Network Servers.

EMS have commercial and non-commercial licenses available.  For personal home use I have a non-commercial license which has all the same features as the commercial product.  More on pricing here.  There is also a Lite version which is free and somewhat restricted, but maybe that’s all you need.  Compare Full and Lite versions here.

After installing EMS SQL Manager it can’t do anything much for you until you register a local or remote Host and then you must register databases for that Host.  Lets register a  Host account to your Arvixe server.  My Arvixe server name is  violet.arvixe.com.  Check your initial Arvixe emails for one titled “Hosting  Account Information”.  Just a few lines from the top it says “Server Name: “.  That’s the name you use.

Let’s do that.  From the top database menu select “Register Host”.