Using native API (creating Firebird databse at
runtime)
Using native DBMS API requires including the appropriate DBMS API
header file (comes with SQLAPI++). Native DBMS methods are accessible
just after SQLAPI++ database connection is initialized. The sample
below
shows how to create Firebird database with SQLAPI++ using native
Firebird isc_dsql_execute_immediate
call:
#include <SQLAPI.h>
#include <ibAPI.h>
int main(int argc, char **argv)
{
SAConnection con;
con.setClient(SA_InterBase_Client);
ibAPI *pibAPI = (ibAPI *)con.NativeAPI();
ISC_STATUS status_vector[20];
isc_db_handle db_handle = NULL;
isc_tr_handle dummy_handle = NULL;
pibAPI->isc_dsql_execute_immediate(
status_vector,
&db_handle,
&dummy_handle,
0,
"create database 'localhost:c:/test.gdb' user 'SYSDBA' password 'masterkey'",
1,
NULL);
if (status_vector[0] == 1 && status_vector[1])
{
/* Process error. */
pibAPI->isc_print_status(status_vector);
return 1;
}
return 0;
}
Problems and Questions
If you haven't found the answer to your questions or have some
problems on using the Library, please, send e-mail to howto@.
|
