MX 3.x)

Sample ODBC Application

HP NonStop Open System Services ODBC/MX Client Driver—640328-001

A-5

Execution and Testing of Sample ODBC Application

if ((st == SQL_SUCCESS) || (st == SQL_SUCCESS_WITH_INFO))

{

sprintf(szBuf," %s - [%s]\n", (char *)Err->szErrorMsg,

Err->szSqlState);

printf("%s \n",szBuf);

}

free(Err->szErrorMsg);

free(Err->szSqlState);

free(Err);

free(szBuf);

return SQL_SUCCESS;

}

int main(int argc, char *argv[])

{

RETCODEst = 0;

SQLHENVhenv = (SQLHENV) NULL;

SQLHDBChdbc = (SQLHDBC) NULL;

SQLHDBChdbc1 = (SQLHDBC) NULL;

SQLHDBChdbc2 = (SQLHDBC) NULL;

SQLHSTMThstmt = (SQLHSTMT) NULL;

SQLHSTMThstmt1 = (SQLHSTMT) NULL;

CHARCreateTable[100] = {'\0'};

CHARInsertTable[100] = {'\0'};

CHARSelectTable[100] = {'\0'};

int value;

SQLINTEGER ValInd;

SQLINTEGER RowCount = 0;

SQLINTEGER val;

SDWORD pcbValue = 0;

SQLCHAR infoValueBuf[100] = {'\0'};

SQLCHAR*infoValuePtr=0;

SQLSMALLINT StringLengthPtr = NULL;

charPassword[40]="\0";

charUserID[40]="\0";

char *serverName="TDM_Default_DataSource";

shortvalue1=10;

shortvalue2=20;

booldefaultDS=false;

printf("\n\tPURPOSE :: TO TEST ODBC API'S ON OSS ODBC

DRIVER\n\n");

Example A-3. Sample ODBC Application Code