Connect to the site database

Use the SmsDataSourceConnect function to connect to the site database that you want to access.

Currently, SMS supports one database type: Microsoft SQL Server. However, the SMS API is designed to allow support of other types of databases in the future.

The SmsDataSourceConnect function takes two parameters:

• A pointer to a DATASOURCE structure that specifies the site database to which you want to connect
• A pointer to a handle that is assigned the handle to the specified database connection. You use the handle to open containers, filter containers, and filters for that site database.

Note that your application can connect to one site database at a time.

Example:

// Function to make a datasource connection to
// a site database. This function prompts for
// SQL server, loginID, password, and database,
// and then calls SmsDataSourceConnect to get 
// a connection handle.

SMS_STATUS ConnectToSiteDatabase (HANDLE *phConnect)
                              // Pointer to handle to receive
                              // connection handle.
{

SMS_STATUS stat;

//Structure that specifies the site database to connect to.
DATASOURCE dsParams;
// Create string buffers for connecting to the database.
char szServer[33];
char szDb[31]; //maximum length of SQL Server database name is 30.
char szUser[31]; //maximum length of SQL Server Login ID is 30.
char szPasswd[31];

// Get database information from user and establish connection.
printf("Connect to site database.\n");

printf("SQL Server: ");
gets( szServer );

printf("Database: ");
gets( szDb );

printf("SQL Server Login ID: ");
gets( szUser );

printf("Password: ");
gets( szPasswd );

// Assign connection information to dsParams structure.
// The type of database.
dsParams.sqlParams.ds          = DB_SQL;
// SQL Server name.
dsParams.sqlParams.pszServer   = szServer;
// Login ID.
dsParams.sqlParams.pszUserName = szUser;
// Password for Login ID.
dsParams.sqlParams.pszPasswd   = szPasswd;
// Name of the site database.
dsParams.sqlParams.pszDbName   = szDb;
// Pointer to encryption function.
// No function is used in this example.
dsParams.sqlParams.pFunc       = NULL;
//Encryption key. No encryption key is used in this example.
dsParams.sqlParams.pszKey      = "";

// Use SmsDataSourceConnect to make a connection to the site database
// and assign the connection handle to hConnect.
stat = SmsDataSourceConnect( &dsParams, phConnect );
    
if (stat == SMS_OK) {
    printf("Connected to database %s on SQL Server %s as %s.\n",
            szDb, szServer, szUser);
}
else {
    printf("Cannot connect to SQL Server. Error code: %d\n", stat);
}

return stat;

}