April 9, 2002 at 5:20 pm
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
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
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