sqlconnection::open()

Eytukan

Why SQL "blocks" when it cannot connect to a server? I would want it to return immediately on failure. Connection-timeout attribute looks like useless. I gave it as 5 seconds, but it continues to block for an eternity. Any help?

He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus

Vimalsoft Pty Ltd

Please Explain in Detail what is your Problem

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

Eytukan

I thought I explained enough. Anyway here I go: 1. There's an SQL server waiting for you to connect. It's address it 123.134.1.2. 2. Now your application connects, uses DB, finally closes connection. Fine. 3. Now server shuts down, restarts. It's IP is 123.134.2.3 (changed) 4. Your application tries to connect to the old address 123.134.1.2, which doesn't exist. Waits, Waits, Waits, Waits, Waits, Waits, Waits, Waits, Waits, 5. Throws a DB exception (May be wrong server/network error) I want to remove

Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,
Waits,

and want it to throw the error immediately.

He never answers anyone who replies to him. I've taken to calling him a retard, which is not fair to retards everywhere.-Christian Graus

Vimalsoft Pty Ltd

Why do you use an IP ? Because it changes, why dont you use its name ?

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswa@its.co.za www.ITS.co.za

srinivasa rao dutta

I think even using DB name is not a proper solution. What will happen if there is some error in DB Name? (http://www.improve.dk/blog/2008/03/10/controlling-sqlconnection-timeouts[^])This URL gives some good solution for this problem.