SQL.isAlive
-----------

Returns the database server connection status for a particular connection object.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.isAlive"; Connection ) 

**MBS**( **"SQL.isAlive";** /\* Returns the database server connection status for a particular connection object. \*/  
**$Connection**) /\* The connection reference number gained with [SQL.NewConnection](SQLNewConnection.md). \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Connection | The connection reference number gained with [SQL.NewConnection](SQLNewConnection.md). | $Connection |

### Result

Returns 1 if the database server is active and accessible; otherwise 0.

### Description

Returns the database server connection status for a particular connection object.   
  
This method uses the safe query execution for most supported DBMS-es. The query uses the well known database table or procedure (mysql\_ping is used for MySQL). If the query fails the method returns false.  
### Examples

Check alive status:

 Set Variable \[$r ; Value:MBS ( "SQL.isAlive"; $Connection )\]  
### See also

- [SQL.NewConnection](SQLNewConnection.md)

### Blog Entries

- [Connect to an external database server in FileMaker](https://www.mbsplugins.de/archive/2022-03-11/Connect_to_an_external_databas/monkeybreadsoftware_blog_filemaker)

This function is free to use.

Created 18th August 2014 , last changed 17th May 2016

  
[SQL.SetParamsWithJSON](SQLSetParamsWithJSON.md) - [SQL.isConnected](SQLisConnected.md)

[HTML Version](SQLisAlive.shtml)