we have a windows app that makes a connection & keeps it, or at least it
used to on sql 2k. We upgraded the server this weekend, and now the app
loses connection after a short time. The app of course is not expecting
this.
What can we do? This is a serious problem for our users.
Re: SQL Server Dual Processors INSERTS take long time ... Just because a server... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP... > for other parts of the app, that need to be done in real time. ... (microsoft.public.sqlserver.server)
Re: lost connection to sql server` ... Well it doesn't seem to be SQL.... I checked the sql processes from the server machine... So I'm thinking my app is misbehaving ... Using TAdoConnection with connection string built in code. ... (borland.public.delphi.database.ado)
Re: Deployment + Vista ... I'm talking about the user being able to edit the server connection setting... MSI will allow you to edit the app directory,... function in order to put together the connection string something like: ... (microsoft.public.dotnet.framework.adonet)
Re: Digging in to trace files ... > Ed you are probably aware that even though the server is running MTS... > you can create a dedicated connection when you need to correct? ... However, the app uses ... to shared server by requiring a high number of concurrent sessions ALSO ... (comp.databases.oracle.server)
Re: version & instances ...SQL 2000 SP3a for Antivirus app... that same server, to avoid breaking any of those apps. ...MSDE has a limited database size ... (microsoft.public.sqlserver.msde)
