Re: Error Creating ADODB.Connection Connection in IIS6



Mark J. McGinty wrote:
> "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
> news:O2CxBaQcFHA.132@xxxxxxxxxxxxxxxxxxxxxxx
>>
>> With that version of IIS, you no longer need to use
>> Server.CreateObject, which gets MTS involved. Try getting rid of the
>> "Server." and see what happens.
>
> Ugh you've got to be kidding! Why didn't they just add a method to
> the Server object, I wonder?
>

Huh? I think you misunderstood me. The Server object has a CreateObject
method. VBScript also has its own CreateObject method. The difference is
explained here:
http://blogs.msdn.com/ericlippert/archive/2004/06/01/145686.aspx

> Is there still a compelling reason to use Server.CreateObject vs just
> CreateObject in IIS5? I know the latter works, but seem to remember
> it was once desirable to call the former
>

In IIS4 it was always advised to use the Server's version, becuase it got
MTS involved. In IIS 5+, the pendulum has swung towards the VBScript
version.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • Re: Only 10 calls proceeded
    ... > sent to MTS server, the rest of calls will be hold (by IIS, I think) until ... installed Windows 2000 server from a CD labeled "NFR" Not for resale, ...
    (microsoft.public.inetserver.iis.security)
  • Re: .ASP, MTS transactions, and stored procedure I/O variables
    ... MTS is involved. ... There are two ways to get output variables from your stored procedures: ... > use of the Microsoft Transaction Server (IIS transaction server). ...
    (microsoft.public.inetserver.asp.db)
  • Re: .ASP, MTS transactions, and stored procedure I/O variables
    ... MTS is involved. ... There are two ways to get output variables from your stored procedures: ... > use of the Microsoft Transaction Server (IIS transaction server). ...
    (microsoft.public.inetserver.asp.general)
  • Re: .ASP, MTS transactions, and stored procedure I/O variables
    ... MTS is involved. ... There are two ways to get output variables from your stored procedures: ... > use of the Microsoft Transaction Server (IIS transaction server). ...
    (microsoft.public.sqlserver.programming)
  • ASP / IIS : Server.CreateObject() Issues
    ... I have been working to migrate to IIS 6.0 and found issues with using ... 'Server.CreateObject' versus simply 'CreateObject' in our ASP scripts. ... web objects can be created until ... something breaks and then most of the remaining CreateObject() calls in the ...
    (microsoft.public.inetserver.iis)