PB6.5 connection ORACLE8I problems! Tip: always connet to the database ORA - 06413: connection is not open!
Please give to solve! This problem bothering me for a long time! Please help solve, high consult!

CodePudding user response:

Recommended upgrade PB version a try

CodePudding user response:

Today met ORA - 06413 error! Collection
1. A colleague had a cs program that USES the oracle database, the connection string as follows:

The Provider=MSDAORA. 1; Password=mypassword; User ID=myuser; The Data Source=myds

2. The application is saved in the following directory:

E: the current working reference program (backup) \ \

3. The program is written in c # winform application, the main program is an exe file



4. Double-click the exe then when colleagues in the display window enter the user name and password to log in, click ok, ORA - 06413 error: connection is not open, but up sqlplus can normal connection

5. Consideration is the issue of the Provider (the Provider=MSDAORA. 1), so I reinstalled MDAC components, test after the installation is complete, the question remains

6. Consider the oracle client might be the problem, reinstall the oracle client, the problem still not solve the

7. Google it and 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 the diagnostic procedures to ascertain exact problem.


The Solution Description
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

You 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 will get the ora - 6413 the when trying to connect to an oracle database

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

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


8. In the user's e dish with directory wz new directory (e: \ wz), copy the program files to the directory and run the exe file, problem solved!

CodePudding user response:

http://blog.csdn.net/zhpsam109/archive/2006/03/08/618860.aspx

CodePudding user response:

Don't know how to write your link statement, question is sure to link with your statement, the system provides a default transaction object sqlca, did you use your own link object?
Here to provide a correct writing:
The sqlca. DBMS="o73 oracle 7.3"
The sqlca. Logpass="* * * *"
The sqlca. Servername="@ dbserver"
The sqlca. Logid="* * * *"
The sqlca. The autocommit=dasle
The sqlca. Dbparm=""

Connect using the sqlca;

CodePudding user response:

The client has a see ORA client

CodePudding user response:

You are in error encountered in the development or deployment to meet?

CodePudding user response:

The database registered?

CodePudding user response:

Up sqlplus can normal connection?

CodePudding user response:

reference 4 floor larkonmaple response:

don't know how to write your link statements, questions must link with your statement, the system provides a default transaction object sqlca, did you use your own link object?
Here to provide a correct writing:
The sqlca. DBMS="o73 oracle 7.3"
The sqlca. Logpass="* * * *"
The sqlca. Servername="@ dbserver"
The sqlca. Logid="* * * *"
The sqlca. The autocommit=dasle
The sqlca. Dbparm=""

Connect using the sqlca;

I am using the SQLCA, oneself is not new.

CodePudding user response:

refer to the eighth floor sjq521521 response:

up sqlplus can normal connection?

It's normal

CodePudding user response:

reference 1st floor smilysoft response:

suggest upgrade PB version try

Temporarily can only use this version.