SAP Knowledge Base Article - Public

2285427 - How to enable password encryption for Sybase ASE database connectivity in Crystal Reports?

Symptom

  • How to enable password encryption for Sybase ASE in Crystal Reports when using ODBC connection or Sybase Open Client Connection type?

Environment

  • SAP Crystal Reports 2011/2013/2016
  • Sybase ASE Database 15.X
  • Windows Operating system

Resolution

Using ODBC Driver

  • Start ODBC Data Source Administrator  32 bit (C:\Windows\SysWOW64\odbcad32.exe)
  • Create / Edit an ODBC connection using Sybase ASE driver
  • Goto Connections tab
  • Select the  Encrypt Password option

    sybase_ase_odbc.PNG

Using Sybase Open Client

  • Sybase Open Client the database driver uses %SYBASE%\%SYBASE_OCS%\ini\ocs.cfg file as a configuration file for the connection
  • Goto the following directory: %SYBASE%\%SYBASE_OCS%\ini
  • Edit the ocs.cfg file and goto the  [DEFAULT] section

[DEFAULT]

CS_SEC_ENCRYPTION=CS_TRUE

Notes for Sybase Open Client only:

  • if the ocs.cfg file does not exist in the %SYBASE%\%SYBASE_OCS%\ini directory, you may create the ocs.cfg file from the sample.cfg file by copying
  • if the [DEFAULT] section not exists in ocs.cfg you may add this section to the end of the file

Keywords

sybase, ASE, password, encryption, CR, Crystal Reports, 2013, 2011, 2016, odbc, ocs.cfg , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016