Connecting to MSSQL Using Classic ASP: Compatibility Issues and Solutions

Last Updated on Saturday, 2 July 2011 02:56 Written by Yiannis Androulakis Friday, 1 July 2011 12:34

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;”

Using Greek Collation on ASP.NET and MSSQL

Last Updated on Wednesday, 3 November 2010 12:43 Written by Yiannis Androulakis Monday, 1 November 2010 02:24

I recently transfered my website to ARVIXE, which includes a forum powered by an MSSQL database.

The forum is in the Greek language and thus, the posts contained latin and non-latin (Greek) characters. While the forum displayed nicely on my former web hosting company, the Greek text was garbled on ARVIXE. This was a major problem since the forum constituted some 75% of the total traffic of the site (around 700K pageviews/month).