000032504 - An error occurred creating an ODBC connection for DSN in RSA Security Analytics

Document created by RSA Customer Support Employee on Aug 4, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000032504
Applies ToRSA Product Set: RSA Security Analytics 
RSA Product/Service Type:  Log Collector
RSA Version/Condition: 10.4.x,10.5.x,10.6.x
Platform: CentOS
O/S Version: EL6

 
IssueTest connection failed:Error! An error occurred creating an ODBC connection for DSN: SIte_Protector The trapped error is:
Unable to create an ODBC connection. DSN: SIte_Protector; username: admin; reason: state: 08001; 
error-code: 0; description: [RSA][ODBC SQL Server Wire Protocol driver]Invalid Connection Data”
CauseWhat causes the issue is the entry on the DSN (on the SA GUI -> event source -> ODBC -> DSN) has wrong entries
ResolutionMake sure the following entry on DSN (on the SA GUI -> event source -> ODBC -> DSN) is correct as below -
Database=<Specify the database used by RealSecure>
PortNumber=<Specify the Port Number, default is 1433>
HostName=<Specify the hostname or IP Address of RealSecure>
Driver=/opt/netwitness/odbc/lib/R3sqls26.so

Attachments

    Outcomes