Oracle connection string using tnsnames.org

[giacomo]

Dear all,
this is my tnsnames.ora file:

TEST =
 ( DESCRIPTION=
  (ADDRESS=(PROTOCOL=tcp)(HOST=oratt.example.local) (PORT=1521))
  (CONNECT_DATA=
   (SERVICE_NAME=orl.example.local))
)

Using these parameters how am I supposed to set up my Oracle connection string?
Thanks for helping me

Product: BuildMaster
Version: 5.3.4

[Alana]

This takes a standard .NET connection string; you can find a reference on .NET Framework Data Provider for Oracle connection strings.

Here is an example of the TNS Name format, that I think might work

SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
uid=myUsername;pwd=myPassword;

[giacomo]

If I use this string it returns me:

System.ArgumentException: 'server' is not a connection attribute valid.

What should I use instead?