New Connection (gb.db)

Dim hConnection As Connection
hConnection = New Connection ( [ DatabaseURL As String ] )

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.

Sinds 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")