ASP is easy to use when debugging, and it is not available after release, please indicate "a higher ORACLE version is r

人生鸡蛋

Use VS2005 to make a simple query page, adjust a record through the SQL statement of the data source, and display it in GRIDVIEW.
During the production process, press F5 and everything is normal in the browser, but after generating and publishing the website, it prompts "oracle817 or higher version of ORACLE" is required.
But the oracle9i client has been installed on my machine, and it is normal during debugging.

a0a0a0a00

Do you want to copy oracle data link DLL to BIN directory


When connecting MYSQL, you need to copy the DLL he provided to the BIN directory

5954979

Is the server version of the release low, but the version on the machine you developed is high?

azuazuazu

Install the Oracle client on the server.

xing_532

Install the Oracle client on the published server.

苹果小刀

Don't understand! up

人生鸡蛋

I am developing on the server and publishing to a directory on the same machine.

德鲁伊

Hehe, what I use occasionally is SQLServer2005 which is 100% compatible

德鲁伊

==========Repost =============

problem
After installing the ASP.NET and Oracle9i client, I receive the following message when I use System.Data.OracleClient to access the Oracle database

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.


the reason
The security authentication settings of the Oracle 9i Release 2 client when installed on the NTFS partition of Windows are incorrect, causing the Authenticated Users of the machine to be unable to see the contents of the ORACLE_HOME directory; this leads to the use of System in ASP.NET with Authenticated Users permissions. The above error was reported when .Data.OracleClient connected to the Oracle database.

solve
To solve the above problems, as long as the Authenticated Users group is added the permission to access the Oracle Home directory

1.Log in to Windows with Administrator privileges.
2. Start the Window resource browser and find the ORACLE_HOME directory, such as C:\Oracle\ora92
3. Right-click the pop-up menu and select the directory sharing and security
4. Click the "Security" tab
5. Click the "Authenticated Users" item in the list of group and user names.
6. In the user's permission list, set the "Read and Run" checkbox to unchecked
7. Click the "Read and Run" checkbox again to set it to the selected state
8. Click the "Advanced" button and confirm in the permission item whether the "Authenticated Users" has the "Read and Run" permission and apply it to "This folder, subfolders and files". If not, double-click this and make sure Permissions can be "applied to" "this folder, subfolders and files". This is very important and you must check.
9. Click the "OK" button
10. Restart to make all changes take effect.

摩羯可乐

Upstairs