Firebird data provider

[Denis Vulinovich]

I've just downloaded OpenAccess to work with a Firebird database. The help documentation says to download the Firebird ADO.NET data provider v2.0.1.0, and it provides a link to the download webpage. Unfortunately, that link is out of date - probably since the v2.5 data provider was released a month ago. I've tried doing a Google search to locate v2.0.1.0, but I couldn't find it.

Do you know where I can locate that provider? Alternatively, can I use the new v2.5 provider?

[Nicolas DORIER]

The OpenAccess wizard search for the version 2.1.0.0 not v2.0.1.0 : 'FirebirdSql.Data.FirebirdClient, Version=2.1.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c'

But I haven't found it either, I'd appreciate a solution.

[PetarP]

Hello Nicolas DORIER,
yes you are right. The link in this web page is a bit outdated and we have changed it now. Here is the correct link.
Thank you for your report. Your Telerik points were updated.

Best wishes,
Petar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Michael Third]

I realize I'm resurrecting a really old thread but the FirebirdClient 2.1.0.0 is no longer available for download.  I'm running the latest version (2.5.1.0) and I've been able to work around the issues with the Wizard but adding bindingRedirect elements to the devenv.exe.config file.  However this same technique does not work at runtime for the application.  Do you have any workarounds or perhaps a beta build that supports the latest provider?

[Alexander]

Hello Michael Third,

Sorry for the delayed answer, we are aware of the problem.
You can add the same bindingRedirect node to the App.config file:

<configuration>
   <runtime>
      <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
         <dependentAssembly>
            <assemblyIdentity name="FirebirdSql.Data.FirebirdClient" publicKeyToken="3750abcc3150b00c" culture="neutral" />
            <bindingRedirect oldVersion="2.1.0.0" newVersion="2.5.1.0"/>
            <codeBase version="2.5.1.0" href="C:\FirebirdSql.Data.FirebirdClient.dll"/>
         </dependentAssembly>
      </assemblyBinding>
   </runtime>
   ...
</configuration>

This should resolve the runtime problem.

Sincerely yours,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[harry]

found the firebirdclient 2.1.0.0 here:

http://firebird.borlandforum.com/impboard/impboard.dll?action=read&db=fb_res&no=155

openaccess is great! any plans on upgrading to the latest firebird client?

[Alexander]

Hello harry,

Yes, we are going to upgrade the version of the client - most probably for the Q1 release.

Regards,
Alexander
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Sörnt Poppe]

Hi Alexander,

I didn't find any information which Firebird version is in the current 2010 Q1 release supported. Can I get an update on this?

Kind regards,
Sörnt

[Alexander]

Hi Sörnt Poppe,

The Firebird client dependency is updated to the 2.5.1.0 version. You should not need the assembly redirection anymore.

All the best,
Alexander
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Sörnt Poppe]

Thank you very much!

[Lars]

Same problem now seems to occur with the latest DataProvider 2.5.2.0 but unfortunately the redirection by App.config deosn't work, i still get the FileNotFoundException

This is my app.config:

01.<configuration>
02. <runtime>
03.  <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
04.   <dependentAssembly>
05.    <assemblyIdentity name="FirebirdSql.Data.FirebirdClient" publicKeyToken="3750abcc3150b00c" culture="neutral" />
06.    <bindingRedirect oldVersion="2.5.1.0" newVersion="2.5.2.0"/>
07.    <codeBase version="2.5.2.0" href="C:\Program Files\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll"/>
08.   </dependentAssembly>
09.  </assemblyBinding>
10. </runtime>
11....

Adding the old 2.5.1.0 Client to the Global Assembly Cache or directly to the Project also doesn't work.

Do you also have a possible solution for this problem? Because we are running projects that need the 2.5.2.0 DataProvider due to Bug in 2.5.1.0.

I'm using Firebird Server 2.1.3.x and VS2008. According to your Homepage this should work but according to the help file of OpenAccess ORMExpress only Server 2.0 und VS2005 are supported. 

edit:

After rebooting the System it is now working with the integration of the client 2.5.1.0 into the global assembly cache. But it would be better if i at least could use the assembly binding for the latest client 2.5.2.0.

So it would be nice if you have any solution for this.

Thanks in advance...

[Micheal]

We also need to use 2.5.2.0
Help Telerik!

[Ady]

Hi,

@Michael - Can you redirect to the 2.5.2 version by adding the 'assemblyBinding' entries to the app.config?

@Lars - Does the  redirection not work for you?

We will test the product against the latest version (2.5.2) and if all goes well, we will update the dependency for the next release.

Best wishes,
Ady
the Telerik team

[Lars]

Unfortunately redirection does not work with the app.config i posted before.

So we tested a bit with client 2.5.1. But as pointed out before this client has a bug which could prevent some transactions to work correct under Win XP. So the client 2.5.2 is indispensable for us.

[Ady]

Hi Lars,

 I did test with exactly the same configuration entries (except the 'codeBase' entry pointed to a different path) and the runtime could resolve the assembly reference correctly.

Do you have the 2.5.2.0 assembly version in the GAC? If not, is the assembly present in the path mentioned in the codeBase - C:\Program Files\FirebirdClient\FirebirdSql.Data.FirebirdClient.dll"?


Sincerely yours,
Ady
the Telerik team

[Lars]

Hi Ady,

i have Clients version 2.0.1.0, 2.5.1.0 and 2.5.2.0 in the GAC. In the CodeBase i only have the 2.5.2.0 Client.

A colleague of mine tested it on his machine (same configuration as mine but different user and you never know ;) ) and it didn't wok there either.

But strangely enough now it is working, so i guess somehow rebooting the machine did the trick and now it is working for both of us.

So thank you for your testing and your help.

Kind regards

Lars

[Ady]

Hi Lars,

 Glad to know that you could get it working. We will update this forum thread with the progress on the provider update to 2.5.2.

Sincerely yours,
Ady
the Telerik team