September 19, 2006 at 11:19 am
We have an application that uses a three tier model, with DCOM for the network to the client app, and a middle tier VB6 DataManager the deals with the database using MS ADO. We have a number of stable deployments using SQL Server 2000/3, running on Server 2003, and many using Access, and ADO has worked very well for us.
We have a new implementation running on SQL Server 2005 database (quite small 500 MB or so), and this it seems is giving us stability problems. Every so often (couple of hours) the ADO calls seems to simply not return from SQL Server 2005, and the DataManager just hangs.
We are busy methodically fault finding the cause, but wondered if anyone had experience with SQL Server 2005 and ADO with similar experience?
September 22, 2006 at 8:18 am
Our fault finding has confirmed this "weird" behavior. We have constructed an Access database, with the same table structure, as the SQL Server 2005 DB.(we use Access for prototyping and development). By changing the connection string used in the ADO connection, we are able to swap backwards and forwards between Access and SQLServer 2005. We confirm that the Access database runs fine, and the SQL Server 2005 fails after a couple of hours. So something is fishy is the SQL Server 2005 setup.
Our application is reasonable mature (a couple of years), and runs reliably on a number of SQL Server 2000 sites. So it seems the problem is in the 2005 set up somewhere.
Does there need to be a differnece in the connection string for 2005 versus 2000?
October 23, 2006 at 3:00 am
Bryan,
Only just joined this forum and found this post. I am also experiencing similar problems with our SQLServer 2005 installation.
Our application is an ASP site which has worked fine on SQLServer 2000 for many years. However, since proting it to SQL 2005, it is causing hanging problems. And worse still, we are unable to restart the service as the installation "doesn't respond to the Stop request...". The only way we can effectively get the site back is to reboot the server.
I just wondered whether you had made any headway with this issue that you may pass on any info?
Cheers,
Woody.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply