I met a ORA-06413 mistake today!

1. A colleague has a CS program that uses an Oracle database, and the connection string is as follows:

Provider=MSDAORA.1; Password=mypassword; User Id=myuser;data source=myds

2. The application is saved in the following directory:

e:/Current work (Backup)/reference program

3. The program is written in C # of a WinForm application, the main program is an EXE file

4. When the colleague double clicks the EXE and then enters the user name and the password in the Display login window, clicks determines, appears ORA-06413 error: The connection does not open, but sqlplus can connect normally

5. Consider the issue of Provider (provider=msdaora.1), so reinstall the MDAC component, test after the installation is complete, the problem remains

6. Consider the possibility of an Oracle client and reinstall the Oracle client, the problem remains unresolved

7.google, find the following description: (http://blog.itpub.net/post/952/24354)

Error:ora 6413
Text:connection not open.
------------------------------------------------------------
Cause:unable to establish connection.
Action:use Diagnostic procedures to ascertain exact problem.


Solution Description
--------------------

are starting the application from a directory with a special
character in the name.
A Simple testcase:
Create a directory C:test (4)
Copy Odbctst.exe to this directory and start it from this directory
You'll get the ora-6413 when trying to connect to a Oracle database

The error is caused by the paranthesis in the directory name.

Remove the special characters from the directory name and everything
would work as designed.

8. In the user's e-disk and directory under the new directory WZ (E:/WZ), copy program files to the directory, run EXE file, the problem can be solved.