We are getting following error message while trying to execute sql package thru 'ExecuteNonQuery' our .NET code.
This was working perfectly few days back, but suddenly VS2008 on our local is not able to execute the code.
We are not sure what had exactly happened here, but code stopped working on all develop machine all of sudden
Details for the error are as follows
"The provider is not compatible with the version of Oracle client" or sometimes "Typeinitializer exception"
We were using oracle.dataacess.dll version 184.108.40.206 which was working fine.It still works fine when we deploy it in the production.
We checked the GAC of the developer machines and Server,i found one difference that in the GAC of the server only the 220.127.116.11 is installed while on the developer machines,two version of oracle.client are installed in the GAC,one is 18.104.22.168 and the other is 22.214.171.124
When we run the code,it might be the case that .net framework is picking up 126.96.36.199 and that may be the problem,so we tried to include it in our project and that still gave us the same error !.We requested to uninstall 188.8.131.52 from developer machines but client refuses to uninstall that its security fix and can not remove it !
Than we thought to upgrade the version of oracle.dataacess.dll to 184.108.40.206 and code started working
View Complete Post