Multiple versions of dotConnect in productive Environment

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
romanFleischer
Posts: 18
Joined: Wed 02 Jun 2010 16:28

Multiple versions of dotConnect in productive Environment

Post by romanFleischer » Tue 14 Dec 2010 17:23

Hello,

we serve several web applications on one windows server. The older applications were developed with .NET 3.5 and dotConnect version 5.40. No changes are necessary.

The new applications were developed under .NET 4.0 (with new entity framework) and therefore the dotConnect version 5.70

If we try to serve both - we get the following error

Code: Select all

Could not load file or assembly 'Devart.Data.Oracle, Version=5.35.79.0, Culture=neutral, PublicKeyToken=09af7300eec23701' or one of its dependencies
What goes wrong? All new dlls are in the bin directory of the web application. Is it possible to use both dotConnect versions, or do we have to install the new version?

Do the older applications work also with the new dotConnect version? This means are the versions downward compatible?

Thanks in advance
Roman

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Thu 16 Dec 2010 16:36

The problem may be that assemblies from the GAC are used instead of the ones placed to the Bin folder of the site (e.g., if the old version is installed on the deployment server). Please perform the following:
1) ensure that the assemblies deployed in the Bin folder are of the proper version, i.e., 5.70.* for Devart.Data.Oracle and 5.0.93 to 5.0.143 (the exact version depends on the build number) for Devart.Data;
2) delete all policy.*.Devart.* files from the GAC;
3) check that the references set in the project lead to the Bin folder, not to the GAC, and set their 'Specific Version' property to true.

Please tell us if this helps.

romanFleischer
Posts: 18
Joined: Wed 02 Jun 2010 16:28

now another error is shown

Post by romanFleischer » Fri 17 Dec 2010 16:18

We tried to make the described changes - now we get another error when we try to create an array of types included in Davart.Data.Oracle library.
System.ArrayTypeMismatchException

But the code is simple, and works with version 5.70.

Code: Select all

var paramProfession = professionId.CreateOracleParameter("profession", OracleDbType.Integer);
List parameters = new List { paramProfession};
These are the settings we use in web.config

Code: Select all


    
          
          
     
Any idea?
Thanks
Roman

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Mon 20 Dec 2010 15:56

Could you please check under debug what versions of the Devart.Data and Devart.Data.Oracle assemblies are actually loaded for both applications? The correct versions should be:
1) Old assemblies: 5.0.40 for Devart.Data and 5.35.79 for Devart.Data.Oracle
2) Newer assemblies: 5.0.105 for Devart.Data and 5.70.152 for Devart.Data.Oracle.

Post Reply