ATL / WTL / STL

// m_DBConnectSettings manages a OLE connection CString (m_sInitString)
// name = m_sInitString	
// value = {0x046dfed8 "Provider=SQLOLEDB;Persist Security Info=False;User ID=xx;Password=xxxxx;Data Source=MSSQL$XXXXXLOCAL;Initial Catalog=XxxxxxxxxxXXX"}
// type = ATL::CStringT<unsigned short,StrTraitMFC_DLL<unsigned short,ATL::ChTraitsCRT<unsigned short> > >

// I X’ed out company identifying information.  The actual SQL database files are on the local machine:
//    C:\Program Files(x86)\Common Files\Company Name\Databases\MSSQL$XXXXXLOCAL\Data folder.

startTime = GetTickCount();

// Try to connect to the database.
CDBConnection DB;	// inherits from CDataSource

if( DB.Open( m_DBConnectSettings ) )	 
{
    DB.Close();
    endTime = GetTickCount();
    logStr.Format(_T("CDBEngine::InitializeDatabase DB.Open elapsedTime: %d ticks"), (endTime - startTime));
    EventLog.LogEvent(0x04, logStr);
}

// And here is CDBConnection::Open
BOOL CDBConnection::Open( const CDBConnectSettings &Settings )
{
    USES_CONVERSION;
    return( SUCCEEDED( OpenFromInitializationString(
        T2COLE((LPCTSTR)Settings) ) ) );
}