<div>
Also regarding to security it's better to always close the connection. The time that it take to open and close doesn't justify to leave it open.
</div>


Also regarding to security it's better to always close the connection. The time that it take to open and close doesn't justify to leave it open.

<div>
That isn't necesaarrily true....connections will time out if you have them in use and they are not able to get data from the db...otherwise they will wait for the next command to execute.<br />
<br />
Tim
</div>


That isn't necesaarrily true....connections will time out if you have them in use and they are not able to get data from the db...otherwise they will wait for the next command to execute.

Tim

<div>
Tim, that is the command timeout. Unused connections time out, otherwise all database servers would have to be restarted regularly to keep working.
</div>


Tim, that is the command timeout. Unused connections time out, otherwise all database servers would have to be restarted regularly to keep working.

<div>
Thats great thanks guys...Ive split the points<br />
<br />
Cheers<br />
Mark
</div>


Thats great thanks guys...Ive split the points

Cheers
Mark

<div>
<div class="content wysiwyg-content">
Hi there<br />
<br />
Im developing an app in vb .net that uses a SQL database. &nbsp;My question is, is it best to publicly declare and keep open an SQL connection, or best to open and close the connection each time needed?<br />
<br />
Users of my app could potentially keep the app open for days at a time (yes, they're not very computer savvy).<br />
<br />
So, what do you think is best option?<br />
<br />
Hope my question isnt too vague...appreicate your help<br />
<br />
Cheers<br />
Mark
</div>
</div>


Hi there

Im developing an app in vb .net that uses a SQL database.  My question is, is it best to publicly declare and keep open an SQL connection, or best to open and close the connection each time needed?

Users of my app could potentially keep the app open for days at a time (yes, they're not very computer savvy).

So, what do you think is best option?

Hope my question isnt too vague...appreicate your help

Cheers
Mark

Best Practice - Keep SQL connection open, or open new each time?

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.