CODEWITHSUNDEEP
.netdatabaseconnectionconnection-string
Jorrit Reedijk
Jorrit Reedijk

Reputation: 608

Fast database access test from .NET

What would be a very fast way to determine if your connectionstring lets you connect to a database?

Normally a connection attempt keeps the user waiting a long time before notifying the attempt was futile anyway.

Upvotes: 5

Views: 1190

Answers (2)

GateKiller
GateKiller

Reputation: 75869

You haven't mentioned what database you are connecting to, however. In SQL Server 2005, from .NET, you can specify a connection timeout in your connection string like so:

server=<server>;database=<database>;uid=<user>;password=<password>;Connect Timeout=3

This will try to connect to the server and if it doesn't do so in three seconds, it will throw a timeout error.

Upvotes: 11

Keith
Keith

Reputation: 155692

Shorten the timeout on the connection string and execute something trivial.

The wait should be about the same as the timeout.

You would still need a second or two though.

Upvotes: 2

Related Questions