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

From: Gabriel Mejía (gabrielme_at_elcolombiano.com.co)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 09:21:28 -0500

how do I know I am using coonection pooling?

how do I know I am using SQLOLEDB provider?

"Stephen Howe" <sjhoweATdialDOTpipexDOTcom> escribió en el mensaje
news:OCjY$VgGFHA.2592@TK2MSFTNGP10.phx.gbl...
> > 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)
  • 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: VB Script getting error connecting to SQL Database
    ... > Try using the SQLOLEDB provider instead of the ODBC provider. ... using TCP/IP connection did the trick! ...
    (microsoft.public.scripting.vbscript)
  • Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid da
    ... You don't happen to be opening more than 1 Recordset _AT THE SAME TIME_ ... within your code from the same Connection? ... Server whereby you cannot have 2+ Servers-sided, ... Are you using SQLOLEDB provider? ...
    (microsoft.public.data.ado)