adodb.recordset object and the IIS session object

Tech-Archive recommends: Speed Up your PC by fixing your registry



I was looking through the registry of a Windows 2000 Adv. Server I
just built and noticed that the adodb.recordset object had been set to
"both" mode threading.

Regardless of all the "no no's" I've heard about storing objects in
session variables , can someone absolutely confirm for me the
adodb.recordset object is now registered as "both" on a new build of
Adv. Server with all the patches. (.net 1.1 is installed also, but
right now I'm using ASP).

I want to store the recordset object in a session, and if it is "both"
by default then my host in Canada will probably have the same
registration of the object, since they are a recognized leader in
hosting for NT platforms.

I believe the issue with using apartment threaded objects in session
is the ability for the IIS thread to get to the object while other
requests are comming into the server, etc... a "reference" to the
object in memory is kept in a table... etc.

Since I can fill a recordset without a connection much the same way I
can fill a dictionary object, it will be great for name value pairs
that need to persist.

So finally, does anyone know if the latest MDAC does in fact register
the adodb.recordset object as "both" and if so, can anyone see a
reason not to use it in sessison?
.



Relevant Pages

  • RE: issues authentication w/2003 server AND SP1, IIS 6, FPSE 2002
    ... Server 2003 with Service Pack 1. ... In Registry Editor, locate and then click the following registry key: ... > following article number to view the article in the Microsoft Knowledge Base: ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • Re: ISA and IIS services getting confused
    ... the ServicePackNumber is set to 1 in the registry. ... you need to verify that you had applied SBS 2003 ... On the SBS server, click Start, click Run, type "regedit" (without ... To successfully install SBS 2003 SP1, ...
    (microsoft.public.windows.server.sbs)
  • RE: I cant run the routing and remote access wizard
    ... Since i sent you the emails - hope you received them - I have run a registry ... http://localhost on the server box. ... Please enable IIS logging and reproduced the issue and collect IIS log ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... This newsgroup only focuses on SBS technical issues. ... before I can down the SBS Server and complete this procedure. ... SBSISA2K4SETUP: Entering LaunchMsdeSp4 ... wanted in the Registry. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal
    ... the fully expanded path of "%ProgramFiles%\ Microsoft SQL Server ... used for the SHAREPOINT instance? ... SBSISA2K4SETUP: Entering LaunchMsdeSp4 ... wanted in the Registry. ...
    (microsoft.public.windows.server.sbs)