Solution to the connection problem between ORACLE920 and ASP

Solution to the connection problem between ORACLE920 and ASP

The code is as follows:
<%
On error resume next
'Connect to the database

Set OraSession = CreateObject ("OracleInProcServer. XOraSession ")
Set oradatabase = orasession. dbopendatabase ("database name", "user name/password", 0)

'Error handling
If err. number> 0 then
Response. Write "Response. Write "asp error Source:" & err. Source & "<br>"
Response. Write "asp error code:" & err. number & "<br>"
Response. Write "asp error Description:" & err. Description & "<br>"
Err. Clear
Response. Write "Response. Write "ORACLE error code" & OraSession. lastServerErr & "<br>"
Response. Write "ORACLE error description" & OraSession. lastServerErrtext & "<br>"
CloseDatabase
Displayerror
Response. end
End if

'Close the database
Sub closeDatabase ()
Oradatabase. close
'Set oradatabase = nothing
Orasession. close
Set orasession = nothing
End sub

Function displayerror ()
If err. number <> 0 then
Response. Write "<br> <p align = center fontsize = 20> database connection failed. Contact the system administrator! </P>"
Response. End
End if
End function

%>

Solution:

1. When IIS accesses the ORACLE database, it assigns a permission (oracle bug) to OLEDB)
Add/edit the "Authenticated Users" user in the attributes of the ORA92 directory under the ORACLE_HOME Directory. Click "Read and run" first, and then click "select, then "application ".

2. There is a "sqlnet. ora" file in the ORA92etworkADMIN directory under the ORACLE_HOME directory,
The content is as follows:

# SQLNET. ORA Network Configuration File: E: oracleora92etworkadminsqlnet. ora