Oracle Provider for OLE DB - can't connect to 11g

[Johann Schweigl]

Hi all,

I want to move things from eap files to Oracle. I installed 11g standard edition on my Win 7 box and followed the instructions on the Sparx website (BTW, it wouldn't hurt if Sparx listed required user privileges, recommended sizes for tablespaces and stuff, ...) but now I got stuck at connecting to the database.

1) Tools -> Data Management -> Project Transfer
2) Select .EAP to DBMS
3) Select Source Project
4) Select Target Project
5) Choose Oracle Provider for OLE DB
6) Enter data source, user name and password
7) Test connection
Busted! ORA-12154: TNS:could not resolve the connect identifier specified

The service name as configured in tnsnames.ora is "eastore", which I used as data source name. Maybe this is not what I am expected to enter, but I did not find any hint in EA help, here or through google.

What am I doing wrong?

[Johann Schweigl]

Solved. "hostname:port/servicename" is the format for the data source string. An example in the docs would have saved a lot of time.