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..

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...

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?

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.

This article has been dead for over six months. Start a new discussion instead.