If you are getting errors connecting to the database from your code.
If your ODBC connection string looks somthing like this:
sConn = "driver={SQL Server};server=MYDATABASESERVER;uid=MyUserName;pwd=MyPassword;database=MyDataBase"
Try to changing it to the SQL Native Client for SQL 2008
sConn = "driver={SQL Native Client};server=MYDATABASESERVER;uid=MyUserName;pwd=MyPassword;database=MyDataBase"