有关将NOTES数据存入sql server数据库的问题
代理程序如下:
Sub Initialize
Dim con As New ODBCConnection
Dim qry As New ODBCQuery
Dim result As New ODBCResultSet
Dim firstName As String
Dim lastName As String
Dim msg As String
Dim Session As New NotesSession
Dim Doc As NotesDocument
Set Doc=Session.DocumentContext
On Error Goto errorHandler
Call con.Disconnect
Set qry.Connection = con
Set result.Query = qry
Dim userName As String
Dim password As String
userName="sa"
password="sa"
If con.IsConnected Then
con.Disconnect
End If
con.ConnectTo("ds")
qry.SQL = "SELECT * FROM filesend"
result.Execute
result.AddRow
Call result.SetValue("ngr",Doc.GetItemValue("ngr")(0))
result.UpdateRow
result.Close(DB_CLOSE)
con.Disconnect
Exit Sub
errorHandler:
Messagebox result.GetExtendedErrorMessage,, result.GetErrorMessage
Exit Sub
End Sub
当运行该代理时,总是提示我“[microsoft][odbc sql server driver]连接占线导致另一个hstmt”不知道是什么问题,请高手指教!