LitDev.DataBase.ConnectOdbc C# (CSharp) Method

ConnectOdbc() public method

public ConnectOdbc ( string driver, string server, Primitive port, string user, string password, string option ) : void
driver string
server string
port Primitive
user string
password string
option string
return void
        public void ConnectOdbc(string driver, string server, Primitive port, string user, string password, string option)
        {
            dbType = DBType.Odbc;
            name = "DataBase" + id.ToString();
            dbConnection = "Driver=" + driver + ";Server=" + server + ";Port=" + port + ";DataBase=" + database + ";Uid=" + user + ";Pwd=" + password + ";option="+option;
            if (LDDataBase.Connection != "") dbConnection = LDDataBase.Connection;
            cnnOdbc = new OdbcConnection(dbConnection);
            cnnOdbc.Open();
            commandOdbc = new OdbcCommand();
            commandOdbc.Connection = cnnOdbc;
        }

Usage Example

Esempio n. 1
0
 /// <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("");
 }
All Usage Examples Of LitDev.DataBase::ConnectOdbc