// SQLServer.cpp: implementation of the SQLServer class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "數據庫設置.h"
#include "SQLServer.h"

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

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

SQLServer::SQLServer()
{

}

SQLServer::~SQLServer()
{

}

CString SQLServer::GetServer()
{
	CString str;
	str=this->GetString("Driver={SQL Server}","SERVER");
	return str;
}

CString SQLServer::GetDataBase(CString sServer)
{
	CString str;
	CString sString;
	sString.Format("Driver={SQL Server};SERVER=%s;UID=sa;PWD=",sServer);
	str=this->GetString(sString,"DATABASE");
	return str;
}

CString SQLServer::GetString(CString sSQLChar,CString cKey)
{
	SQLHENV hSqlHenv;
	SQLHDBC hSQLHdbc;
	short sConnStrOut;
	CString Returnstr;
	//分配環境句柄
	int IsSuccess=SQLAllocHandle(SQL_HANDLE_ENV,SQL_NULL_HANDLE,&hSqlHenv);
	if (IsSuccess == SQL_SUCCESS || IsSuccess == SQL_SUCCESS_WITH_INFO)
	{
		//設置環境屬性
		IsSuccess = SQLSetEnvAttr(hSqlHenv, SQL_ATTR_ODBC_VERSION, (void *)SQL_OV_ODBC3, 0);
		if (IsSuccess == SQL_SUCCESS || IsSuccess == SQL_SUCCESS_WITH_INFO) 
		{
			//分配一個連接句柄
			IsSuccess = SQLAllocHandle(SQL_HANDLE_DBC, hSqlHenv, &hSQLHdbc);
			if (IsSuccess == SQL_SUCCESS || IsSuccess == SQL_SUCCESS_WITH_INFO) 
			{
				CString szConnStrOut;
				//調用SQLBrowseConnect
				IsSuccess =SQLBrowseConnect(hSQLHdbc, (SQLCHAR *)sSQLChar.GetBuffer(sSQLChar.GetLength()), SQL_NTS,(SQLCHAR *)(szConnStrOut.GetBuffer(4824)), 4824, &sConnStrOut);
				szConnStrOut.ReleaseBuffer();
				int nPos=szConnStrOut.Find(cKey);
				if(nPos!=-1)
					nPos=nPos+cKey.GetLength();
				int nBegin=szConnStrOut.Find("{",nPos+1);
				int nEnd=szConnStrOut.Find("}",nPos+1);
				Returnstr=szConnStrOut.Mid(nBegin+1,nEnd-(nBegin+1));
			}
		}
	}
	return Returnstr;
}