"ORACLE" Precautions in use (ii)

Problem 1:oracle when inserting data, sometimes Chinese becomes?????

Cause: Chinese characters are garbled because the character set of the current computer and the character set on the server are inconsistent.

Solution: Set environment variables on the currently used computer

On my Computer right-click Properties-Advanced system Settings-advanced-environment variables, new user variables:

Variable name = variable Value:

Lang=zh_cn. GBK

Nls_lang=simplified Chinese_china. Zhs16gbk

Set nls_lang= "Simplified Chinese" _china.zhs16gbk

Issue 2: Run in 64-bit mode with 32-bit Oracle client components installed

Error message:

The data connection is unsuccessful, check that the database is started when attempting to load an Oracle client when BadImageFormatException is raised. This issue occurs if you run in 64-bit mode with the 32-bit Oracle client component installed.

Solution:

Solution:

1. IIS--"Application pool

2. Advanced Settings

3. Enable 32 to change the application pool to True

Issue 3: BadImageFormatException is raised when attempting to load the Oracle client library. Issue record

Problem description: PL/SQL is installed on a 64-bit PC and you want to connect a 64-bit database, you need to install a 32-bit client. This problem may occur if you use the Lite client "Intantclient". Lite client, only OCI.dll and some class libraries. Use this to enable the Plsql to connect to the Oracle database. But when you use ASP. NET to connect to Oracle, you get an error. "BadImageFormatException is raised when attempting to load the Oracle client library. This problem occurs if you are running in 64-bit mode with the 32-bit Oracle client component installed.

Solution: Install the full version of the client, about two hundred or three hundred m. Then in the operation of problem 2 , you can.

Problem 4:plsql Login error, initialization error SQL *net notproperly installed

Solution:

Solution:

1. Install Oracle Client

2. Configuring PL/SQL Software

Open Plsql Software-"Click to cancel Login-" Enter Plsql Main Page-"Menu bar Tool-" preferences--"connection-" Oracle home, OCI library configuration

If the Oracle client has this item installed in the folder.

"ORACLE" Precautions in use (ii)