HENV hEnv;
HDBC hDbc;
RETCODE rc;
int iOut;
char strOut[256];
char szDSN[256] = "driver={Microsoft Access Driver (*.mdb)};dbq=[c:\\eckstore.mdb];";
std::ostringstream os;
 

struct DBRESULTS
{
	std::string pf_id;
	std::string name;
	std::string name2;
	std::string description;
	int list_price;
	std::string image_file;
	int image_width;
	int image_height;
	int dept_id;
	std::string active_flag;
	std::string dropship;
	std::string keywords;
	std::string searchstring;
	std::string alt_flag;
	std::string rel_flag;
};




	


int dbinit()
{
        rc = SQLAllocEnv(&hEnv);
        rc = SQLAllocConnect(hEnv, &hDbc);
        rc = SQLDriverConnect(hDbc, NULL, (unsigned char*)szDSN, SQL_NTS, (unsigned char*)strOut, 255, (SQLSMALLINT*)&iOut, SQL_DRIVER_NOPROMPT);
        return 0;
}
 
void dbclose()
{
        rc = SQLDisconnect(hDbc);
        rc = SQLFreeEnv(hEnv);
}
 
std::string dbquery(const char* query)
{
        int ival;
        char chval[255] = "";
        int ret1;
        int ret2;
        HSTMT hStmt;
		DBRESULTS product_record;
                                                
        rc = SQLAllocStmt(hDbc,&hStmt);
        rc = SQLPrepare(hStmt,(unsigned char*)query, SQL_NTS);//1
		rc = SQLBindCol(hStmt, 1, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.pf_id = chval;
		rc = SQLBindCol(hStmt, 2, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.name = chval;
		rc = SQLBindCol(hStmt, 3, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.name2 = chval;
		rc = SQLBindCol(hStmt, 4, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.description = chval;
        rc = SQLBindCol(hStmt, 5, SQL_C_ULONG, &ival, 4, (SQLINTEGER*)&ret1);
		product_record.list_price = ival;
		rc = SQLBindCol(hStmt, 6, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.image_file = chval;
		rc = SQLBindCol(hStmt, 7, SQL_C_ULONG, &ival, 4, (SQLINTEGER*)&ret1);
		product_record.image_width = ival;
		rc = SQLBindCol(hStmt, 8, SQL_C_ULONG, &ival, 4, (SQLINTEGER*)&ret1);
		product_record.image_height = ival;
		rc = SQLBindCol(hStmt, 9, SQL_C_ULONG, &ival, 4, (SQLINTEGER*)&ret1);
		product_record.dept_id = ival;
		rc = SQLBindCol(hStmt, 10, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.active_flag = chval;
		rc = SQLBindCol(hStmt, 11, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.dropship = chval;
		rc = SQLBindCol(hStmt, 12, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.keywords = chval;
		rc = SQLBindCol(hStmt, 13, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.searchstring = chval;
		rc = SQLBindCol(hStmt, 14, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.alt_flag = chval;
		rc = SQLBindCol(hStmt, 15, SQL_C_CHAR, chval, 255, (SQLINTEGER*)&ret1);
		product_record.rel_flag = chval;
		
        rc = SQLExecute(hStmt);
        rc = SQLFetch(hStmt);
 
        if(rc != SQL_SUCCESS && rc != SQL_SUCCESS_WITH_INFO)
        {
                MessageBox(NULL, "Oops", "Error", MB_ICONEXCLAMATION | MB_OK);
                return "Error with your SQL statement.";
        }
 
        os.clear();
		os << product_record.pf_id << " || "
			<< product_record.name << " || "
			<< product_record.name2 << " || "
			<< product_record.description << " || "
			<< product_record.list_price << " || "
			<< product_record.image_file << " || "
			<< product_record.image_width << " || "
			<< product_record.image_height << " || "
			<< product_record.dropship;
        MessageBox(NULL, os.str().c_str(), "Result", 0 );

        rc=SQLFreeStmt(hStmt, SQL_DROP);
 
        return os.str();
}