Примеры использования сервиса

Создание базы данных

 SQLConfigDataSource( NULL,
                      ODBC_ADD_DSN,
                      "Firebird/InterBase(r) driver",
                      "ODBC\0"
                      "CREATE_DB = D:\\TestService\\test.fdb\0"
                      "DESCRIPTION = My Firebird database\0"
                      "UID         = SYSDBA\0"
                      "PWD         = masterkey\0"
                      "CHARSET     = NONE\0"
                      "PAGESIZE    = 8192\0"
                      "DIALECT     = 3\0" );

Резервирование(копия) базы данных

 SQLConfigDataSource( NULL,
                      ODBC_ADD_DSN,
                      "Firebird/InterBase(r) driver",
                      "ODBC\0"
                      "BACKUP_DB = D:\\TestService\\test.fdb\0"
                      "BACKUPFILE = D:\\TestService\\test.fbk\0"
                      "UID         = SYSDBA\0"
                      "PWD         = masterkey\0" );

Восстановление базы данных

 SQLConfigDataSource( NULL,
                      ODBC_ADD_DSN,
                      "Firebird/InterBase(r) driver",
                      "ODBC\0"
                      "RESTORE_DB = D:\\TestService\\testNew.fdb\0"
                      "BACKUPFILE = D:\\TestService\\test.fbk\0"
                      "LOGFILE = D:\\TestService\\test.log\0"
                      "UID         = SYSDBA\0"
                      "PWD         = masterkey\0" );

Ремонт базы данных

 SQLConfigDataSource( NULL,
                      ODBC_ADD_DSN,
                      "Firebird/InterBase(r) driver",
                      "ODBC\0"
                      "REPAIR_DB = D:\\TestService\\test.fdb\0"
                      "UID         = SYSDBA\0"
                      "PWD         = masterkey\0" );