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

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 02/24/05


Date: Thu, 24 Feb 2005 17:21:50 -0000


> how do I know I am using coonection pooling?

Read this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp
and cursor down to "OLE DB Resource Pooling"
Pooling is worth doing for web pages so that the throughput of requests is
efficient.

> how do I know I am using SQLOLEDB provider?

You know because you mention the connection string.
In your original post, you had strConect.
I don't know what the contents of that is.
Do you?

Stephen Howe



Relevant Pages

  • Re: ConnectionWrite (send())
    ... Falk Poller schrieb ... ... Wo kann man denn das Connection Pooling abschalten? ... Bei Ole DB u. a. ... "Connection Pooling for the .NET Framework Data Provider for SQL Server" ...
    (microsoft.public.de.sqlserver)
  • OLE DB Session Pooling
    ... If one component opens an OLE DB connection to a database and another ... we verify that OLE DB Session (aka Resource) Pooling has been used? ... the MSDN document titled "Pooling in the Microsoft Data Access ...
    (microsoft.public.data.ado)
  • Re: ADO OLEDB connection to MSSQL: pooling not working
    ... Pooling may be disabled by default. ... "OLE DB Services=xx" to your connectionstring to force to on. ... Lookup "OLE DB Services" in MSDN for help. ...
    (borland.public.delphi.database.ado)