Creation of Microsoft SQL Server data source using Data Direct JDBC driver fails with error "When the instance name is specified, it is invalid to specify the port number" in TIBCO Spotfire
Article ID: KB0077025
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All Versions |
Description
When creating a data source in the Information Designer (see Creating a Data Source in Information Designer for more details) for a Microsoft SQL Server using the TIBCO Data Direct Driver and including a port number along with the instance name in the connection string, it may fail with the following error message:
[tibcosoftwareinc][SQLServer JDBC Driver]Conflicting connection information. When the instance name is specified, it is invalid to specify the port number.
Issue/Introduction
Creation of Microsoft SQL Server data source using Data Direct JDBC driver fails with error "When the instance name is specified, it is invalid to specify the port number" in TIBCO Spotfire
Resolution
To resolve this issue, remove the port number from the JDBC connection URL.The port number is not needed when a named instance (see Instance Configuration for more details on using a default versus a named instance) is provided in the connection string. The following is an example connection string for your reference.
Note: This is applicable for any JDBC connection to a Microsoft SQL Server named instance using the TIBCO Data Direct driver, including a TIBCO Spotfire Server bootstrap connection and Action Log configuration as well.
jdbc:tibcosoftwareinc:sqlserver://<host>\<instance>;databaseName=<databaseName>
Note: This is applicable for any JDBC connection to a Microsoft SQL Server named instance using the TIBCO Data Direct driver, including a TIBCO Spotfire Server bootstrap connection and Action Log configuration as well.
Additional Information
Doc: Creating a Data Source in Information Designer
External: Instance Configuration
Feedback
Yes
No
Powered by
