/// <summary>
/// Connect to an Odbc driver connected database.
/// This must be called before any SQL methods.
/// The Odbc service must be running and database with credentials already created, if in doubt use SQLite.
/// </summary>
/// <param name="driver">The Odbc driver (e.g. "{MySQL ODBC 3.51 Driver}").</param>
/// <param name="server">The Odbc server (e.g. "localhost").</param>
/// <param name="port">The Odbc port number.</param>
/// <param name="user">The Odbc user name.</param>
/// <param name="password">The Odbc user password.</param>
/// <param name="option">The Odbc option number to control the Odbc connection (e.g. 0 or 3).</param>
/// <param name="database">The Odbc database name.</param>
/// <returns>A label to identify the database.</returns>
public static Primitive ConnectOdbc(Primitive driver, Primitive server, Primitive port, Primitive user, Primitive password, Primitive option, Primitive database)
{
try
{
ExtractDll();
DataBase dataBase = GetDataBase(database, false);
if (null == dataBase)
{
dataBase = new DataBase(database, NextID());
dataBase.ConnectOdbc(driver, server, port, user, password, option);
}
dataBases.Add(dataBase);
return(dataBase.name);
}
catch (Exception ex)
{
Utilities.OnError(Utilities.GetCurrentMethod(), ex);
}
return("");
}