Hi all. Because I have to access a Firebird database directly, I've installed a relatively new provider (2.0.1.0) while LLBLGenPro expects version 2.0.0.0. Here's some more info:

I'm running LLBLGen Pro .NET 2.0 ORM Support Classes Library version: 2.0.0.61005

Here's the message: Could not load file or assembly 'FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c' or one of its dependencies. System could not find the file

-----[Core exception]-------------------- at SD.LLBLGen.Pro.DBDrivers.Firebird.FirebirdConnectionData._testConnectionButton_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

SD.LLBLGen.Pro.DBDrivers.FirebirdDBDriver

Here's the Firebird Client Lib that's in the QAG: I got FirebirdSql.Data.FirebirdClient 2.0.1.0 Public token: 3750abcc3150b00c

I've also tried to change the version nr in the LLBLGen Pro source and recompile, but could not get it to work due to missing key. Anyway, I prefer compiled libraries from LLBLGen.

TIA Best wishes Kai Bohli Norway

Try to add an assembly redirect to the LLBLGenPro.exe.config file Something like this (except this example is for an oracle driver):

<dependentAssembly>
    <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342"/>
    <bindingRedirect oldVersion="10.1.0.000-10.2.0.100" newVersion="2.102.2.20"/>
</dependentAssembly> 

Hi Walaa !

Thanks for the reply.

I tried that, but still got the same error message Here's what I did in LLBLGenPro.exe.config:

<dependentAssembly>
<assemblyIdentity name="SD.LLBLGen.Pro.DBDrivers.FirebirdDBDriver" publicKeyToken="3750abcc3150b00c" culture="neutral"/>
<bindingRedirect oldVersion="2.0.0.0" newVersion="2.0.1.0"/>
</dependentAssembly>

Walaa wrote:

Try to add an assembly redirect to the LLBLGenPro.exe.config file Something like this (except this example is for an oracle driver):

<dependentAssembly>
    <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342"/>
    <bindingRedirect oldVersion="10.1.0.000-10.2.0.100" newVersion="2.102.2.20"/>
</dependentAssembly> 

2.0.1 is a release candidate. Could you please install the 2.0 final for the firebird provider?

Hi Otis.

Ok, I guess I have to

Otis wrote:

2.0.1 is a release candidate. Could you please install the 2.0 final for the firebird provider?

Hi again Otis.

I've installed firebird provider 2.0 final and LLBLGenPro works again.

BTW - it's a wondeful product. I could not convince my boss to use it cause he felt that he looses to much control of his dear sql and sp's. Though I disagree with him, I also understand him. I therefore bought LLBLGenPro for myself and will make something to show him. Hopefully, I'll get to use LLBLGenPro at work too. It's a shame that it's so much to do at work that there's no time left for hobby programming though

Otis wrote:

2.0.1 is a release candidate. Could you please install the 2.0 final for the firebird provider?

kaiboe wrote:

Hi again Otis.

I've installed firebird provider 2.0 final and LLBLGenPro works again.

BTW - it's a wondeful product. I could not convince my boss to use it cause he felt that he looses to much control of his dear sql and sp's.

Yeah, some people really adore working late at night and spend a lot of time on repetitive stuff

Though I disagree with him, I also understand him. I therefore bought LLBLGenPro for myself and will make something to show him. Hopefully, I'll get to use LLBLGenPro at work too. It's a shame that it's so much to do at work that there's no time left for hobby programming though

Thanks!