Abah Adilah Ngeblog

DBConnect.h
#ifndef __dbconnect_h__
#define __dbconnect_h__

#import “c:\program files\common files\system\ado\msado15.dll” no_namespace rename(”EOF”, “_EOF”)

class CDBConnect {

public:
CDBConnect();
CDBConnect(const char* pr_conn_str);

void SetConnString(const char* pr_conn_str);

~CDBConnect();

void Open();
void Execute(const char* sql);
private:
char m_conn_str[255];
BOOL m_IsOpen;

_ConnectionPtr m_pCon;
};

#endif // __dbconnect_h__
DBConnect.cpp
#include “stdafx.h”
#include “DBConnect.h”

CDBConnect::CDBConnect() : m_IsOpen(FALSE) {
}

CDBConnect::CDBConnect(const char* pr_conn_str) : m_IsOpen(FALSE) {
SetConnString(pr_conn_str);
}

CDBConnect::~CDBConnect() {
if (m_IsOpen) {
m_pCon->Close();
}
}

void CDBConnect::SetConnString(const char* pr_conn_str) {
strncpy(m_conn_str, pr_conn_str, sizeof(m_conn_str));
}

void CDBConnect::Open() {
AfxOleInit();

m_pCon.CreateInstance(__uuidof(Connection));

HRESULT hr;
try
{
hr=m_pCon->Open(m_conn_str, “”,”",adModeUnknown);
m_IsOpen = TRUE;
}
catch(_com_error e)
{
//AfxMessageBox(”Connection failed, check the [...]