New Connection (gb.db)
Creates a new connection object.
The format of optional DatabaseURL parameter is:
$TYPE://[$USER[:$PASSWORD]@]$HOST[:$PORT]/$NAME where the $USER and $PORT parts are optional. If this parameter is given and valid, the
Connection properties are filled with the information.
Since 3.18
the password can be specified in the URL.
Examples
' Create a MySQL connection
$hConn = New Connection("mysql://root@localhost:3306/testdb")
' Don't forget to set $hConn.Password if need be
' Create a SQLite3 connection, use $HOME/db.sqlite as database
$hConn = New Connection("sqlite3://" & User.Home &/ "db.sqlite")