Firebird database - any experience ?

[Marco Turco]

Hi all,
I am looking for new solutions for a database in my apps and Firebird seem to be not only an interesting client/server solution but also a stand-alone good solution. This is my first approch to this kind of database, has anyone experience (and prg samples) of Firebird with FWH to share with me ?
Is there a FWH class to connect to Firebird ?

I checked that some fwh users use also Sqlite, is it also a good database solution ? As I know it is only suggested in a stand-alone installation due to the fact that it isn't a real client/server database. Isn't it ?

Thanks in advance for the info

[Armando]

Marco:

Take a look to this link for a connection string.

http://www.connectionstrings.com/firebird

Regards

[Marco Turco]

Hi Armando,
do you use ADO or ODBC to connect to FB ?

[Armando]

Marco:

I use ADO to connect to MySql, I have not experience in FireBrid, sorry .

BTW, If it does not matter the language to you, take a look to my blog.

http://sqlcmd.blogspot.com/

Regards

[nightwalker]

Can consult and use xHarbour contrib\firebird or Harbour contrib\hbfbird
It is very happy that we use the experience of firebeird in the past five years.

Consider the following advantages:
1.Firebird supports many platform.
2.Free mandate that can commercialize.
3.The experience which I myself test, use DLL of embed edition to change into fbclient.dll,
Revise line parameter, can totally inclusive embed and C/S edition.


best regards,
Tom Huang

[Marco Turco]

Hi Tom, thank for your suggest.
I'm trying to make some tests with the tFirebird class included into the contrib folder but I receive some link error (see as follow).
Do you have an already ready contrib.lib or any suggest to give me about the link ? It seem I haven't some .h files.

Thanks in advance.

MArco



Borland C++ 5.5.1 for Win32 Copyright (c) 1993, 2000 Borland
K:\TEST_FB\FIREBIRD.C:
Error E2209 K:\TEST_FB\FIREBIRD.C 64: Unable to open include file 'ibase.h'
Error E2451 K:\TEST_FB\FIREBIRD.C 84: Undefined symbol 'isc_db_handle' in function HB_FUN_FBCREATEDB
Error E2379 K:\TEST_FB\FIREBIRD.C 84: Statement missing ; in function HB_FUN_FBCREATEDB
Error E2451 K:\TEST_FB\FIREBIRD.C 85: Undefined symbol 'isc_tr_handle' in function HB_FUN_FBCREATEDB
Error E2379 K:\TEST_FB\FIREBIRD.C 85: Statement missing ; in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 86: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 87: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 89: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 90: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 91: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 92: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 93: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2140 K:\TEST_FB\FIREBIRD.C 94: Declaration is not allowed here in function HB_FUN_FBCREATEDB
Error E2451 K:\TEST_FB\FIREBIRD.C 113: Undefined symbol 'newdb' in function HB_FUN_FBCREATEDB
Error E2451 K:\TEST_FB\FIREBIRD.C 113: Undefined symbol 'trans' in function HB_FUN_FBCREATEDB
Warning W8065 K:\TEST_FB\FIREBIRD.C 113: Call to function 'isc_dsql_execute_immediate' with no prototype in function HB_FUN_FBCREATEDB
Warning W8065 K:\TEST_FB\FIREBIRD.C 114: Call to function 'isc_sqlcode' with no prototype in function HB_FUN_FBCREATEDB
Error E2451 K:\TEST_FB\FIREBIRD.C 122: Undefined symbol 'ISC_STATUS' in function HB_FUN_FBCONNECT
Error E2379 K:\TEST_FB\FIREBIRD.C 122: Statement missing ; in function HB_FUN_FBCONNECT
Error E2451 K:\TEST_FB\FIREBIRD.C 123: Undefined symbol 'isc_db_handle' in function HB_FUN_FBCONNECT
Error E2379 K:\TEST_FB\FIREBIRD.C 123: Statement missing ; in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 124: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 125: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 126: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 127: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 128: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2140 K:\TEST_FB\FIREBIRD.C 129: Declaration is not allowed here in function HB_FUN_FBCONNECT
Error E2228 K:\TEST_FB\FIREBIRD.C 129: Too many error or warning messages in function HB_FUN_FBCONNECT
*** 26 errors in Compile ***

[nightwalker]

you need the file ibase.h and iberror.h
just copy from firebird(you setup directory) \include


best regards,
Tom Huang