Any discovery requires a painful manager, and I am discovered this bug after being tortured.
The executable is time to develop, and if you can run casually.
But when I took it into another directory, it never connects to the database.
My development tool is Delphi5, the database is Oracle9i
It reported ERRORCODE to 06421.
Searched from the Internet for a long time, I didn't find any answers ...
I only found a lot of useful from this machine, but I can't connect to Oracle, I can't connect to Oracle.
Fortunately, I finally found this damn a deep-resembled answer:
Any Oracle database cannot be connected when you contain "()" in the path to the executable. ErrorCode is 06421
Rows such as: D: / Delphi / Oracle (DEMO) /DEMO.EXE, D: / DELPHI (DEMO) / Oracle/demo.exe or
Databases when D: / DELPHI / ORACLE / DEMO (DEMO) .exe cannot be connected.
As long as you will "()", everything will return to normal.
I thought it was the problem of delphi5, so I found this problem under Delphi7.
It is also a problem with the Delphi5BDE control, and there is also a problem with ADO.
Then use PL / SQL Developer to test, plus its path "()", but also this problem, but its errorcode is ORA-12154 TNS: Unable to handle service name
So I dare to say, this is a bug of Oracle!
If you have a friend struggle on this question, then you will use this post!