Establishing remote connections

SMA and LLA Guide : Creating and running remote or dual-mode applications : Establishing remote connections

When you establish a remote connection, the application calls to the server go through the network rather than use the direct function calls to the SMA or LLA library.

ODBC API

With the ODBC API, to establish a remote connection, the application calls the SQLConnect function with the name of the remote server.

Example

The following ODBC API code example connects to a remote solidDB^® server with username dba and password dba. In this example, the network protocol that the client and server use is “tcp” (TCP/IP). The server is named “remote_server1” and the port that it listens on is 1313.

rc = SQLConnect(hdbc, "tcp remote_server1 1313", (SWORD)SQL_NTS, "dba", 3, "dba", 3);

SA API

With the SA API, to establish a remote connection, the application calls the SaConnect function with the name of the remote server.

Example

In this example, the network protocol that the client and server use is “tcp” (TCP/IP). The server is named “remote_server1” and the port that it listens on is 1313.

SaConnectT* sc = SaConnect("tcp remote_server1 1313", "dba", "dba");

JDBC

With JDBC, to establish a remote connection, the name of the remote server is defined in the connect string.

jdbc:solid://<hostname>:<port>