我正在尝试使用MS Excel中的ODBC Build 与MS SQL Server的连接 .
当我尝试通过VBA连接时,我收到 Server is not found or not accessible
错误 .
从SQL Server Management Studio 2012查看的连接详细信息如下图所示 . (要访问此连接,我将VPN连接到网络,然后使用我的Windows凭据与服务器计算机 Build 远程桌面连接 . )
在我的VBA连接字符串中,我尝试了以下所有内容,它们都会产生相同的错误 . 构建此连接字符串的适当方法是什么?
Public Const connString1 = "Driver={ODBC Driver 13 for SQL Server};" _
& "server=SBCG-DW.semlerbrossy.com;" _
& "database=competitive_data;" _
& "Uid=rgrady; Pwd=MYPWD;"
Public Const connString2 = "Driver={ODBC Driver 13 for SQL Server};" _
& "server=SBCG-DW.semlerbrossy.com;" _
& "database=competitive_data;" _
& "Uid=SEMLERBROSSY\RGrady; Pwd=MYPWD;"
Public Const connString3 = "Driver={ODBC Driver 13 for SQL Server};" _
& "server=192.168.168.254;" _
& "database=competitive_data;" _
& "Uid=rgrady; Pwd=MYPWD;"
Public Const connString4 = "Driver={ODBC Driver 13 for SQL Server};" _
& "server=[SERVER IP ADDRESS];" _
& "database=competitive_data;" _
& "Uid=SEMLERBROSSY\RGrady; Pwd=MYPWD;"
Public Const connString5 = "Driver={ODBC Driver 13 for SQL Server};" _
& "server=SBCG-DW\SBCG_SQL_DB;" _
& "database=competitive_data;"