After spending about three hours this morning and looking up some opposing
esamples from yet another Firebird NET site on the internet, I came up with
this:
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);
Now THIS actually compiles but when I run it in the debugger it tells me
it cannot find 'fbembed.dll'! I have that file in it's installation
directory as well as in the application's exe directory, so there must be
something missing in the conection string perhaps?
--
from Robert Meek dba Tangentals Design
[EMAIL PROTECTED]
""Robert Meek"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I've gone thru all the docs, looked up instructions on Google, but STILL I
> cannot get an embedded setup to work! There are really no consise
> instructions available that I have been able to find that take you from
> setup to creating a database, adding tables, fields, indexes, etc.
> I added the proper dll to my references section in VS 2005. I added
> FirebirdSQL.Data.FirebirdClient to the namespace in order to get some of
> my
> code to compile although it didn't tell me anywhere in the docs about
> doing
> so! Then from bits and pieces I fouind on the internet I finally came up
> with this...which is in Object Pascal btw as I use Chrome ontop of VS
> 2005.
>
> First I name the variables:
> Var MyFBConnection: FbConnection;
>
> Var MyFBParams: Hashtable;
>
> //Then here's the code it tells me to run:
>
> DataStoreFile := Path.Combine(DataStoreDir, 'ProgManagerDB.fdb');
> MyFBConnection := new
> FbConnection('ServerType=1;SYSDBA;Pooling=False;Password=masterkey;Dialect=3;DataBase='
> + DataStoreFile);
> MyFBParams := new Hashtable();
> MyFBParams.Add('User', 'SYSDBA');
> MyFBParams.Add('Password', 'masterkey');
> MyFBParams.Add('Database', DataStoreFile);
> MyFBParams.Add('ServerType', 1);
> MyFbConnection.CreateDatabase(MyFBParams);
>
> //Of course this won't compile because the error says the parameter for
> Createdatabase must be a string, but what string? I cannot even find this
> method in the help docs anywhere! And nowhere can I find out what to do
> next! All i want to do is set up a simple embedded server application,
> create and fill some tables with values, give them indexes, and be able to
> retrieve the data. According to what I was told, I should be able to do
> so
> without SQL, but I can't find any instructions! PLEASE help if you can.
> You will earn my undying gratitude!
>
> --
> from Robert Meek dba Tangentals Design
> [EMAIL PROTECTED]
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
