* Firebird and Interbase Data Provider
<ul>
- <li>Does not exist in Mono, but is a separate project
+ <li>ADO.NET Data Provider for Firebird and Interbase databases</li>
+
+ <li>Does not exist in Mono, but is a separate project</li>
+
+ <li>The <a href="http://firebird.sourceforge.net/index.php">Firebird Relational Database</a> is
+ is an independent project which uses source code based on the Interbase source code released
+ by Borland under the Interbase Public License</li>
- <li><a href="http://sourceforge.net/projects/firebase-net/">Firebird and Interbase
- Data Provider</a> for Microsoft .NET and Mono
+ <li>Both the Firebird Relational Database and the Firebird .NET Data Provider can be
+ downloaded from <a href="http://sourceforge.net/projects/firebird/">here</a></li>
+
+ <li>The Firebird .NET Data provider has been made
+ available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
+ number of contributions to the OdbcJdbc code</li>
+
+ <li>Bugs with Mono or the data provider should be reported
+ in Mono's Bugzilla <a href="http://bugzilla.ximian.com/">here</a>. If you
+ do not have Bugzilla user account, it is free
+ and easy to create one <a href="http://bugzilla.ximian.com/createaccount.cgi">here</a>.</li>
- <li><a href="http://firebird.sourceforge.net/index.php">Firebird Relational Database</a> is
- an independent project which uses source code based on the Interbase source code released
- by Borland under the Interbase Public License.
</ul>
-* Current Status
+** Current Status
-<ul>
- <li>Currently, it is able to connect to Firebird and Interbase databases
- and execute commands
-
- <li>The new data
- provider/driver is written in C# and provides a high-performance native
- implementation of the GDS32/API functions. This means that .Net developers
- will be able to access Firebird databases without the need of Firebird
- client install. In support of the new module, a new mailing list
- "firebird-net-provider" has been created. Please use this list for any
- questions that you may have about the provider. This provider has been made
- available by Carlos Guzmán Álvarez (aka "Carlos G.A."), who has also made a
- number of contributions to the OdbcJdbc code.
+<ul>
+ <li>Current stable version: 1.5.1</li>
+
+ <li>Current developement version: 1.6</li>
+
+ <li>The new data provider/driver is written in C# and provides a high-performance native
+ implementation of the GDS32/API functions. This means that .Net developers
+ will be able to access Firebird databases without the need of Firebird
+ client install</li>
+
+ <li>In support of the new module, a new mailing list
+ <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a> has
+ been created. Please use this list for any
+ questions that you may have about the provider</li>
</ul>
+
+** New features & enhancements in 1.6 version
+
+<ul>
+ <li>Firebird Embedded Server support.</li>
+ <li>New FbScript class implementation.</li>
+ <li>Improved connection pooling.</li>
+ <li>Improved array datatype support.</li>
+</ul>
-* Action Plan
+** Testing
<ul>
- <li>Get it to work on Mono too
- <li>TODO
-</ul>
+ <li>Need a working mono and mcs</li>
+
+ <li>Need access to a Firebird Relational Database or you can download
+ it from <a href="http://firebird.sourceforge.net">here</a></li>
+
+ <li>Get the Firebird .NET data provider from here as
+ <a href="http://lists.sourceforge.net/lists/listinfo/firebird-net-provider">firebird-net-provider</a>. Make
+ sure the Firebird .NET data provider binary assembly FirebirdSql.Data.Firebird.dll is
+ installed in the same place as the mono class libraries.</li>
+
+ <li>Has a ConnectionString format:
+<pre>
+ "Database=databasefile.gdb;User=user;Password=pass;Dialect=3;Server=hostname"
+</pre>
+
+ </li>
+
+ <li>C# Example:
+
+<pre>
+ using System;
+ using System.Data;
+ using FirebirdSql.Data.Firebird;
+
+ public class Test
+ {
+ public static void Main(string[] args)
+ {
+ string connectionString =
+ "Database=C:\\PROGRAM FILES\\FIREBIRD\\EXAMPLES\\EMPLOYEE.GDB;" +
+ "User=SYSDBA;" +
+ "Password=masterkey;" +
+ "Dialect=3;" +
+ "Server=localhost";
+
+ IDbConnection dbcon = new FbConnection(connectionString);
+ dbcon.Open();
+ IDbCommand dbcmd = dbcon.CreateCommand();
+ string sql = "SELECT * FROM employee";
+ dbcmd.CommandText = sql;
+ IDataReader reader = dbcmd.ExecuteReader();
+ while(reader.Read()) {
+ object dataValue = reader.GetValue(0);
+ string sValue = dataValue.ToString();
+ Console.WriteLine("Value: " + sValue);
+ }
+ // clean up
+ reader.Close();
+ reader = null;
+ dbcmd.Dispose();
+ dbcmd = null;
+ dbcon.Close();
+ dbcon = null;
+ }
+ }
+</pre>
+ </li>
+ <li>Building C# Example:
+ <ul>
+ <li>Save the example to a file, such as, TestExample.cs</li>
+ <li>Build on Linux:
+<pre>
+ mcs TestExample.cs -r System.Data.dll \
+ -r FirebirdSql.Data.Firebird.dll
+</pre>
+ </li>
+ <li>Build on Windows via Cygwin:
+<pre>
+ mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe \
+ TestExample.cs \
+ -lib:C:/cygwin/home/MyHome/mono/install/lib \
+ -r System.Data.dll -r FirebirdSql.Data.Firebird.dll
+</pre>
+ </li>
+ </ul>
+ </li>
+ <li>Running the Example:
+<pre>
+mono TestExample.exe
+</pre>
+</li>
+
+</ul>
+
projects / mono.git / blobdiff