'''Get a datetime value from Service with stored procedure The example of Stored procedure: CREATE PROCEDURE GetServerDate(@ServerDate smalldatetime output) AS set @ServerDate=GetDate() GO'''Load in VB: Private Function GetDate() As Date Dim Com As New ADODB.Command On Error GoTo Er: With Com .ActiveConnection = Cn .CommandType = adCmdStoredProc .CommandText = "GetServerDate" .Parameters .CreateParameter("@ServerDate", adDate, adParamOutput) .Execute GetDate = .Parameters("@ServerDate").Value End With Er: If Not Com Is Nothing Then Set Com = Nothing End Function Try it
The example of Stored procedure:
CREATE PROCEDURE GetServerDate(@ServerDate smalldatetime output)
AS
set @ServerDate=GetDate()
GO'''Load in VB:
Private Function GetDate() As Date
Dim Com As New ADODB.Command
On Error GoTo Er:
With Com
.ActiveConnection = Cn
.CommandType = adCmdStoredProc
.CommandText = "GetServerDate"
.Parameters .CreateParameter("@ServerDate", adDate, adParamOutput)
.Execute
GetDate = .Parameters("@ServerDate").Value
End With
Er:
If Not Com Is Nothing Then Set Com = Nothing
End Function
Try it
rs.open "exec sp_who",cn
.Parameters .CreateParameter("@ServerDate", adDate, adParamOutput)
改成:
.Parameters.Append .CreateParameter("@ServerDate", adDate, adParamOutput)