Configuring Data Source Names

Configuring a Data Source Name (DSN) on a Windows computer makes that DSN available for use by third-party tools.

  1. Start the ODBC Data Source Administrator utility.
    1. On a 32-bit Windows system, select Windows Control Panel > Adminstrative Tools > Data Sources (ODBC) .
    2. On a 64-bit Windows system, go to C:\Windows\SysWOW64 and doubleclick odbcad32.exe.
    The ODBC Data Source Administrator menu is displayed.
  2. Click Add.
    The Create New Data Source menu is displayed.
  3. Select Sybase ESP ODBC Driver and click Finish.
    The SYBASE ODBC DRIVER ANSI screen is displayed.
  4. In the Data Source field, enter the name you wish to use for this data source.
  5. In the Ws/Proj[/Auth] field, enter the name of the workspace followed by a slash and the name of the project. If you are using Kerberos authentication, add /krb after the project name. If you are using RSA authentication, add /rsa/ followed by the full path (such as C:/home/mykey.private) of your RSA key file.
  6. In the Server field, enter the name of the node in the cluster on which the specified project is running.
  7. In the User Name field, enter the loginid that you use when accessing that node.
  8. In the Description field, describe the data available from this source.
  9. In the Ssl Mode field, enter require if the cluster uses SSL or disable if it doesn't.
  10. In the Port field, enter the port to use when communicating with the specified node.
  11. In the Password field, enter the password for the userid you use when accessing the specified node.
  12. Click OK to dismiss that screen and click OK again to dismiss the ODBC Data Source Administrator screen.