> I am programing a server application with VC6 and using ADO to connect SQL
> Server2000.My program keep reading data from SQL Server 2000 and it runs
> fine, but after 3 days, my program catch a exception. The exception is
> connect time out, I think my program has lost connection with SQL Server
2000.
> My Question is How can i keep an ADO connection object alive after it
> connected SQL Server 2000 successfully.
> Must I using a thread to read adoState and judge to reconnect?
No. It is not reliable. Do a Connection Execute
SELECT 1
and if you get a COM exception, close and re-open.
Re: ASP.NET 2.0 - a newbie question ... the exception can be identified using the exception stack trace below. ... established connection failed because connected host has failed to ... connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& ...Microsoft SQL Server?... (microsoft.public.dotnet.framework.aspnet)
Re: Sql Server 2000 slow ... If I close the connection (moving the Open/Close ...ADO) and the dll gives twice the performance. ... > Are there any known performance issues with .NET accessing Sql Server... (microsoft.public.dotnet.framework.performance)
Driver corrupts prepared statements in pool. ... This test case demonstrates a bug in the Microsoft SQL Server 2005 JDBC ... cause an exception the next time it is used. ... Microsoft SQL Server 2005 JDBC driver 1.0.809.102 ... // A connection will NOT work properly until it has been ... (microsoft.public.sqlserver.jdbcdriver)
Re: Cross Transactions between ADO & ADO.Net ... MARS session pool limited to one connection?).... > There is one thing that might help here, if you're using SQL Server.... We even call ADO code from ... >> the DTC cordinator from COM+ to handle the transactions between ADO.Net ... (microsoft.public.dotnet.framework.adonet)
Re: absolute newbie question - connecting to SQL server in ADO.net ... How do I get the above connection working?... > experience of ADO prior to this was in Access 2000. ... Have I wasted my money buying VB.net standard because it can't connect to ... > an SQL server 2000 server? ... (microsoft.public.dotnet.framework.adonet)
