Results 1 to 2 of 2

Thread: check SQL server

  1. Mar 7th, 2001, 11:14 PM #1
    nelsonip
    nelsonip is offline

    Thread Starter
    New Member
    Join Date
    Dec 2000
    Posts
    9
    I have a funtion to insert data into a SQL Server.
    The problem is that if the SQL Server is not activated, it will hold for about 10 seconds until time out.
    Is there any method in VB to check wether SQL server is available to connect before I do the insert ?
    Reply With Quote Reply With Quote
  2. Mar 8th, 2001, 09:27 AM #2
    iandarbyshire
    iandarbyshire is offline
    Member
    Join Date
    Oct 2000
    Posts
    49
    If you are using ADO you can trap errors around the connection object and you can also change the time out parameters to speed the response up.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width