OpenLink UDA Wiki Web

UdaWikiWeb.HowDoICreateAJDBCType1URLToConnectToSybaseASA

  • Topic
  • Discussion

  • How do I create a JDBC Type 1 URL to connect to Sybase ASA?

    Sybase Type 1 JDBC connection URLs take the following format:




    jdbc:openlink://ODBC[/DSN][/UID][/PWD][/READONLY]
    


    Here is a description of each of the URL parameters:



    * /DSN - Local ODBC Data Source Name that connects to a Sybase database



    * /UID - Sybase database username



    * /PWD - Sybase database password



    * /READONLY - Read-write or read-only session mode



    Here is a sample Sybase Type 1 connection URL:


    jdbc:openlink://ODBC/DSN=Local Sybase Sample DSN/UID=sa/PWD=sa