Dbms Firebird and Vb.net

Posted by dragon on Friday, 30 September 2011

Warning: this article has been modified on 17 February 2007
Dbms the Firebird offers excellent performances also regarding other famous dbms. Moreover it is free, it's wheight (very light) is around 14 mega. It has a client-server structure and as far as instructions SQL they follow the international standards.
For a comparison with others dbms see here
The last setup for the classic server and superserver can be dowloaded here.
Firebird database can work also without main Server installed. In fact there is the embedded version of the server which you can download from here. The embedded version (very light) is particularly suitable for standalone applications. For the libraries and folder you which have to put in the target application folder see http://firebird-vbnet.blogspot.com/2007/02/solved-issue-unable-to-load-dll-fbembed.html
To work with .net applications Firebird needs the .net provider which you can download here.
Now is more easy to insert indexes and primary keys in the tables.
As editors of SQL there are free applications. One freeware is SQL Manager 2010 lite for InterBase/Firebird. You can download it for free from: from http://www.softpedia.com/progDownload/EMS-IB-FB-Manager-Lite-Download-22779.html. The other is IBEasy+ 1.5.2 from here. Once installed IBEasy+ 1.5.2 I recommend to put in its application directory fbembed.dll, icuu30.dll, icuin30.dll and the icudt30.dll of an updated embedded firebird package.
IBEasy+ 1.5.2 may is useful to import database from other dbms. I council to import from Excel stylesheets. But we'll see how in this post: http://firebird-vbnet.blogspot.com/2007/02/from-mdf-to-gdb-with-free-software.html.
SQL Manager 2010 lite is more complete, even if it doesn't allow to import databases from other dbms.
-The connection strings for Server and Superserver is: "servertype=1;username=sysdba;password=masterkey;database=" _& My.Application.Info.DirectoryPath & "\mydb.gdb"
-The connection strin for embedded server is: "servertype=0;username=sysdba;password=masterkey;database=" _& My.Application.Info.DirectoryPath & "\mydb.gdb"

{ 0 comments... read them below or add one }

Post a Comment