Hi

I have an application that worked fine with LLBL 2004 a firebird databse using the .NET provider 1.6.3

I am now trying to upgrade this app to the latest version of LLBL which uses the 1.7 version of the .NET provider

Here is what I did

1. Uninstall the 1.6.3 .net provider
2. uninstall LLBL 2004
3. Install 1.7 .Net proivider
4. Install LLBL 2005
5. Regenerated all my code in LLBL

When I open the solution in VS, everything looks perfect ( the references to the firebird library all say 1.7 etc) and it compiles beautifully first time

However when I run the application it does not seem able to communicate with the database.

What have I missed?

I am using the following command to establish a connection to the database

return new DataAccessAdapter("ServerType=0;User=SYSDBA;Password=masterkey;Dialect=3;Database=" + strFileName,false);

which was working fine with 1.6.3 and LLBL 2004

Many thanks in advance

what are the errors you receive, if you receive an error at all ?

The error message when it tries to retrieve an entity is

"File or assembly name FirebirdSql.Data.Firebird, or one of its dependencies, was not found."

However the correct library (1.7) is referenced in the DatabaseSpecific project

Though at runtime you get teh exception? Could you check if the firebird assembly is actually updated in the bin folder of your application?

There is no FirebirdSql.Data.Firebird.dll in my bin directory, so I copy it in from the 1.7 installation folder and now when I run my application I get an exception:

"The located assembly's manifest definition with name 'FirebirdSql.Data.Firebird' does not match the assembly reference"

What I find strange is that when I used 1.6.3 , it was picking up the Firebird dll from the GAC... i.e. there was no need to have the file in the bin directory on the development machine....

I hope this helps

NOPE IGNORE THIS>>>>

I supidly downloaded and installed the .NET provider 1.7.1 NOT 1.7a which is what was causing my issue

Sorry

OK