sql连接问题,为什么客户端两个用户同时查询就不可以?
'执行sql语句并返回adodb.recordset值
Public Function ExecuteSql(ByVal sql As String) As ADODB.Recordset
On Error GoTo Errormsg
Dim sqlcon As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
sqlcon.Provider = "sqloledb"
sqlcon.Properties("Data Source").Value = ServerDb '// SLMAIL 为SQL Server 服务器名
sqlcon.Properties("Initial Catalog").Value = Database '//已创建数据库名
sqlcon.Properties("persist security info").Value = "False"
sqlcon.Properties("user id").Value = SqlUserId
sqlcon.Properties("password").Value = SqlPassword
sqlcon.Open
cmd.ActiveConnection = sqlcon
cmd.CommandText = sql
Set ExecuteSql = cmd.Execute
'sqlcon.Close
If 1 <> 1 Then
Errormsg: MsgBox Error
End If
End Function
这个是我用的sql连接。为啥客户端2个人同时用就不行呢。必须一个人查询完毕。另外一个人才可以查询。。该怎么改一下?