Need Help -- Database connectivity in C

[Sivakumar_K]

I saw the follwing coding in the forum..

But i dont know how to execute in the Turbo C compiler..

Or else we need to use seperate connectivity coding for Turbo C compiler????

Can i know the include files (Header files) for the coding given below..

-------------------------------------------------------------------------------------------------

HENV hEnv = NULL;
HDBC hDbc = NULL;
HSTMT hStmt = NULL;
UCHAR szDSN[SQL_MAX_DSN_LENGTH] = "himanshuDSN";
char szmodel[128];
char szmodel1[128];
char szmodel2[128];
SDWORD cbmodel;
SDWORD cbmodel1;
SDWORD cbmodel2;
RETCODE retcode;

//Query statement

UCHAR sql1[] = "Select subcode from registration where rollno=";
UCHAR sql2[] = "Select subcode from registration where rollno=";

int i,j,no = 1;
int rno;
char s[10];

SQLAllocEnv(&hEnv);
SQLAllocConnect(hEnv,&hDbc);

retcode = SQLConnect(hDbc,szDSN,SQL_NTS,'\0',SQL_NTS,'\0',SQL_NTS);

printf("Enter the roll no : ");
scanf("%d",&rno);
itoa(rno,s,10);
strcat(sql1,s);
if(retcode == SQL_SUCCESS|| retcode == SQL_SUCCESS_WITH_INFO)
{

retcode = SQLAllocStmt(hDbc,&hStmt);
retcode = SQLPrepare(hStmt,sql1,sizeof(sql1));
retcode = SQLExecute(hStmt);

printf("\nReading the records\n");

SQLBindCol(hStmt,no,SQL_C_CHAR,szmodel,sizeof(szmodel),&cbmodel);
//SQLBindCol(hStmt,no+1,SQL_C_CHAR,szmodel1,sizeof(szmodel1),&cbmodel1);
//SQLBindCol(hStmt,no+2,SQL_C_CHAR,szmodel2,sizeof(szmodel2),&cbmodel2);
retcode = SQLFetch(hStmt);

while(retcode == SQL_SUCCESS|| retcode == SQL_SUCCESS_WITH_INFO)
{
printf("\t%s \n",szmodel,szmodel1,szmodel2);
retcode = SQLFetch(hStmt);
}
SQLFreeStmt(hStmt,SQL_DROP);
SQLDisconnect(hDbc);
}else{
printf("Can not read the database\n");
}

SQLFreeConnect(hDbc);
SQLFreeEnv(hEnv

-------------------------------------------------------------------------------

I want to some understandable coding format with explanation!!..

Can anyone give me a suggestion?? i need it..

Thanks in advance..

[Sivakumar_K]

Can anyone provide Sql server 2000 database connectivity coding using C language..

I came to know that 16-bit compiler is not suitable..

So i am using Dev-C++ compiler..

I need coding to compile in this compiler..

I need to use this connection in employee payslip application...

Please provide with some explanation..

Thanks in advance...

[Ancient Dragon]

There are hundreds of free examples on the net, just google for "odbc c libraries". Here is just one of them

Or why not just compile the code you posted in your other thread?

[Ancient Dragon]

threads were merged.

[anu john]

Hi everyone..
i wanted to know if it is possible to connect my microcontroller to the sql server 2005 using c-language. i intend to use 8051 controller and Keil compiler for the same.Also can ne1 give me the code for the same........
plz reply.