SQL Server连接字符串(已解决) [英] SQL Server connection string (Solved)

问题描述

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

如何以编程方式获取MyServerInstance的名称?

谢谢


解决方案:

我最终使用了 SQLBrowseConnect [ SQL Server和数据库枚举器 [

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

推荐答案

通过以下链接进行搜索，这可能对您有帮助

在本地网络上查找SQL Server实例 [

go through the below link this may helps you

Locate SQL Server instances on the local network[^]

此处

枚举SQL Server实例(ADO.NET) [

Here

Enumerating Instances of SQL Server (ADO.NET)[^]

这篇关于SQL Server连接字符串(已解决)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！