Problem with connection to EA DB

[emilion]

Hi,

I am not able to make EA to connect to DB server where our company projects are stored.
When I configure Server connection then Test Connection produces:

Microsoft Data Link Error:
Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified


System configuration:
Win 7 Enterprise x64 SP1
Enterprise Architect v7.5.
Oracle XE 10.2 client installed.

I am able to connect to the database via PL/SQL Developer.
I am able to define and connect to the datasource via ODBC Datasource Administrator (32-bit)

It looks like EA cannot find tnsnames.ora to resolve the  supplied DB alias.
Thanks in advance for any help.
Erik

[emilion]

I have found the solution to the problem.

Cause:
I've got either ORA-12154: TNS: could not resolve...
or ORA-6413: Connection not open (when I used easy connect naming "hostname:1521/servicename")

The reason is I have installed EA (32bit) on Win 7 x64 into standard folder ".../Program Files (x86)/..."
The path containing parenthesis caused the problem.

Solution:
I reinstalled EA into a folder without parenthesis.