I'm using asp.net (c#) framework version 1.1 and trying to connect to my Oracle database 10G (10.1.0.2.0) which installed on the same server as the IIS and I'm getting the following error:
OleDbException (0x80004005): error while trying to retrieve text for error ora 01019
I can connect through sqlplus and I did give aspnet user full control on my Oracle_Home.
In addition I defined the ORACLE_HOME in the system environment and in the system PATH.
although I had few oracel version installed I removed them all (from the registery as well) and now I only got this 10G as my only Oracle_Home.
this is the code I'm using for openning the db connection:
string constr = "Provider=MSDAORA.1;Data Source=wstdb;User Id=stdb;PASSWORD=stdb;OLE DB Services=-2";
OleDbConnection conn = new OleDbConnection(constr);
I got the error while opening the connection.
I realy need help.