1978931 - Error: "Logon Failed. Host not found", when attempting to connect to Salesforce.com from Crystal Reports

SAP Knowledge Base Article - Public

1978931 - Error: "Logon Failed. Host not found", when attempting to connect to Salesforce.com from Crystal Reports

Symptom

  • Unable to connect to Salesforce.com
  • Can successfully connect to Salesforce.com from other computers.
  • Error: "Logon failed. Error: 'HY000:Host not found'", when attempting to connect to Salesforce.com
  • When attempting to connect to Salesforce.com from Crystal Reports, it fails with the following errors:
      
       "Logon failed."
          
       "Database Connector Error: 'HY000:Host not found'"
                   
        "Logon failed.
        "Details: IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnect Attr failed"
       
        Salesforce - Error - 01.png
       
        Salesforce - Error - 02.png
         
        Salesforce - Error - 03.png 

         

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
       
  • Salesforce.com

Reproducing the Issue

  1. Start Crystal Reports
  2. Create new blank report, and in the "Database Expert", select "Salesforce.com"
  3. Enter the Salesforce.com user credentials and click "OK"
         
    It fails with the error:
          
    "Logon failed. 
     Details: IM006:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnect Attr failed."

Cause

  • It fails because there is a Proxy configured on the network to connect to the Internet, and the proxy setting is not added to the Salesforce.com connection.

Resolution

  • To add the proxy setting to the Salesforce.com connection for Crystal Reports:
      
    1. Navigate to the location of CRConfig.xml file, which is located by default at:
        
        C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\
           
    2. Open the CRConfig.xml file in a text editor like Notepad.
         
    3. Add the following lines to the <SForce> section of the XML file, with your proxy settings:

     <UseProxy>TRUE</UseProxy> 
     <ProxyAddress> Add the proxy name here </ProxyAddress>
     <ProxyPort> Add the proxy port number here </ProxyPort>
    
   
Below is an example of how the xml file will look after adding the proxy setting for the Salesforce.com connection,
if the proxy name is: MyProxy, and the port number: 1234

    
     <SForce>
        <UseProxy>TRUE</UseProxy>
              <ProxyAddress>MyProxy</ProxyAddress>
              <ProxyPort>1234</ProxyPort>
              <CacheRowSetSize>100</CacheRowSetSize>
              <QueryBatchSize>2000</QueryBatchSize>
              <SocketTimeout>600000</SocketTimeout>
              <BatchLookupCacheJoinSize>200</BatchLookupCacheJoinSize>
     </SForce>

Keywords

proxy configuration, Internet Options, SQLSetConnectAttr, IM006, CR , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Attachments

SFDCerror.JPG