#include "DLodbc.h"

void main()
{
	int nRtn;
	DLodbc dlodbc;
	SQLHDBC hdbc;
	SQLHSTMT statement;
	long rs_type = 1003, rs_concur = 1008;
	SQLCHAR	sql[40]="select * from CA_TEST";
	SQLSMALLINT ColumnCnt;

	SQLCHAR *datavalue=NULL;
	SQLINTEGER datalen;

	unsigned char	databasename[30]="fgog";
	unsigned char	username[30]="ca";
	unsigned char	password[30]="fourgold";

	hdbc=dlodbc.ConnectDB(databasename, 4, username, 2, password, 8);

	statement = dlodbc.CreateStatement(hdbc,rs_type,rs_concur);

	nRtn = dlodbc.ExecSQL(statement,sql,strlen((char *)sql));
	if(nRtn > 0)
		do{
			ColumnCnt = dlodbc.GetColumnCount(statement);
			for(SQLSMALLINT i=0;i<ColumnCnt;i++)
			{
			//	SQLGetData(statement,i,SQL_C_CHAR,datavalue,40,&datalen);
				datavalue = dlodbc.getData(statement, i, datalen);
				printf("%s\t",datavalue);				
			}
			printf("\n");
		}while(dlodbc.NextCursor(statement));
	dlodbc.FreeStatement(statement);
	dlodbc.free_connect_handle(hdbc);
}