General Network Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

General Network Error

Author

Topic

manishrawat
Starting Member

9 Posts

Posted - 2001-12-19 : 10:51:13

We used the VB dll's components. couple of times we get this error of
RunSPReturnRS(nav_nextpage, ...) [dbmssocn]General network error. Check your network documentation

This is not specific to a component or Stored procedure.
What could be the cause??

-----------------------------------------------------
Public Function RunSPReturnRS(ByVal sDBConnectStr As String, _
ByVal strSP As String, _
ParamArray params() As Variant) As ADODB.Recordset

On Error GoTo Err_Handle
' Clear Any Previous Errors
Err.Clear

' Create the ADO objects
Dim rs As ADODB.Recordset, cmd As ADODB.Command
Set rs = New ADODB.Recordset
Set cmd = New ADODB.Command

' Init the ADO objects & the stored proc parameters
cmd.ActiveConnection = sDBConnectStr
cmd.CommandText = strSP
'cmd.Prepared = True
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeOut = m_TimeOutInterval

collectParams cmd, params

' Execute the query for readonly
rs.CursorLocation = adUseClient
rs.Open cmd, , adOpenForwardOnly, adLockReadOnly

' Disconnect the recordset
Set cmd.ActiveConnection = Nothing
Set cmd = Nothing
Set rs.ActiveConnection = Nothing

' Return the resultant recordset
Set RunSPReturnRS = rs
Exit Function

Err_Handle:
Set rs = Nothing
Set cmd = Nothing
modError.RaiseError mModName, "RunSPReturnRS(" & strSP & ", ...)"
End Function
---------------------------------------------------

Thanks
Manish

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2001-12-19 : 14:55:16

quote:
[dbmssocn]General network error. Check your network documentation

This is not specific to a component or Stored procedure.
What could be the cause??

If you're getting this error only occasionally, and can't tie it to any single sproc or database, and the rest of the time it works fine, then it sounds like you've got intermittent network errors. Better have somebody start analyzing your network for problems.

-------------------
It's a SQL thing...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources