OCI and executable path limitations

[pcz]

Hello

It seems that executables that use OCI have some strange limitations...
Launching exe file from directory that contains round brackets in directory name always results with ORA-12154...

Why?...

Regards
P.C.

PS. Related topic: viewtopic.php?f=5&t=33886

[AlexP]

Hello,

Please specify the exact version of the Oracle client you use. We have checked the OCI mode connection on Oracle Client 11.2.0.1 and found any problems. However, when using Oracle Client 10, if an application is in the directory incuding brackets, the application cannot connect to Oracle, as it cannot find the tnsnames.ora file. Please try moving your application to the root of any disk and running it - if the problem doesn't recur, you should update your Oracle Client

[pcz]

Hello,

Please specify the exact version of the Oracle client you use. We have checked the OCI mode connection on Oracle Client 11.2.0.1 and found any problems. However, when using Oracle Client 10, if an application is in the directory incuding brackets, the application cannot connect to Oracle, as it cannot find the tnsnames.ora file. Please try moving your application to the root of any disk and running it - if the problem doesn't recur, you should update your Oracle Client

You are right - I'm doing tests on machine with OCI 9.x.

[AlexP]

Unfortunately, old Oracle clients (up to 10 inclusively) don't work when using such a path.

[pcz]

OK
Thanks for confirmation!

[AlexP]

Feel free to contact us if you have any further questions.