It took more than a lot of searching, but finally after combining
and extrapolating the code I found on 4 different sites, I finally came up
with what I believe is a proper start to using Firebird in an embedded
application. Here it is in Pascal NET code, ( the types and vars are
elsewhere):
MyFBConnectionString := new FbConnectionStringBuilder();
MyFBConnectionString.Add('ServerType', 1);
MyFBConnectionString.Add('User', 'SYSDBA');
MyFBConnectionString.Add('Pooling', False);
MyFBConnectionString.Add('Password', 'masterkey');
MyFBConnectionString.Add('Dialect', 3);
MyFBConnectionString.Add('Database', DataStoreFile);
MyFbConnection := new FbConnection();
MyFbConnection.CreateDatabase(MyFBConnectionString.ToString);
At least this seems to compile! Unfortunately however, I am now
getting an error message when I attempt to run it thru the debugger saying
that it cannot find the fbembed.dll, which is located not only where it was
originally installed, but also in the application's exe directory! So the
only thing I can think of is that I'm still missing something in my
connection string. Does anyone know how to get past this?
Also, it's hard for me, coming from a strict Delphi background, to
believe how difficult it seems to be to get decent info on using Firebird!
I've asked everywhere including here before, and all I get are cryptic
replies like google it or your connection string is wrong! The docs have
absolutely no information to help a beginner start using it, and even the
code above, which is an extrapolation of googled code I can't say for sure
will work because it matches nothing I found anywhere! Nothing I found
would compile! This makes it very improbable that I would waste any money
of a Firebird book because if the internet docs and the docs that come with
the installation are this bad I'd be afraid of what I'd find in a real book!
I'm not trying to be a smartass. I'm really frustrated by the lack
of honest help and documentation that I've always depended upon with Delphi.
One guy replied to my query on the firebird list privately and told me that
I didn't know how to read, then proceeded to give me code and instructions
that had nothing to do with what I had asked!
So now even IF someone is able to tell me that the above code is
correct, or help me fix it if it is not, and can tell me how to get the app
to find the dll it cannot seem to now, I have no idea of what to do next!
The docs are full of interesting facts about SQL, but nowhere have IO seen
any instructions that show one how to setup and create tables, fields, give
them values, indexes, and retrieve data back without SQL! Yet I'm told it
is possible! Please tell someone who has only worked with dB's via
components where to find the information I need to make use of what I'm told
is a great system!
from Robert Meek dba Tangentals Design CCopyright 2006
Proud to be a moderator of "The Delphi Lists" at elists.org
(["An unused program is the consequence of a higher logic!", nil]) As
written in The Compendium of Accepted Robotic and Surrlogic Theorems Used in
the Self Analysis of Elemental Positronic Pathways...1st Edition Revised
_______________________________________________
Delphi-DB mailing list
[email protected]
http://www.elists.org/mailman/listinfo/delphi-db
