Re: Best way to use a sigle TADOconnection with several threads



On Thu, 24 May 2007 11:27:04 +0300, yannis <none@xxxxxxxxxx> wrote:

I do not think you can use a single connection from multiple threads.
Try to use a connection pool to use a fixed number of active
connections.

I have several applications that connect to a server/database with one
connection only. Most of them use threads through the single
connection.


.



Relevant Pages

  • RE: Connection pooling
    ... Connection Pooling with SQL Server 2000 Analysis Services ... the Microsoft XML for Analysis Provider to develop scalable client and Web ... applications for Microsoft SQL Server 2000 Analysis Services. ... Balancing and Shrinking the Connection Pool ...
    (microsoft.public.sqlserver.programming)
  • Re: Best connection management
    ... Aren't you in effect saying that the vast majority of Windows Forms ... or server-side cursors where I didn't need to use disconnected data ... applications to support more users more quickly with less hardware. ... that require a persistent connection make sense. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Screen Update via Separate App
    ... Use a TCP/IP socket. ... When a connection request comes in on that port, ... communications link between the two applications. ...
    (microsoft.public.access.forms)
  • Re: Dedicated hard drive for my video files
    ... Automatic configuration Hot Plug and Play live connection/disconnection ... daisy-chains between peripherals and peer to peer computers and ... Guaranteed bandwidth assignments for real-time applications and co-existing ... same single network connection, provides a truly universal connection for ...
    (microsoft.public.windowsxp.moviemaker)
  • Re: IT WORKED -VPN
    ... To use applications, you will probably need a remote control program such as the one ... Browsing over a VPN ... Once the connection was established it showed ...
    (microsoft.public.win2000.networking)