Release of ADO.NET provider for OLE DB engines!

Hello everyone!

We are pleased to announce the release of our “LCPI ADO.NET provider for OLE DB” which allows to create a professional solutions for Firebird!

Our .NET provider doesn’t force you to use ADO.NET as the exclusive access technology in application. You can use ADODB and work with OLEDB provider directly. Simultaneously!

You can use any .NET programming language and any programming language that supports COM or ActiveX. All at once!

And, of course, you can be sure in quality of this ADO.NET provider. We used TDD from beginning to end of development cycle.

Read the full text of press release here – http://www.ibprovider.com/eng/news/n_150408_adonet_provider_release.html

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

IBProvider 3.18. Better support of MSSQL. Changeover to the new VS 2012 compiler

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.

Plus:

You can download IBProvider here: Firebird and Interbase driver >>>

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Release candidate of .Net Provider for OleDb

Firebird driver become faster We are pleased to announce the release candidate of our .NET Provider for OleDb.

Now you can use 200% of the ADO.Net power in your projects for Firebird and Interbase:

  1. Read sets via OleDbDataReader and change them simultaneously (MARS technology).
  2. Use nested transactions, savepoints and distributed transactions within the TransactionScope.
  3. Execute several select, update and insert queries with parameters(!) within only one command OleDbCommand.
  4. Work with absolutely all types of data, including arrays and even Interbase Guid.
  5. And yes, now after you have set the command text you don’t need to manually add parameters to the query. Everything is done automatically and on the fly.

You can download ibprovider here: Firebird OleDb driver >>>

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Dozens of new options for Firebird and .NET Framework

Hey!

If you have ever worked with Firebird or Interbase using the standard .NET provider for OLE DB (System.Data.OleDb), you will have likely encountered issues like this:

  • The necessity to add ALL parameters manually.
  • Even though the OLE DB provider supports parameter generation for commands, the .NET provider doesn’t use it, so you as the programmer must do that work on your own.
  • The lack of support for named parameters. Although they actually exist, using them in reality requires a whole set of complex manipulations (the steps needed to add a parameter to a collection, etc.).
  • The impossibility of using multiple DataReader objects at the same time (Multiple Active Result Sets).
  • No execution of SQL scripts which contain several SQL expressions per command. This list of difficulties a .NET developer has to deal with is far from complete. Now it’s all different in a fundamentally new .NET Data Provider for OLE DB

IBProvider Team

Firebird driver

1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 3.00 out of 5)
Loading...

Are your data access components ready for Firebird 3?


Firebird 3 driver for OLE DB

We are continuing to actively add new functionality of Firebird 3 DBMS to IBProvider.

Let us remind you that already 2 months ago we added support of BOOLEAN data type from Firebird 3. In the new version of IBProvider Professional, we added support of PACKAGE instruction.

Now you can put in order a bulk of database procedures and functions and group them by sense into individual modules (PACKAGE). This arrangement will substantially simplify understanding and maintenance of SQL code.

Ream more about Firebird 3 access improvements.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

IBProvider Release Candidate 4

New release candidate of IBProvider Professional Edition has appeared. Is the modern driver for access to 16 versions of the Firebrd and Interbase servers.

Improved support of DDEX (Data Designer Extensibility) when working with Firebird and Interbase

IBProvider RC4 has the new option of stored procedures calling in Visual Studio 2008 style via ODBC escape sequences. This innovation allows to create queries and TableAdapters based on stored procedures.

Optimized working with named parameters in SQL query text

  • Fewer limitations for multiple use of same named parameter in SQL query text
  • New algorithm for choosing named parameter data type.
  • Some errors of named parameters procession detected via profound testing by exhaustive method have been eliminated.

Metadata schemes and column descriptions (IColumnsRowset) support user encoding

Metadata schemes and IColumnRowset interface now consider user charset . This allows working with metadata in set encoding.

What comes next?

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

IBProvider for Firebird and Interbase has been released.

Changes in IBProvider v2 (build 2.6.06.2688)

  • Addition of UTF-8 charset support
  • Loading of charset information for COLUMN and PROCEDURE_PARAMETERS metadata schemes from system tables.

Changes in IBProvider v3 (build 3.0.0.6327 RC3)

New IBProvider v3 offers the brand new method for working with text data charsets:

  • We added ctype_user property that allows setting the encoding of data coming to client irrespective of the encoding in which this data is coming from database server.
  • New algorithms of BLOB fields converting provide for quick work with flowing data, optimization of interaction with ICU library.
  • We added ctype_none property that allows setting the charset for working with text data in NONE encoding.
  • Other important changes.
  • Support of Firebird and Interbase charsets aliases.

See detailed information on working with new character set processor in Firebird and Interbase character sets.

Text columns size in Firebird 2.X

IBProvider started to control text columns size when working with Firebird 2 servers in Unicode mode. If the length of loaded data exceeds the text column size the exclusion will be generated.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
1 2