I have an asp page that is using OLEDB to connect to SQL
 Server 2K (We'll call it 2k1). It requests data from a
 view on 2k1 which via linked server points to a an
 instance of SQL Server 7.0 on a different box (We'll call
 it 702). In running this command we receive very
 sporadic errors. There are two in particular. Both are
 regarding the transactions being used for the open
 connection. Every thing I read points to using explicit
 transactions which we are not. The error will last for
 about 20 minutes and just disappear. The developers
 stating that they are definately closing connections. I
 don't know how to proceed.
 Here are the errors.
 1.
 Server: Msg 7399, Level 16, State 1, Line 1
 OLE DB provider 'SQLOLEDB' reported an error.
 [OLE/DB provider returned message: Connection is busy
 with results for another command]
 OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
 IOpenRowset::OpenRowset returned 0x80004005: ].
 2.
 Server: Msg 7392, Level 16, State 2,
 Could not start a transaction for OLEDB
 provider 'SQLOLEDB'. [OLE/DB provider returned message:
 Only one transaction cant be active on this session.Are you using Transaction Object
 try use the connection's tranaction objectsql
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment