Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problems with ODP For .NET 2.0 and ODBC

518078Apr 24 2007 — edited Apr 24 2007
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2007
Added on Apr 24 2007
1 comment
2,302 views