// build the connection string TCHAR ComputerNameBuffer[MAX_COMPUTERNAME_LENGTH + 1]; DWORD ComputerNameBufferLength = MAX_COMPUTERNAME_LENGTH + 1; GetComputerName(ComputerNameBuffer, &ComputerNameBufferLength); CString ConnectionString = _T("Provider=SQLOLEDB;") _T("Integrated Security=SSPI;") _T("Initial Catalog=MyDataBase;") _T("Data Source="); ConnectionString += ComputerNameBuffer; ConnectionString += _T("\\MyServerInstance;"); // need this to be a variable
CString GetServer() { CString Server = _T(""); CSQLInfoEnumerator SQLInfoEnumerator; SQLInfoEnumerator.EnumerateSQLServers(); for (INT_PTR i = 0; i < SQLInfoEnumerator.m_szSQLServersArray.GetSize(); ++i) { SQLInfoEnumerator.EnumerateDatabase(SQLInfoEnumerator.m_szSQLServersArray[i], _T(""), _T("")); for (INT_PTR j = 0; j < SQLInfoEnumerator.m_szSQLServerDatabaseArray.GetSize(); ++j) { if (SQLInfoEnumerator.m_szSQLServerDatabaseArray[j] == _T("MyDataBase")) { Server = SQLInfoEnumerator.m_szSQLServersArray[i]; break; } } } return Server; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)