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