Windward DocumentationWindward DesignerDesigner for Microsoft OfficeFAQsHow Do I Connect to an Oracle Datasource with a Non-default Listener Port?

How Do I Connect to an Oracle Datasource with a Non-default Listener Port?

This article describes how to connect Report Designer to an Oracle datasource with a non-default listener port. (The default listener port is 1521.)

Check on the "Use Connection String" box in the Connection Editor, and enter a connection string that looks like:
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword; 

where MyPort is the non-default listener port.

For more details, see Connectionstrings.com.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.