Re: Database Connection Technique

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

John,

In addition to the others.

Be aware that in this newsgroup, if it is not told, SQL server is the base
of the discussion.

A simple fact by instance by an Access database is that if you leave the
connection completly open. The access database can not be replaced in that
time and this can be a reason to keep in Access the connection open.

Cor


"Mr. John A. Jackson" <Research> schreef in bericht
news:%239CPAfZuFHA.2880@xxxxxxxxxxxxxxxxxxxxxxx
> Good evening,
>
> In VB 6.0, Delphi & VC++, the basic database connection technique is to
> connect at startup, disconnect at shutdown. In ASP.NET (regardless of
> language), the technique is to connect on demand.
>
> When developing client/server applications in .NET, which database
> connection technique have you found to give you the best performance? Is
> ADO.NET designed to perform best using the on demand technique, even in
> client/server applications?
>
> Thanks.
>


.

Relevant Pages

  • Re: Database Connection Technique
    ... The connection pool handles the physical connections in the background so ... the technique is to connect on demand. ... > When developing client/server applications in .NET, ... > ADO.NET designed to perform best using the on demand technique, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Connection Technique
    ... ADO.NET uses connection pooling under the hood. ... the technique is to connect on demand. ... > When developing client/server applications in .NET, which database ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How to use access query computed fields in Word mailmerge
    ... Once you have gone through the connection process once, ... To make a DDE connection in code from Word 2000/2002 I think you will need ... My access databases have lots of these computed query ... >>> an access database with any data in it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to stop source prompt in mail merge from access
    ... Are you calling OpenDataSource in your Access code? ... connection from the Word mail merge main document because Word will try to ... > The mail merge is being called from the Access database via a Visual Basic ...
    (microsoft.public.word.mailmerge.fields)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)