Connect to SAP Adaptive Server

In Java application, define a URL using the SAP jConnect driver to connect to an SAP Adaptive Server.

The basic format of the URL is:

jdbc:sybase:Tds:host:port

where:

jdbc:sybase identifies the driver.
Tds is the SAP communication protocol for SAP Adaptive Server.
host:port is the SAP Adaptive Server host name and listening port. See $SYBASE/interfaces (UNIX) or %SYBASE%\ini\sql.ini (Windows) for the entry that your database or SAP Open Server application uses. Obtain the host:port from the query entry.

You can connect to a specific database using this format:

jdbc:sybase:Tds:host:port/database

Note: Connect to a specific database using SAP SQL Anywhere or DirectConnect. Use the SERVICENAME connection property to specify the database name instead of “/database.”

This code creates a connection to an SAP Adaptive Server on host “myserver” listening on port 3697:

SysProps.put("user","userid");
SysProps.put("password","user_password");
String url = "jdbc:sybase:Tds:myserver:3697";
Connection_con =
   DriverManager.getConnection(url,SysProps);