LoadConnection re-establishes a connection that was saved using the Save command or Database Connection Maplet application.

Each connection that is saved using the Save command has an associated identifier. This identifier is used to distinguish between the connections saved in a file.  If specified, name is used as the identifier. Otherwise, "default" is used as the identifier.

The opts argument can contain one or more of the following equations.

filename = string

The filename option specifies the file from which this connection is loaded.  When no filename is given, connections are loaded from $HOME/maple/toolbox/Database/data/default.con, where $HOME is the value returned by kernelopts( homedir ).

password = string or one of the literal symbols none or hidden

The password option is used to specify the password to use when re-establishing the connection to the database.  If a password option is given, it overrides a password that is saved in the file.  If no password is saved in the file and a password is required to connect to the database, then the password option must be given.  If a string is given, that string is used as the password.  If hidden is given, then a Maplet application opens to allow you to enter a password without it appearing in the worksheet.  The default value is none.

Along with saving the parameters necessary to re-establish the connection, the Save command also stores the connection's current settings, as returned by the GetOptions command.  When a connection is loaded using the LoadConnection command, these settings are also restored.

LoadConnection returns an expression sequence of two modules.  The first module is the Database[Driver] module you used to open the connection.  The second is the Database[Connection] module representing the opened connection.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$

$\mathrm{conn}:-\mathrm{Save}\left(\right)\:$

$\mathrm{conn}:-\mathrm{Close}\left(\right)\;$$\mathrm{driver}:-\mathrm{Close}\left(\right)$

$\mathrm{driver},\mathrm{conn}≔\mathrm{Database}\left[\mathrm{LoadConnection}\right]\left(\mathrm{password}='\mathrm{hidden}'\right)\:$

$\mathrm{conn}:-\mathrm{SetOptions}\left('\mathrm{autocommit}'=\mathrm{true}\right)$

$\mathrm{conn}:-\mathrm{Save}\left(''ac1''\,'\mathrm{password}'=\mathrm{pass}\right)\:$

$\mathrm{conn}:-\mathrm{Close}\left(\right)\;$$\mathrm{driver}:-\mathrm{Close}\left(\right)$

$\mathrm{driver},\mathrm{conn}≔\mathrm{Database}\left[\mathrm{LoadConnection}\right]\left(''ac1''\right)\:$

$\mathrm{conn}:-\mathrm{GetOptions}\left('\mathrm{autocommit}'\right)$

$\left[\mathrm{autocommit}=\mathrm{true}\right]$