求解,存储过程在SQL查询分析器中可以执行,但在VB工程中执行应报"连接已超时"的错误!!
代码如下:
Dim RsExport As ADODB.Recordset
Dim Execnn As New ADODB.Connection
Execnn.CursorLocation = adUseServer
Execnn.ConnectionString = StrCnn
Execnn.ConnectionTimeout = 0
Execnn.Open
Set RsExport = Execnn.Execute("SP_业绩统计")
RsExport.Close
Set RsExport = Nothing
Execnn.Close
Set Execnn = Nothing
注:存储进程"SP_业绩统计"返加记录集.在查询分析器执行需时40秒左右.请各位指点.