123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- #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;
- }
|