Connects to a Birdscan SQL database, be it a Microsoft SQL or postgreSQL database3
Usage
dbConnectBirdscanSQL(
dbDriverChar = "SQL Server",
dbServer = NULL,
dbName = NULL,
dbUser = NULL,
dbPwd = NULL,
dbPort = 5432
)Arguments
- dbDriverChar
'SQL Server' The name of the driver. Should be either 'SQL Server' or 'PostgreSQL'.
- dbServer
NULL The name of the SQL Server. For a 'PostgreSQL' this can be a the host address or the internal IP.
- dbName
NULL The name of the SQL database
- dbUser
NULL The username of the SQL server
- dbPwd
NULL The password for the user name
- dbPort
5432 The dbPort parameter specifies the TCP/IP port number on which the PostgreSQL server is listening for connections (default is 5432)
See also
Other read SQL database functions:
QUERY(),
extractDbData(),
getBatClassification(),
getCollectionTable(),
getEchoFeatures(),
getEchoValidationTable(),
getProtocolTable(),
getRadarTable(),
getRfClassification(),
getSiteTable(),
getTimeBinsTable(),
getVisibilityTable()
Examples
if (FALSE) { # \dontrun{
# Set server and database settings
# ==========================================================================
# Using and Microsoft SQL database
# ========================================================================
dbServer = "MACHINE\\SERVERNAME" # Set the name of your SQL server
dbName = "db_Name" # Set the name of your database
dbDriverChar = "SQL Server" # Set to "SQL Server"
# Using a PostgreSQL
# ========================================================================
dbServer = "cloud.birdradar.com" # Set the name or IP of your postgreSQL
dbName = "db_Name" # Set the name of your database
dbDriverChar = "PostgreSQL" # Set to "PostgreSQL"
# Open the connection with the database
# ==========================================================================
dbConnection = dbConnectBirdscanSQL(
dbDriverChar = dbDriverChar,
dbServer = dbServer,
dbName = dbName,
)
} # }