Problem: unspecified error: e_fail (0 × 80004005)

During the test, two servers were used, except for the win2kserver operating system and the win2003 Medium and Small Enterprise Edition, all the software installed were the same, mainly installed
Oracle9iclient,. Net framework1.1 + SP1
The database is on a separate server: Linux9 + oracle9.2.0
 
An error occurred.
-2147467259
System. Data. oledb. oledberrorcollection
Unspecified error: e_fail (0x80004005)
Environment Win2000 + SP4 + framework1.1 + SP1 + Oracle9i client,
Linux9 + Oracle 9.2.0

You can use the tnsping service name to ping oracle.
Use oledbconnection to create a winformProgramYou can access Oracle,
However, the ASP. Net program created using oledbconnection cannot access the database with the same connection characters,
When oledbconnection. open (), the preceding error occurs,
I started to think it is an oracle directory bin permission problem, but if it is a permission problem, you should prompt

09:35:59-2147467259
09:35:59 system. Data. oledb. oledberrorcollection
At 09:35:59, the Oracle client and network components were not found. These components are provided by Oracle and are part of Oracle 8i (or higher) client software installation.
This problem can be solved by setting permissions, so it is not the reason.

However, according to the above analysis, winform is accessible, and Asp.net is not. It should be related to permissions. Which of the following solutions can be used? Please kindly advise. Thank you.

if you use system. data. oracleconnection in the oracleclient namespace,
open () error:
cocould not create an environment: ocienvcreate returned-1.
at system. data. oracleclient. dbobjectpool. getObject (Object owningobject, Boolean & isintransaction) at system. data. oracleclient. oracleconnectionpoolmanager. getpooledconnection (string encryptedconnectionstring, oracleconnectionstring options, oracleconnection owningobject, Boolean & isintransaction) at system. data. oracleclient. oracleconnection. openinternal (oracleconnectionstring parsedconnectionstring, object TRANSACT) at system. data. oracleclient. oracleconnection. open () at webtest. webform1.button1 _ click (Object sender, eventargs E) in D: \ Asp.net \ webtest \ webform1.aspx. CS: line 56

If you use the for. Net driver provided by Oracle, an error is returned:
ORA-604: Error occurred at recursive SQL level % s
At oracle. dataaccess. client. oracleexception. handleerrorhelper (int32 errcode, oracleconnection Conn, intptr opserrctx, oposqlvalctx * poposqlvalctx, object SRC, string procedure) at oracle. dataaccess. client. oracleconnection. open () at webtest. webform1.button1 _ click (Object sender, eventargs E) in D: \ Asp.net \ webtest \ webform1.aspx. CS: line 57

Log on to the database server and check the tnsnames. ora file under Network/admin/. Compared with the previously configured Oracle, there are more domain names,
Oradata. localdomain =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.0.1) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = oradata)
)
)
Whether the domain name exists or not. It has been tested and does not affect the database startup and use.
The setting takes effect when setting the ora92/bin directory permission.
The strange problem is that it is not clear when it comes.

test on another win2003 server, regardless of how to set the Oracle/bin permissions, is an error. "An error occurs: An Oracle error occurs, however, you cannot retrieve the error information from Oracle. there is no problem accessing oracle on the net page. Check the difference.
although oledbconnection is used in the connection string, the connection characters are different.
they are:
provider = msdaora.1;
changed to
provider = oraoledb. oracle.1;
no error is reported. It is strange.
you must know that using the first string on a Win2k machine is correct.