Subject embed / win32 / cannot create db
Author darren_martz
I am new to Firebird, and am trying out the embedded version on
WinXP with VisualStudio 2003.

I installed the ZIP of the Firebird Embedded 1.5

Then I installed the ZIP of the Firebird Server 1.5 but only to get
the fbclient_ms.lib and ibase.h files.

Using the api1.c sample in the server ZIP, I attempted to create a
database. So myapp.exe is based on api1.c and links to the embedded
DLL.

The project always fails reporting an error code of -902 with the
text output indicating a missing username and password.

What am I missing? I read that embedded is limited to a single
thread and one database - are there more limitations?

What am I doing wrong??

isc_db_handle db = NULL;
isc_tr_handle tx = NULL;
ISC_STATUS_ARRAY status;
char szSql[] = "CREATE DATABASE 'test.fdb'";
if ( isc_dsql_execute_immediate(status,&db,&tx,0,(char*)
szSql,1,NULL) ) {
sqlcode = isc_sqlcode(status); //ALWAYS HAS -902
isc_print_status(status);
}