Odbc03Bind.c

#include <windows.h>
#include <stdio.h>
#include <sqlext.h>
 
void main2(int argc, char *argv[])
{
   	HENV   environment = NULL; 
   	HDBC   connection = NULL; 
   	HSTMT  statement = NULL;

   	UCHAR  datasource[SQL_MAX_DSN_LENGTH] = "cpptest";
   	UCHAR  userid[13] = "sa";
   	UCHAR  password[7] = "sa";
 
   	RETCODE retcode;

 	SQLAllocEnv (&environment); 
  	SQLAllocConnect (environment, &connection);
 
 	retcode = SQLConnect (connection, datasource, SQL_NTS, userid, SQL_NTS,password, SQL_NTS);

  	if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO)
  	{
	  	printf("Baglandi.\n");
	  	
		SQLINTEGER article_id;
      	SQLINTEGER article_id_ind;
      	SQLCHAR article_title[50];
	  	SQLINTEGER article_title_ind;
	  	UCHAR  sql_select[128]= "select ArticleId,ArticleTitle from ContentArticle";
	  	retcode = SQLPrepare (statement, sql_select, sizeof (sql_select));
   	  	SQLBindCol (statement, 1, SQL_C_LONG, &article_id, sizeof(article_id), &article_id_ind);	
	  	SQLBindCol (statement, 2, SQL_C_CHAR, article_title, sizeof(article_title), &article_title_ind);	  
	  	retcode = SQLExecute (statement);
	  	printf("\n");
	  	while ((retcode = SQLFetch( statement )) != SQL_NO_DATA){  
	  	  	printf( "Makale Kim: %d Ba�l�k:  '%s'\n",article_id, article_title ); 
	    }
	    
		SQLFreeStmt (statement, SQL_DROP); 
        SQLDisconnect (connection);
	  	
  	}else{
  	  	printf("Baglanamadi.\n");
  	}
 
  	SQLFreeConnect (connection);
  	SQLFreeEnv (environment);

	getch();
}