sougatamondal / migratordotnet

Automatically exported from code.google.com/p/migratordotnet
0 stars 0 forks source link

Exception when using another Oracle Data Provider version #105

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Run nant task using when you have ODP version 2.102.2.20
2.
3.

What is the expected output? What do you see instead?
Expected: migrate from one version to another
Instead: 
System.Reflection.TargetInvocationException: Exception has been thrown by 
the target of an invocation. ---> 
System.Reflection.TargetInvocationException: Exception has been thrown by 
the target of an invocation. ---> System.IO.FileNotFoundException: Could 
not load file or assembly 'Oracle.DataAccess, Version=2.111.5.10, 
Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its 
dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, Version=2.111.5.10, Culture=neutral, 
PublicKeyToken=89b483f429c47342'

What version of the product are you using? On what operating system? With 
what .NET implementation/version?
migratordotnet 0.8
windows vista, dotnet 3.5, vs2008 sp1

What database and version are you seeing this issue on?
oracle xe 10.2.0.1.0
ODP 2.102.2.20

Please provide any additional information below.
I took a look into the source code and I can see that you are referencing 
the Oracle.DataAccess directly in the project file. The problem is that 
doing like this you are binding Migrator.net to the dll's version 
(2.111.5.10). One alternative to that is to load the assembly using 
reflection so we could use any Oracle.DataAccess version (in my case 
2.102.2.20).

Original issue reported on code.google.com by andrecar...@gmail.com on 9 Apr 2009 at 5:55