Connecting to MSSQL Using Classic ASP: Compatibility Issues and Solutions

I was recently notified that my site was taking up too many resources and that I had to upgrade my account. I agreed to move from a PersonalClass to BusinessClass plan and my new account was quickly set up by Arvixe, along with the content and the vast majority of my configurations.

One of my planned changes was to modify the connection string I was using. I was directed to this article with 2 options:

  1. “Provider=SQLOLEDB;Data Source=myServerAddress;UID=myUsername; PWD=myPassword; database=myDataBase;”
  2. “Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;” Learn More
Tags: , , , , , , , , | Posted under MSSQL, Programming/Coding, Using Arvixe | 1 Comment

Changing Collation for SQL Server 2008 R2 Express

This article builds on the previous post and is part of a series to setup local and remote working environments for MojoPortal.

Background

If you have differing collations on your local and remote databases, you are likely at some stage to see collation errors. Learn More

Tags: , , , , , , , , , , | Posted under MojoPortal | Leave a comment

How to Properly Make a Redirect in Elgg

On a previous post I showed you a quick way to redirect your site. However this only works if your site was properly installed, like described in this post. In this article I will give you a step by step guide on how to properly redirect your elgg site from mydomain.com to www.mydomain.com. First, sign into elgg as an Admin and follow these steps:

Learn More

Tags: , , , , , | Posted under Elgg | Leave a comment