Interbase and Firebird ado.net provider

Interbase and Firebird ado.net provider

Postby lynx240 » Thu 03 Oct 2013 22:55

I need to access a Interbase 2007 database through Visual Studio 2012 Pro. From what I've been reading on several posts, is that Firebird and Interbase are not compatible, so I was surprised to see that the Universal dotConnect does not use a Interbase ado.net provider but a Firebird one. The Interbase database I will be connecting to has several procedures and functions and I am concerned that I may run into issues. Thanks

Glen
lynx240
 
Posts: 2
Joined: Thu 03 Oct 2013 22:43

Re: Interbase and Firebird ado.net provider

Postby Pinturiccio » Fri 04 Oct 2013 13:54

dotConnect Universal has a set of supported providers that you can use without additional settings. FirebirdClient is one of such providers. For more information, please refer to http://www.devart.com/dotconnect/universal/docs/?Providers.html. dotConnect Universal uses Firebird .NET Provider for working with Firebird databases http://www.firebirdsql.org/. According to the information from the Firebird .NET Provider website, this provider supports the InterBase database. For more information, please refer to http://www.firebirdsql.org/en/firebird-net-provider-faq/#4.

You can use the trial version of dotConnect Universal to test working with InterBase database for 30 days since dotConnect Universal installation. You can download the trial version of dotConnect Universal from our website http://www.devart.com/dotconnect/universal/download.html
Pinturiccio
Devart Team
 
Posts: 1983
Joined: Wed 02 Nov 2011 09:44

Re: Interbase and Firebird ado.net provider

Postby lynx240 » Sat 05 Oct 2013 13:55

Pinturiccio

Thanks for you quick response. I took a look at the FAQ you reference and if Devart is using this to claim it supports Interbase, it doesn't give me much confidence. A few points:

1. The statement (In the FAQ) "it should work with InterBase 6.0 too" is not exactly a ringing endorsement.
2. Interbase 6 (which is the version Firebird used as their start point) was release in 2000, where as Interbase 2007 was released in 2006, how compatible there are at this point, I'm not sure. and;
3. It may take me more than 30 days to ensure the Firebird provider is compatable with Interbase 2007 before having to put out $200 US for the dotNet Universial add on.

It would be nice if I could get a response from someone who has used this product on a Interbase database version 2007 or greater. In the mean time I will continue to test and let you know if there are any issues. Thanks

Glen
lynx240
 
Posts: 2
Joined: Thu 03 Oct 2013 22:43

Re: Interbase and Firebird ado.net provider

Postby Pinturiccio » Mon 07 Oct 2013 15:23

lynx240 wrote:1. The statement (In the FAQ) "it should work with InterBase 6.0 too" is not exactly a ringing endorsement.
2. Interbase 6 (which is the version Firebird used as their start point) was release in 2000, where as Interbase 2007 was released in 2006, how compatible there are at this point, I'm not sure. and;

Unfortunately this question is beyond our support. Ask the FirebirdClient support for this information.

lynx240 wrote:3. It may take me more than 30 days to ensure the Firebird provider is compatable with Interbase 2007 before having to put out $200 US for the dotNet Universial add on.

If the 30-day trial period is not enough for you, please write to our support team
support at devart dot com when the trial period is over and we consider the prolongation of the trial period.

dotConnect Universal can work with any ADO.NET provider. If you find another ADO.NET provider working with InterBase, you can use it with dotConnect Universal via the UniProvider component. For more information, please refer to http://www.devart.com/dotconnect/universal/docs/?AnyProvider.html.
Pinturiccio
Devart Team
 
Posts: 1983
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect Universal