We are pleased to announce the second release candidate of our .NET Data Provider for interaction with Firebird and Interbase via IBProvider. By now, we have implemented all the functionality of System.Data.OleDb.
If you want to transfer your .NET projects for FB/IB to the new level of functionality and quality, we recommend you to start using «LCPI .NET Data Provider for OLE DB».
Just look of this DDEX screenshot:
You can get more screenshots and download Ole Db .Net Provider for access to any Interbase or any Firebird database from ADO.Net here: OleDb .Net driver for Firebird >>>
Here is the guide on installing Firebird 2.5.3 from FreeBSD 10 Ports and
creating your first test database; also we show you how to install
Flamerobin GUI (administration tool) and the PHP driver for it. This was tested on fresh FreeBSD 10 on a kvm-linux virtual machine.
Download a compressed snapshot of the Ports Collection into /var/db/portsnap.
# portsnap fetch
Or update it.
If you are running Portsnap for the first time, extract the snapshot into /usr/ports:
# portsnap extract
If you already have a populated /usr/ports directory and you are just updating, run the following command instead:
# portsnap update
Enter firebird server ports directory:
# cd /usr/ports/databases/firebird25-server
Compile and install firebird server:
# make -DPACKAGE_BUILDING
# make install
Enable it by adding
Start it with:
# /usr/local/etc/rc.d/firebird start
logs and security2.fdb seems to be in /var/db/firebird.
To create a new database:
SQL> create database “tmp/first_database.fdb”;
SQL> connect “/tmp/first_database.fdb” ;
Commit current transaction (y/n)? <– y
If you want to create a simple table then insert 1-2 rows and select from it; here is one example:
SQL> CREATE TABLE TEST (ID INT NOT NULL PRIMARY KEY, NAME VARCHAR(20));
SQL> show tables;
SQL> INSERT INTO TEST VALUES (1, ‘John’);
SQL> INSERT INTO TEST VALUES (2, ‘Joe’);
SQL> select * from test;
To quit the isql-fb console, type quit:
For a good open source GUI admin tool you might check the flamerobin administration tool included in ports repository; it can be installed by a simple:
# cd /usr/ports/databases/flamerobin/ && make install clean
Or if you don’t want to wait use pkg-add
# pkg-add -r flamerobin
To use firebird with php, you will need the php5 driver:
# cd /usr/ports/databases/php5-interbase/ && make install clean
You can choose to compile php with apache support (I have chosen cli, cgi , and apache support);
check it if is enabled with:
# /usr/local/bin/php -m
Or if you don’t want to wait compile all the php use pkg-add
# pkg-add -r php5-interbase
ADO.NET provider 22.214.171.124 for Firebird is ready and you can find more at http://blog.cincura.net/233462-ado-net-provider-4-2-0-0-for-firebird-is-ready/.
Every year on January 18 we have a small celebration – IBProvider’s birthday.
This year it turned 14.
We thank all our users for using the provider in your projects.
We promise that we will continue to improve IBProvider till it completely supersedes Firebird and Interbase
Read more about the new features in Firebird and Interbase driver >>>
We are pleased to announce the new release of our OLEDB Provider: version 3.18.
Now in your projects for Firebird and Interbase you can more comfortable work with Linked Server of MSSQL 2012. Hurrah!
In new release:
- Improved performance of the provider as a linked MSSQL server.
- Provider compilation with Visual Studio 2012.
- Update of the article on configuration and usage of linked MSSQL server.
- Update of the MSI installers.
You can download IBProvider here: Firebird and Interbase driver >>>