Making local ODBC connections to SMA servers

solidDB Help : Programming : Deploying SMA and LLA applications : Deploying SMA applications : Establishing local connections for SMA applications : Making local ODBC connections to SMA servers

To make a local (non-RPC-based) ODBC connection to the SMA server, you must connect to a SMA server by using a connection string that uses the following syntax:

sma protocol-name port-number-or-pipe-name

For example:

sma tcp 2315

Where you define the SMA connect string depends upon the API or driver manager:

▪ ODBC API: When using the ODBC API, define the SMA-specific connect string in the SQLConnect function call.

For example, the following ODBC API code connects directly to the local SMA solidDB server with user name dba and password dba:

rc = SQLConnect(hdbc, "sma tcp 1315", (SWORD)SQL_NTS, "dba", 3, "dba", 3);

▪ SA API: When using the SA API, define the SMA-specific connect string in the SaConnect function call.

For example, the following code example connects directly to the local SMA solidDB server with user name dba and password dba:

SaConnectT* sc = SaConnect("sma tcp 1315", "dba", "dba");

▪ Driver manager: When using a driver manager, define the SMA-specific connect string as the data source in the driver manager.

Go up to

Establishing local connections for SMA applications