Odbc02Get.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_direct[128]= "select * from ContentArticle where AuthorId=1";
	 	retcode = SQLExecDirect(statement,sql_select_direct,SQL_NTS );
	  	printf("\n");
	  	while ((retcode = SQLFetch( statement )) != SQL_NO_DATA){  
		  	SQLGetData(statement, 1, SQL_C_LONG, &article_id, sizeof(article_id), &article_id_ind);
		  	SQLGetData(statement, 2, SQL_C_CHAR, article_title, sizeof(article_title), &article_title_ind);
		  	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();
}