tfsrdbc/rdbcTfsAllocDefault.c

#include "sqlrtypes.h"
                                                    
#include <stdio.h>
                                                    
 
RDM_RETCODE exampleTfs_rdbcTfsAllocDefault (const char *databaseName)
{
RDM_RETCODE rc = sOKAY;
RDM_TFS tfs;
SQLRETURN ret;
    SQLHENV hEnv;
    SQLHDBC hDbc;
char connectStrIn[255];
char connectStrOut[255];
SQLSMALLINT outLen;
 
/* This creates a default TFS handle */
                                                    
    rc = rdm_rdmAllocTFS (&tfs);
if (rc == sOKAY)
    {
        rc = rdm_tfsInitialize (tfs);
if (rc == sOKAY)
        {
            ret = SQL_SUCCESS;
        }
else
                                                    
        {
rdm_tfsFree (tfs);
            ret = SQL_ERROR;
        }
    }
 
if (SQL_SUCCEEDED (ret))
    {
        ret = SQLAllocHandle (SQL_HANDLE_ENV, NULL, &hEnv);
if (SQL_SUCCEEDED (ret))
        {
            ret = SQLAllocHandle (SQL_HANDLE_DBC, hEnv, &hDbc);
if (SQL_SUCCEEDED (ret))
            {
/* Pass the TFS handle to the ODBC driver */
                                                    
                ret = SQLSetConnectAttr (
                    hDbc, SQL_ATTR_RDM_TFS_HANDLE, (SQLPOINTER) tfs,
SQL_IS_POINTER);
if (SQL_SUCCEEDED (ret))
                {
/* Connect to the TFS and open the database */
                                                    
                    sprintf (connectStrIn, "databases=%s", databaseName);
                    ret = SQLDriverConnect (
                        hDbc, NULL, (SQLTCHAR *) connectStrIn, SQL_NTS,
                        (SQLTCHAR *) connectStrOut, sizeof (connectStrOut),
                        &outLen, SQL_DRIVER_NOPROMPT);
if (SQL_SUCCEEDED (ret))
                    {
                        (void) SQLDisconnect (hDbc);
                    }
else
                                                    
                    {
SQLINTEGER native;
                        (void) SQLGetDiagRec (
SQL_HANDLE_DBC, hDbc, 1, NULL, &native, NULL, 0,
                            NULL);
                        rc = (RDM_RETCODE) native;
                    }
                }
 
                (void) SQLFreeHandle (SQL_HANDLE_DBC, hDbc);
            }
 
            (void) SQLFreeHandle (SQL_HANDLE_ENV, hEnv);
        }
 
        (void) rdm_tfsFree (tfs);
    }
return rc;
}