Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid data

From: Stephen Howe (sjhoweATdialDOTpipexDOTcom)
Date: 02/24/05


Date: Thu, 24 Feb 2005 00:08:04 -0000


> but why it does happen some times and some doesn´t??? does it have sense?

Some other possibilities:

1) You don't happen to be opening more than 1 Recordset _AT THE SAME TIME_
within your code from the same Connection? There is some limitation with SQL
Server whereby you cannot have 2+ Servers-sided, ForwardOnly cursors on the
same connection. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;235282

2) Another possibility is you have hit a ceiling limit on the number of
active connections you can have.

3) Are you using Connection pooling?

4) Are you using SQLOLEDB provider?

Stephen



Relevant Pages

  • Re: Help: inappropriate OLEDB timeout:
    ... the Connection object is using ... > The application was developed using the SQLOLEDB provider. ... All I know is that a query starts to time out after 30 seconds. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: DDE Access to Word using mde
    ... but Word opens just fine. ... to an Access 2002/3 .mde using DDE, the connection is fine. ... By the way there are no other users(except the current opening of the ...
    (microsoft.public.word.mailmerge.fields)
  • Its been solved kinda...
    ... doesn't seem to work without the use of the SQLOLEDB provider, ... the returned autogenerated Identity is wrong. ... > Private Sub Save_Foo ... > Dim cn As New Connection, ...
    (microsoft.public.vb.database)
  • Re: Default to LAN connection when Dial-up is present
    ... I no longer have possession of the laptop to try most of this but I can tell ... Outlook Express was not opening ... Our GPO prohibits allowing the user to change the connection settings in IE. ...
    (microsoft.public.windows.inetexplorer.ie6.setup)
  • Re: JDBC and Stored procedure performance problems
    ... There is an overhead on the iSeries in getting the JVM started, ... > connection if all are in use and opening it in advance. ... > The same SQL statement takes just a second in STRSQL, ...
    (comp.sys.ibm.as400.misc)