Re: detecting that a SQL db is running

2006-12-02 Thread bill ramsay
On Sat, 02 Dec 2006 07:39:51 GMT, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: >On Sat, 02 Dec 2006 09:02:43 +1300, bill ramsay <[EMAIL PROTECTED]> >declaimed the following in comp.lang.python: > >> Dennis >> >> none of this matters, all i am trying to find out is whether or not >> the local MSD

Re: detecting that a SQL db is running

2006-12-01 Thread bill ramsay
thank you paul, much appreciated -- http://mail.python.org/mailman/listinfo/python-list

Re: detecting that a SQL db is running

2006-12-01 Thread Josh Bloom
I think the main point is that your Python code should be written in such a way that when you attempt to connect to your local MSDE it will timeout correctly instead of hanging. Do you have a loop somewhere that just keeps retrying the connection instead of giving up at some point? Here are a co

Re: detecting that a SQL db is running

2006-12-01 Thread Paul McNett
bill ramsay wrote: > none of this matters, all i am trying to find out is whether or not > the local MSDE is actually running. If it is a local MSDE then you may be able to rely on the connection being refused if the server isn't running. #-- begin import socket host = "127.0.0.1" port = 1433

Re: detecting that a SQL db is running

2006-12-01 Thread bill ramsay
Dennis none of this matters, all i am trying to find out is whether or not the local MSDE is actually running. I put all the other bits in there to try and put some background to it. kind regards bill -- http://mail.python.org/mailman/listinfo/python-list

RE: detecting that a SQL db is running

2006-12-01 Thread Tim Golden
[EMAIL PROTECTED] | Sorry if i did not make myself clear. let me try again. | | I can detect when the db is up and not responding, however, | if the DB does not start at all, my local application hangs. I need to find a | way to determine if the DB has started, that's all. Maybe (and only

Re: detecting that a SQL db is running

2006-11-30 Thread triode
Sorry if i did not make myself clear. let me try again. 1. I have a series of servers running windows server 2003. 2 on each server there is an application running that communicates with remote devices using email. 3. this application is made up from a series of modules that also extract data fr

detecting that a SQL db is running

2006-11-30 Thread bill ramsay
Hi I wonder if anyone can help me with a problem that I have with MSDE SQL db. [I am changing to SQL server soon]. I have an app that runs on a server that communicates with remote devices using email, this and other similar servers then sends XML/SOAP messages to a master application. I am in