Product: TIBCO Spotfire®
Fail to create a new TIBCO Data Virtualization connector connection with error "Connection Failed"
When trying to create a new TIBCO Data Virtualization Connector connection receive the below error:
Below error returned in the Analyst/client "Spotfire.Dxp.SupportDiagnostics.log" file:
DEBUG Spotfire.Dxp.Data.Adapters.Composite.CompositeAdapterConnection [(null)] - Failed to connect.
Composite.Data.Common.SQLException: Connection failed ---> System.IO.IOException: Exception occurred while executing request 'handshake 3 3': Socket closed on server[ADO.NET-1906507] ---> System.IO.IOException: Socket closed on server
=================================== The above error is generally returned when the port number used is incorrect.
To verify the port number>Logon to TDV studio and navigate to Administration>Configuration>Server> Web Services Interface>Communications>HTTP> Port (on Server Restart) or Port (Current)
For e.g in the below example for the ADO.NET it will be 9400+1 i.e 9401
You may also receive this error if the TDV ADO.NET connector used is of older version. You can get the appropriate version of the drivers from the https://edelivery.tibco.com/ e.g. you can download TIB_tdv_drivers_8.2.0_all.zip for the TDV 8.2.0 ADO.NET driver.https://docs.tibco.com/pub/spotfire/general/sr/GUID-71EDC198-D037-4A3B-B296-4B3EC2CAA0CC.html