Post reply

Testing SQL Server Activity Status from Access

  • April 9, 2002 at 5:20 pm

    #158223

    I have an Access front end which appends records to SQL via ADO and an sp. I need to check that SQL server is running before trying to call the append procedure which runs the sp. Waiting 30 seconds for the connection timeout to cause a trappable error is not fast enough, as I'm capturing barcode scans in quick succession. How do I pick up if the server is Paused or Not running? (from Access) Any suggested solutions would be appreciated.

  • April 9, 2002 at 5:35 pm

    #426914

    If you are setting up the connection via code the you can do a state check. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprostate.asp for more details.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 12, 2002 at 11:30 am

    #427143

    Many thanks - I'll try the sample code from the Microsoft site. Fingers crossed...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply