1.. Net Connect to the oralce Database
<Add name = "connectionstring" connectionstring = "Data Source = database name displayed on the oralce client; persist Security info = true; user id = Sid displayed on the oralce client; password = password; Unicode = true"
Providername = "system. Data. oracleclient"/>
Oracle parameters start:
2. Use ODBC oralce to connect
Select the oralce in driver, data source name is the DNS name (as required), tnsservicename is the database name displayed in the oralce client, and enter the user name and password.
Note:
1. Install oralce client 2. Add ODBC. I added System DNS 3. Program Connecting ODBC
FAQs:
1. Because of system error 5 (Oracle in orahome92), specify the driver Program Unable to load.
Folder permission problem, because ODBC needs to read the driver from the installation directory of oracle92
The IIS process account (iwap _ machine name) does not have any permissions on ora92. You can add this account.
Change method:
1. Find the installation directory of oracle92, for example, D: \ oracle \ ora92
2. View folder properties --> --〉 Security And add the iwap_user account to run the operation as long as the account has the read permission.
You can also add this account to a user group that has access to the ora92 folder, such as a system user, but it may not be safe.
