IBM Support

"Internal network error, session aborted, connection closed" error when connecting to Salesforce.com source

Technote (troubleshooting)


Problem(Abstract)

When trying to import data housed in Salesforce.com into SPSS Statistics Client, the following error is displayed:

SQLDriverConnect failed: [IBM SPSS][ODBC SPSS Salesforce.com ODBC Client driver][SPSS Salesforce.com ODBC Client] Internal network error, session aborted, connection closed

Symptom

Unable to connect to Salesforce.com to retrieve existing data into SPSS Statistics Client.


Cause

Configuration of the Salesforce.com ODBC DSN was incorrect.

Environment

Windows 7 64-bit Operating System
SPSS_DataAcessPack_Salesforce_Client_win64 6.0 installed
SPSS_DataAcessPack_Salesforce_Server_win 6.0 installed

Diagnosing the problem

If SPSS Statistics Client is installed as a 64-bit version and Salesforce.com ODBC driver 6.0 is being used, ensure that the Client AND Server version of the driver is installed.

In the ODBC DSN administration tool of Windows, click on the ellipses button for the field 'Server Data Source' and the same error message is displayed.

This rules out SPSS Statistics as the root cause and the underlying problem is with the current configuration of the ODBC DSN definition.

Resolving the problem

Ensure the field "Salesforce Service Host" contains the machine housing the Salesforce Server service. This service can be installed on the same machine housing the Salesforce Client driver (which also houses SPSS Statistics Client) or on a separate machine.

If SPSS Statistics Client, Salesforce Client and Salesforce Server installations are present on the same machine, you can use the value of 'localhost' in the "Salesforce Server Host" field.

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics
Statistics Desktop

Software version: 22.0

Operating system(s): Windows

Reference #: 1690531

Modified date: 07 September 2016


Translate this page: