Devart Forums

Hallo,
I've already read in the forum, but have found anything suitable for my problem. I use Delphi 2009 and Delphi XE3 under Windows 7 64 bit and ODAC 8.5.10. I use the OracleClient 9th. The installation went smoothly. The only problem is that I am in design mode does not connect to the database get (error: ORA-12154). The error occurs in both delphi versions.
Compiled programs run without problems in turn. I also use an Oracle browser, which works without problems.
Firewall and antivirus software is uninstalled. I e also tried to copy the "tnsnames.ora" file in the bin directory. unfortunately without success.
What else can I do?

Hello,

Please specify the exact version and bit count of your Oracle client. In addition, make sure that the installed client is available in design-time in the HomeName property of the TOraSession component. If the client is unavailable, its parameters could be set incorrectly in the registry and environment variables.

Hello,
the Oracle-Clientversion is 9.2.0.1.0
I can see in Orasession the home directory (OraHome92).
In Session Editor, all database servers from the tnsnames.ora are displayed.
Only if I want to connect to, then comes the error message.

Hello,

This problem is due to the fact that, when running the application that uses Oracle Client 9 from the folder which name contains special characters (brackets in particular), there occurs a problem with search for the tnsnames.ora file. Save your application in a folder which name doesn't contain such characters, and your application will be able to run from the IDE.

P.S. This is a limitation of the Oracle Client, and we cannot influence this behavior.