Public Function Connect_Sql(Server As String, Database As String, User As String, Password As String, Conn As ADODB.Connection) As Boolean On Error GoTo err Set Conn = New ADODB.Connection Conn.Provider = "sqloledb" Conn.Properties("Data Source").Value = Server 'SQLServer服务器名 Conn.Properties("Initial Catalog").Value = Database 'App.Path & "\" & "phone.mdf" '数据库名 Conn.Properties("User ID").Value = User '登录用户名 Conn.Properties("Password").Value = Password '密码 Conn.ConnectionTimeout = 5 Conn.CursorLocation = adUseClient Conn.Open Connect_Sql = True Sql_F = True Exit Function err: Connect_Sql = False Sql_F = False End Function
On Error GoTo err
Set Conn = New ADODB.Connection
Conn.Provider = "sqloledb"
Conn.Properties("Data Source").Value = Server 'SQLServer服务器名
Conn.Properties("Initial Catalog").Value = Database 'App.Path & "\" & "phone.mdf" '数据库名
Conn.Properties("User ID").Value = User '登录用户名
Conn.Properties("Password").Value = Password '密码
Conn.ConnectionTimeout = 5
Conn.CursorLocation = adUseClient
Conn.Open
Connect_Sql = True
Sql_F = True
Exit Function
err:
Connect_Sql = False
Sql_F = False
End Function