SQL Server connection string (Solved)

See more:

SQL

SQL-Server

// 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

How can I programmatically get the name of MyServerInstance?

Thanks


Solution:

I ended up using the SQLBrowseConnect[^] function through the CodeProject article SQL Server and Database Enumerator[^].

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