oracle2access.cpp

访问远程数据库MS SQLServer实例

// Oracle2Access.cpp: implementation of the COracle2Access class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Oracle2Access.h"
#include "resource.h"


#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

COracle2Access::COracle2Access(CString oraDSName,CString accessDSName,CString sampleName,int timeInterval,int connectDelay,int retryCount)
{
	m_strOraDSName = oraDSName;
	m_strAccessDSName = accessDSName;
	m_strSampleName = sampleName;
	m_iTimeInterval = timeInterval;
	m_iConnectDelay = connectDelay;
	m_iRetryCount = retryCount;
}

COracle2Access::~COracle2Access()
{

}

void COracle2Access::DataTransferForTanFen(CString tableName,CString yuanYeSampleID,CString cFenSampleID)
{
	CDatabase* pDbAccess = new CDatabase();
	CDatabase* pDbOra = new CDatabase();
	
	CString szConnString = _T("");
	try {
		szConnString = "DSN=" + m_strOraDSName + ";UID=system;PWD=manager;";
		pDbOra->OpenEx(szConnString,CDatabase::useCursorLib);

		szConnString = "DSN=" + m_strAccessDSName + ";UID=;PWD=;";
		pDbAccess->OpenEx(szConnString);
	}
	catch (CDBException* dbe)
	{
		//dbe->ReportError(MB_OK | MB_ICONERROR);
		dbe->Delete();
		pDbOra->Close();
		pDbAccess->Close();
		delete(pDbOra);
		delete(pDbAccess);
		throw CONNECTERROR;
	}

}