. NET Connectivity Oracle Problem collection

Issue 1: Hint OraOps10.dll cannot be found.

Workaround: Click Security in the properties of the Client_1 folder, and set the permissions of the authenticated users to all.

Issue 2: After obtaining the model, it is found that the obtained binary is empty.

Solution: Through a multi-party comparison, found to save the model file binary is a long raw type, and ordinary binary for the BLOB type, and through the web search, found that long Raw is an old data pattern, gradually replaced by blobs, and then directly to the long raw to blob, data download normal. Issue 3:a field in Oracle may be null if a field type is a null+ integer or null, then writing SQL is a problem. Solution: You can use NVL (attr_10041001,0) Replace null in the field with 0, at which point all null becomes 0 and of course you can NVL (attr_10041001,1) so that all null is replaced by 1. Issue 4: Ora-12514:tns:listener does not currently know of service requested in Connect Descriptor Workaround: Check that the listener is configured correctly, check W Eb.config is correct in the connection string information (Connect_data= (SERVICE_NAME=ORCL)), make sure that the DLL referenced by VS is the correct version, and that the iteration should also be noted.

Issue 5: Normal link when debugging, published to ISS but unable to link.

Workaround: In the properties of the 10.2.0 folder, click Security, set the permissions of the authenticated users to all, and click Advanced, in the Advanced security settings, select all of the bottom two check boxes, especially the last item, the brackets identified as (P), and then restart the computer. Issue 6:win7 64-bit VS2013 when connecting to Oracle, you need to modify the registry hkey_current_user/software/microsoft/visualstudio/12.0/webprojects/v use64bitiisexpress/t reg_dword/d 1
issue 7:win2008 R2 1 Install Oracle 10g 32-bit client, address: \ c \ publish file \oracle 10g 32-bit client 2 Installing the Oracle 11g 64-bit server, Address: C + + release file \oeacle 11g 64-bit server server installation address preferably before the client installation address (after the server installation address is not tested after the client installation address), the service-side password cannot start with a number. 3 Configure IIS. 4 Install framework4.0, Address: C + + release file \framework4.0 Windows server version r2, the corresponding installation software, you can download different versions on the Microsoft website. 5 release of the BS program.

. NET Connectivity Oracle Problem collection