Problems with ODP For .NET 2.0 and ODBC
518078Apr 24 2007 — edited Apr 24 2007I have a quite odd trouble. I'm doing mantainance to an application partialy developed in .NET and Genexus.
The modules in .NET access the database through ADO.NET using Oracle Data Provider, and the modules in Genexus use ODBC.
Recently, we've migrated the application from .Net framework 1.1 to 2.0, thus, he had to change the data provider to the one which works with the .NET framework 2.0. (I think it's ODP v10.20.2, right?)
In order to update the aplication at our customers' , a proccess that do all the installations and updates required is run. In this case, we changed this program to automatically install this new version of ODP performing a silent installation using a response file as specified by oracle.
The problem is that having installed ODP 10 for .Net 2.0 silently, the ODBC connection doesn' work anymore. This doesn't happen if the ODP is installed in interactive mode.
If a clic on "Test connection" at the ODBC connection manager I get the following error:
Unable to connect.
SQLState = IM004
[Microsoft][Administrador de controladores ODBC] Error de SQLAllocHandle del controlador en SQL_HANDLE_ENV
Is there anyone who has experienced this before? Could anyone give me a clue on how to workaround this?
Thanks a lot in advance.
Regards,
Gonzalo