Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

Oracle connection string using tnsnames.org



  • 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



  • 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;



  • If I use this string it returns me:

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

    What should I use instead?



Inedo Website HomeSupport HomeCode of ConductForums GuideDocumentation