Results 1 to 2 of 2

Thread: Preventing Application Stall While Waiting for SQL Connection

  1. #1

    Thread Starter
    Hyperactive Member razzaj's Avatar
    Join Date
    Oct 1999
    Location
    jounieh
    Posts
    261
    I have a VB Program that is interfacing an SQL Server DataBase ...

    The Problem is that when I try To connect and the application is waiting for the connection Object to be created ... I cannot do anything .. as if I am in an infinit loop, Until the connection is created ...
    I want to aavaoid that .. and I have read somewhere that it can be done by calling some API functions ... but I could not find where anymore . ...
    - regards -
    - razzaj -

  2. #2
    Addicted Member PsudoLogical's Avatar
    Join Date
    Dec 2000
    Location
    Upstate N.Y.
    Posts
    144
    I believe that if you set the connection up for asynchronous processing that your code will execute while the connection is pending.... use of the .stillconnecting property will allow you to monitor the connection process.

    For more details... check out the msdn.microsoft.com library for information on asynchronous processing

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width