我想了解如何通过VBA连接SQL Server所需的连接字符串。
这是我目前拥有的代码,
Sub ConnectSqlServer()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sConnString As String
' Create the connection string.
sConnString = "Provider=SQLOLEDB;Data Source=INSTANCE\SQLEXPRESS;" & _
"Initial Catalog=MyDatabaseName;" & _
"Integrated Security=SSPI;"
' Create the Connection and Recordset objects.
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
' Open the connection and execute.
conn.Open sConnString
'Do my stuff here
If CBool(conn.State And adStateOpen) Then conn.Close
Set conn = Nothing
Set rs = Nothing
End Sub
问题是我不知道要在连接字符串中放什么。我的完整文件路径如下。
C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\Staff_Manager.mdf
有人能告诉我需要与之配合的内容吗?
该内容涉及IT技术,下面是需要翻译的内容。"Provider"
"Source"
"Initial Catalog"
谢谢。
Data Source
需要是服务器名称,而Initial Catalog
则是您想连接的实际数据库的名称。 - Rory