Function mssql2008Connect

mapmssql2008.c:230–263

Connect to db */

/* Connect to db */
static msODBCconn * mssql2008Connect(const char * connString)
{
    SQLCHAR fullConnString[1024];
    SQLRETURN rc;
    msODBCconn * conn = msSmallMalloc(sizeof(msODBCconn));

    memset(conn, 0, sizeof(*conn));

    SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &conn->henv);
    
    SQLSetEnvAttr(conn->henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);

    SQLAllocHandle(SQL_HANDLE_DBC, conn->henv, &conn->hdbc);

    snprintf((char*)fullConnString, sizeof(fullConnString), "DRIVER=SQL Server;%s", connString);

    {
        SQLCHAR outConnString[1024];
        SQLSMALLINT outConnStringLen;

        rc = SQLDriverConnect(conn->hdbc, NULL, fullConnString, SQL_NTS, outConnString, 1024, &outConnStringLen, SQL_DRIVER_NOPROMPT);
    }

    if (rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
    {
        setConnError(conn);

        return conn;
    }
 
    SQLAllocHandle(SQL_HANDLE_STMT, conn->hdbc, &conn->hstmt);

    return conn;
}

/* Set the error string for the statement execution */
static void setStmntError(msODBCconn *conn)