Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

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;
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");
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");
odbc_Error(SQL_NULL_HENV,SQL_NULL_HDBC,SQL_NULL_HSTMT);
}
st = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(void*)SQL_OV_ODBC3, 0);
if (st != SQL_SUCCESS)
{
printf("Error in SQLSetEnvAttr :: %d\n", st);
odbc_Error(henv,SQL_NULL_HDBC,SQL_NULL_HSTMT);
}
st = SQLAllocConnect(henv, &hdbc);
if (hdbc == NULL)
{
printf("Error in allocating connection Handle 1!\n");
odbc_Error(henv,SQL_NULL_HDBC,SQL_NULL_HSTMT);
}
56 Sample ODBC Application