#include "StdAfx.h"
#include "DBInterface.h"

CDBInterface::CDBInterface(void)
{
}

CDBInterface::~CDBInterface(void)
{
}

/************************************************************************/
/* 
	函数:InitCatalog
	描述:初始化数据库实例连接对象;
	参数:
	返回:
	要求:
	注意:
*/
/************************************************************************/
BOOL CDBInterface::InitCatalog(IN CONST DWORD &dwCatalogPort, IN LPCTSTR lpCatalogSource, IN LPCTSTR lpCatalogAccount, IN LPCTSTR lpCatalogPsw, IN LPCTSTR lpCatalogName)
{
	if ( IsOpen() )
		return TRUE;
	
	TCHAR szSQLConnt[MAX_PATH] = _T("");
	if (dwCatalogPort)
	{
		_stprintf_s(szSQLConnt, _T("driver={SQL Server};Server=%s,%d;database=%s;uid=%s;pwd=%s"),
			lpCatalogSource, dwCatalogPort, lpCatalogName, lpCatalogAccount, lpCatalogPsw);
	}
	else
	{
		_stprintf_s(szSQLConnt, _T("driver={SQL Server};Server=%s;database=%s;uid=%s;pwd=%s"),
			lpCatalogSource, lpCatalogName, lpCatalogAccount, lpCatalogPsw);
	}

	SetConn(szSQLConnt);

	BOOL bResult = OpenCatalog();
	if( !bResult )
	{
		OutputDebugString(_T("打开数据库失败\n"));
	}

	return bResult;
}