Classic ASP / SQL Server sites intermittent connectivity

[mumidimar]

We have a Windows 2003 server and we have recently started to upgrade some really old classic ASP sites that were using MS access to now use SQL Server 2005. But these sites are getting random SQL Server timeout's, which causes all of the classic ASP / SQL Server sites to go down. Whilst these sites are down, the associated CMS for these sites, (which is built in ASP.NET, but connecting to the same SQL Server database) are fine. Also Classic ASP / MS Access sites on the same server are fine and event the site.It seems the only to get these site back online is to restart IIS or restart the individual application pools.There is nothing in the windows logs,any ideas what could be causing this?Soem more info...The sites haven't moved server, we have only changed the db from MS Access to SQL Server...we connect to the SQL Server db like this...\[code\]connStr = "Provider=SQLOLEDB.1;Password=xxxx;Persist Security Info=True;User ID=hallgarthmanorUser;Initial Catalog=xxxx;Data Source=xxxx"\[/code\]then most code is like this...\[code\]Set dbMain = Server.CreateObject("ADODB.Connection")dbMain.Open connStrSet rsPage = Server.CreateObject("ADODB.Recordset")rsPage.Open "SELECT * FROM Pages WHERE PageID = " & PageID,dbMain,0,1....rsPage.closeset rsPage= nothing\[/code\]Thankskb