MX Release 3.2.1 (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

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[])

{

RETCODE st = 0;

SQLHENV henv = (SQLHENV) NULL;

SQLHDBC hdbc = (SQLHDBC) NULL;

SQLHDBC hdbc1 = (SQLHDBC) NULL;

SQLHDBC hdbc2 = (SQLHDBC) NULL;

SQLHSTMT hstmt = (SQLHSTMT) NULL;

SQLHSTMT hstmt1 = (SQLHSTMT) NULL;

CHAR CreateTable[100] = {'\0'};

CHAR InsertTable[100] = {'\0'};

CHAR SelectTable[100] = {'\0'};

int value;

SQLINTEGER ValInd;

SQLINTEGER RowCount = 0;

SQLINTEGER val;

SDWORD pcbValue = 0;

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

SQLCHAR*infoValuePtr=0;

SQLSMALLINT StringLengthPtr = NULL;

char Password[40]="\0";

char UserID[40]="\0";

char *serverName="TDM_Default_DataSource";

short value1=10;

short value2=20;

bool defaultDS=false;

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

DRIVER\n\n");

if(argc>1)

{

if(!strcmp(argv[1], "-help"))

{

printf("USAGE: odbcdemo <DataSourceName> \n");

printf("Eg: odbcdemo DEMO\n");

printf("Note: Default Data Source will be used in case no DS

specified!\n");

return 0;

}

serverName = argv[1];

}

printf("User Name: ");

scanf("%s", UserID);

printf("Password : ");

scanf("%s", Password);

strcpy(CreateTable,"create table GGTest(c1 int)");

sprintf(InsertTable, "%s %d %s", "insert into GGTest(c1) values

(", value1, ");");

strcpy(SelectTable,"select * from GGTest" );

printf("\n\tUsing Data Source : %s \n\n", serverName);

if (!strncmp(serverName, "TDM_Default_DataSource",

strlen(serverName)))

defaultDS = true;

st = SQLAllocEnv(&henv);

if (henv == NULL)

{

printf("Error in allocating Env Handle!\n");

40 Sample ODBC application