Not enough storage is available to complete this operation error
Hi I have the following code:
VB Code:
Function RunFODBPackage(ByVal SQLString As String, ByVal BindVars As String) As ADODB.Recordset
'###############################################################################
' Description : XXX
'
' Return : An ADO record set.
'###############################################################################
Dim lrs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim stream As ADODB.stream
Dim streamOut As ADODB.stream
If basADO_Tools.OpenDBConn(gconnfodb, basGlobal.GetConnectionString("RESEARCH")) Then
'Retrieve the file and update the parameter value
Set stream = New ADODB.stream
stream.Charset = "iso-8859-1"
stream.Type = adTypeText
stream.Open
Set streamOut = New ADODB.stream
streamOut.Charset = "iso-8859-1"
streamOut.Type = adTypeText
streamOut.Open
'stream.WriteText BindVars, adWriteLine
stream.LoadFromFile ("c:\BindVars.xml")
Set cmd = New ADODB.Command
gconnfodb.CursorLocation = adUseServer
With cmd
Set .ActiveConnection = gconnfodb
.Properties("SPPrmsLOB") = True
.CommandText = "PK_XML_UTILITIES.P_GET_XML"
.CommandType = adCmdStoredProc
.Parameters.Append cmd.CreateParameter("PV_QUERY", adVarChar, adParamInput, 8000, SQLString)
.Parameters.Append cmd.CreateParameter("PV_XSLT_FILENAME", adVarChar, adParamInput, 255)
.Parameters.Append cmd.CreateParameter("PC_XML", adLongVarChar, adParamOutput, 900000000)
.Parameters.Append cmd.CreateParameter("PC_BINDS_XML", adLongVarChar, adParamInput, stream.Size + 1, stream.ReadText)
.Execute
End With
Set RunFODBPackage = lrs
End If
End Function
The error occurs when the line ".Execute" runs. Does anybody know how to get around this problem?
Thanks in advance
Re: Not enough storage is available to complete this operation error
plz illustration what do you want to can help you man
Re: Not enough storage is available to complete this operation error
check your server for hard disk space. either that or its in the client side. but this is most probably a server side error where the server has run out of hard disk space in which the database file is stored.