connection timeout

Question

Hello guys,
i have developed two applications now, one is a windows the other web, and one similarity is that they both retireve information from a SQL database on startup, i dont know if its cos of my system config, and since its SQL express, but for most of the time that i start my apps, they timeout in connection to the database, its when i close and open the page that it finally connects,please why is this, cos i dont know if i would experience same problem if i upload my web app to a host server.
also i have tried to catch the error and re connect to the database, but it still timesout, is there anyway out. thanks

Answer 1

Hi!

Use SQL Profiler to diagnose where the delay is occurring: in the connection or in the stored procedure call.

---

Lucian Baciu, http://studentclub.ro/lucians_weblog

Answer 2

i used my debuggin tool and found out that the exception was from the connection.

Answer 3

I think your problem is similar to this one: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/thread/d21d5472-fe7e-41d4-aaee-b54090d7d66f/
You have an answer on that thread.

---

Lucian Baciu, http://studentclub.ro/lucians_weblog