Дата публикации: 05.01.2003
Подключение к базе данных (VB, C++)
Sub sample1() Dim cn As New ADODB.Connection 'use connection string from file "employee.ibp": 'data source=localhost:d:\database\employee.gdb;User ID=gamer;password=vermut; 'ctype=win1251;auto_commit=true; cn.Open "file name=d:\database\employee.ibp" cn.Close 'Standart connection methods cn.Provider = "LCPI.IBProvider" cn.Open "data source=localhost:d:\database\employee.gdb;ctype=win1251", _ "gamer", "vermut" cn.Close ' Using user id cn.Open "data source=localhost:d:\database\employee.gdb;ctype=win1251;" & _ "user id=gamer;password=vermut" cn.Close ' Using user cn.Open "data source=localhost:d:\database\employee.gdb;ctype=win1251;" & _ "user=gamer;password=vermut" cn.Close ' Work in auto commit mode with read commited isolation level cn.Open "data source=localhost:d:\database\employee.gdb;ctype=win1251;" & _ "auto_commit=true;auto_commit_level=0x1000;" & _ "user id=gamer;password=vermut" cn.Close ' Switching connection to auto commit mode cn.Open "data source=localhost:d:\database\employee.gdb;ctype=win1251;" & _ "user id=gamer;password=vermut" cn.Properties("Session AutoCommit") = True 'enable auto commit cn.Properties("Autocommit Isolation Levels") = 4096 'read commited=0x1000 End Sub 'sample1
void TSampleCode1::execute() { cout<<"Sample Code #1"<<endl; try { t_db_data_source source; //explicit definition _THROW_OLEDB_FAILED(source,create("LCPI.IBProvider")) _THROW_OLEDB_FAILED(source,load("employee.ibp")) _THROW_OLEDB_FAILED(source,attach("")) //From file _THROW_OLEDB_FAILED(source,attach("file name=employee.ibp")) //Use provider name and file for its initialize _THROW_OLEDB_FAILED(source, attach("provider=LCPI.IBProvider;file name=employee.ibp")) //separate definition of user and its password (and override default settings) _THROW_OLEDB_FAILED(source, attach("provider=LCPI.IBProvider;file name=employee.ibp;", "gamer","vermut")) //All parameters in one line TExtPropParser props(*ifstream("employee.ibp").rdbuf()); str_formatter fmsg("provider=%1;data source=%2;"); fmsg<<"LCPI.IBProvider"<<props["data source"]; _THROW_OLEDB_FAILED(source,attach(fmsg,"gamer","vermut")) } catch(exception& exc) { cout<<"error: "<<exc.what()<<endl; } }//execute