Oracle connection string

[Neeti]

Hi,

I am trying to add an Oracle database provider for my application in Buildmaster.

The connection string to the Oracle database. The standard format for this is:

DATA SOURCE=myServerAddress; USER ID=myUsername; PASSWORD=myPassword

I tried the following ways:

DATA Source=<value from tnsnames.ora>;USER ID=<myusername>;PASSWORD=<mypassword>;

Gave me an error:

An unexpected error occurred while attempting to connect. ORA-12154: TNS:could not resolve the connect identifier specified 

DATA Source=<server ip:port:servicename>;USER ID=<myusername>;PASSWORD=<mypassword>;

Gave an error
ORA-12545: Connect failed because target host or object does not exist

DATA Source=@<server ip:port:servicename>;USER ID=<myusername>;PASSWORD=<mypassword>;

Gave an error

An unexpected error occurred while attempting to connect. ORA-12154: TNS:could not resolve the connect identifier specified 

I am able to connect to the required Oracle through SQL Plus. So the value in tnsnames.ora in Oracle is correct.

What am I missing?

Thanks

[Neeti]

I was able to resolve this issue using this format:

DATA Source=<value from tnsnames.ora>;USER ID=<myusername>;PASSWORD=<mypassword>;

I restarted my system to restart Oracle.

Then Test Connection was successful after that.