Firebird 8.0.1

Posts   
 
    
Posts: 256
Joined: 05-Jul-2010
# Posted on: 14-Jul-2021 11:25:59   

Hi

I can't get the latest firebird 8.0.1 working in the designer. On itself this is not a problem now, but futurewise more features and changes will be added. Just notifiying you

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 14-Jul-2021 11:40:04   

I think it's a bug in the MSI installer for the firebird client. I tried it a minute ago after reading your post and it gave an error that multiple entries were present for Firebird sqlclient in the factory table. Looking into C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config (around line 160), I saw 2 entries. Removing the older one (keeping the 8.0.1) solved it.

It also might be you have the provider registered manually through the llblgenpro.exe.config file. If so, if you have now registered the factory (through the msi installer) with the machine.config file you can comment the lines out in the llblgenpro.exe.config file.

I'll report this at the github repo.

Frans Bouma | Lead developer LLBLGen Pro
Posts: 256
Joined: 05-Jul-2010
# Posted on: 14-Jul-2021 11:54:24   

Otis wrote:

I think it's a bug in the MSI installer for the firebird client. I tried it a minute ago after reading your post and it gave an error that multiple entries were present for Firebird sqlclient in the factory table. Looking into C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config (around line 160), I saw 2 entries. Removing the older one (keeping the 8.0.1) solved it.

It also might be you have the provider registered manually through the llblgenpro.exe.config file. If so, if you have now registered the factory (through the msi installer) with the machine.config file you can comment the lines out in the llblgenpro.exe.config file.

I'll report this at the github repo.

Hi

I do it manually through the config file. I don't install anything. Just copy the .net assembly in your homedir and I change

<add name="Firebird Client Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=8.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 14-Jul-2021 11:56:50   

Tho what error do you get? simple_smile I'll try what you describe

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 14-Jul-2021 12:05:45   

I put the dll in the designer's folder and commented out the line in machine.config and uncommented the line in llblgenpro.exe.config and adjusted it to: <add name="Firebird Client Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=8.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c"/>

and I can create a new project using firebird, it can now load the factory.

Line looks the same as yours... odd.

Frans Bouma | Lead developer LLBLGen Pro
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 19-Jul-2021 15:34:48   

You didn't reply but I think you ran into this issue: https://github.com/FirebirdSQL/NETProvider/issues/971

As we noticed this this morning, right after releasing 5.8.2 GA, we'll add it to the next point release, but in case you want to fix it today, please copy the attached two assemblies into the <llblgen pro installation folder>\Drivers\Firebird

Attachments
Filename File size Added on Approval
Firebird801DriverAdditionalAssemblies.zip 22,153 19-Jul-2021 15:34.58 Approved
Frans Bouma | Lead developer LLBLGen Pro
Posts: 256
Joined: 05-Jul-2010
# Posted on: 19-Jul-2021 16:10:18   

Otis wrote:

You didn't reply but I think you ran into this issue: https://github.com/FirebirdSQL/NETProvider/issues/971

As we noticed this this morning, right after releasing 5.8.2 GA, we'll add it to the next point release, but in case you want to fix it today, please copy the attached two assemblies into the <llblgen pro installation folder>\Drivers\Firebird

Sorry

First days of nice weather this summer... I care, but not that much ;-)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 19-Jul-2021 21:57:52   

Alexander wrote:

Otis wrote:

You didn't reply but I think you ran into this issue: https://github.com/FirebirdSQL/NETProvider/issues/971

As we noticed this this morning, right after releasing 5.8.2 GA, we'll add it to the next point release, but in case you want to fix it today, please copy the attached two assemblies into the <llblgen pro installation folder>\Drivers\Firebird

Sorry First days of nice weather this summer... I care, but not that much ;-)

I can imagine simple_smile But in any case, if you got that error, that's the solution (for the time when rain will start to fall again wink )

Frans Bouma | Lead developer LLBLGen Pro