Checking for an internet connectio

[Bob Sneidar]

Maybe have a means to change the domain in an Internet Setup card? I have a database setup card in all of my database enabled apps which attempts a connection which the user was initially prompted to set up. I set a global called connected based on the results of the attempt. I check the global before allowing the user to proceed. The ping routine is a really good addition, because SQL connections have a pretty long timeout sometimes. I will add this function to my connection check as a precursor to connecting to SQL. 

Bob


On Apr 28, 2012, at 3:40 PM, Dar Scott wrote:

> Hi, Peter,
> 
> I like Phil's solution, but it does answer a slightly different question from you said you want to ask.  I think it is a better question.  It answers not only if there is an Internet connection but  also whether your update server is online and reachable.  That might be more of the question you wanted your script to ask.  It does not say whether there are ftp/http services available on your download server.  
> 
> You might want to check with a quick ping by hand to make sure icmp services are available on you server (which they are likely to be).  
> 
> Dar
> 
> 
> On Apr 28, 2012, at 2:24 PM, Peter Haworth wrote:
> 
>> Great, thanks a lot Phil, I'll give that a whirl.
>> Pete
>> lcSQL Software <http://www.lcsql.com>
>> 
>> 
>> 
>> On Sat, Apr 28, 2012 at 12:30 PM, Phil Davis <revdev at pdslabs.net> wrote:
>> 
>>> Hi Peter,
>>> 
>>> I use "ping" to see if a given server is available. There are fewer bad
>>> things that can happen using this approach than trying to get a URL. The
>>> following code came from a recent project (slightly modified to protect the
>>> innocent) - watch line wraps:
>>> 
>>> 
>>> on mouseUp
>>> answer "Connection status =" && app_connectionStatus("google.**com<http://google.com>
>>> ")
>>> end mouseUp
>>> 
>>> 
>>> 
>>> function app_connectionStatus pTargetDomain
>>> 
>>>  -- attempt to ping the ctrainweb.com server
>>>  switch (the platform)
>>>      case "MacOS"
>>>          put shell("ping -c 1 -t 5" && pTargetDomain) into tShellOutput
>>>          put the result into tResult
>>>          break
>>>      case "Win32" -- PD 20100411
>>>          set the hideConsoleWindows to true
>>>          put shell("ping -n 1 -w 5" && pTargetDomain) into tShellOutput
>>>          put the result into tResult
>>>          break
>>>      default -- all other OSes
>>>          answer "This app cannot run on the" && the platform &&
>>> "platform."
>>>          put param(0) & colon && the platform && "platform not
>>> supported" into tResult
>>>          break
>>>  end switch
>>> 
>>>  -- check for connection failure
>>>  if tResult <> empty
>>>  then return false -- failed
>>>  else -- connected, but how well?
>>>      set the itemDel to comma
>>>      if the platform = "Win32"
>>>      then
>>>          get tShellOutput
>>>          filter it with "*(0% loss)*"
>>>      else -- Mac
>>>          repeat for each item tFilter in "* 0% packet loss*,* 0.0%
>>> packet loss*" -- for different OS versons
>>>              get tShellOutput
>>>              filter it with tFilter
>>>              if it <> empty then exit repeat
>>>          end repeat
>>>      end if
>>>      return (it <> empty)
>>>  end if
>>> end app_connectionStatus
>>> 
>>> 
>>> HTH
>>> Phil Davis
>>> 
>>> 
>>> 
>>> 
>>> On 4/28/12 12:12 PM, Peter Haworth wrote:
>>> 
>>>> Just put together a procedure for checking for software updates from my
>>>> SQLiteAdmin program.  All works great but I'm wondering the best way to
>>>> check if there is an internet connection.  I tried this out by
>>>> disconnecting my computer from my wireless router and I got an"invalid
>>>> host
>>>> address" message from libURLErrorData as soon as I called
>>>> libURLDownloadToFile.
>>>> 
>>>> I can easily check for that of course but it sounds like that message
>>>> could
>>>> come back in other circumstances so wondering if there's some other way to
>>>> check for an internet connection before attempting a download.
>>>> 
>>>> Pete
>>>> lcSQL Software<http://www.lcsql.com>
>>>> ______________________________**_________________
>>>> use-livecode mailing list
>>>> use-livecode at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your
>>>> subscription preferences:
>>>> http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode>
>>>> 
>>>> 
>>> --
>>> Phil Davis
>>> 
>>> 
>>> ______________________________**_________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your
>>> subscription preferences:
>>> http://lists.runrev.com/**mailman/listinfo/use-livecode<http://lists.runrev.com/mailman/listinfo/use-livecode>
>>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode