Microsoft JScript runtime error '800a01ad' 
Author Message
 Microsoft JScript runtime error '800a01ad'

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I am running a company website on IIS 4.0 / Windows NT Server (SP5).
Our client uses server-side JavaScript.  When trying to process their
pages I get this:

Microsoft JScript runtime error '800a01ad'
Automation server can't create object

/asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

the code for this is posted below.  This site worked fine previously
on another IIS server.  Any ideas?

Joe Jenkins

System Administrator

Digital Media Asssociates

http://www.*-*-*.com/


function RSOpen()
{
 this.RSConnection = this.FindConnection(this.DSN, this.UID,
this.PWD);
 if(this.RSConnection == null)
 {
  this.RSConnection = Server.CreateObject("ADODB.Connection");
  this.AddConnection(this.DSN, this.UID, this.PWD,
this.RSConnection);
 }
 if(this.RSConnection)
 {
  if(!(this.RSConnection.State & 1/*adStateOpen*/))
  {
   this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
";pwd=" + this.PWD);
  }
  this.RS = Server.CreateObject("ADODB.Recordset");
  if(this.RS)
  {
   var version = parseFloat(this.RSConnection.Version);
   if (version > 1.0)
   {
    this.RS.CursorLocation = this.CursorLocation;
   }

   var SQL = this.SQL;
   if(this.OrderByCol != "")
   {
    SQL += " ORDER BY " + this.OrderByCol;
   }
   if(this.ParamArray != null && this.ParamArray.length > 0)
   {
    // substitute parameters
    SQL = this.SubstituteParams(SQL);
   }

   this.RS.Open(SQL, this.RSConnection, this.CursorType,
this.LockType);
   if (this.RS.State == 1/*adStateOpen*/)
   {
    this.SupportsApproxPosition =
this.RS.Supports(0x4000/*adApproxPosition*/);
    this.SupportsMove = this.RS.Supports(0x200/*adMovePrevious*/);
    this.SupportsCount = this.RS.RecordCount != -1;
    this.RestoreState();
   }
   else
   {
    Response.Write("<BR>Error: Unable to open Recordset!<BR>");
   }
  }
 }

Quote:
}

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use < http://www.*-*-*.com/ >

iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
vqZv5EYqHCvHm2D4kaUHUWXp
=ubqi
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
??? the code for this is posted below. ???

What's on line 339?  0x800a01ad is simply a 429 error.  Whatever object this line is trying to
create either isn't registered on this new IIS box or the NT account under which the ASP code
executes hasn't been given sufficient NT permissions.

--
Michael Harris
MVP Scripting

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I am running a company website on IIS 4.0 / Windows NT Server (SP5).
Our client uses server-side JavaScript.  When trying to process their
pages I get this:

Microsoft JScript runtime error '800a01ad'
Automation server can't create object

/asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

the code for this is posted below.  This site worked fine previously
on another IIS server.  Any ideas?

Joe Jenkins

System Administrator

Digital Media Asssociates

http://www.nowalls.com


function RSOpen()
{
 this.RSConnection = this.FindConnection(this.DSN, this.UID,
this.PWD);
 if(this.RSConnection == null)
 {
  this.RSConnection = Server.CreateObject("ADODB.Connection");
  this.AddConnection(this.DSN, this.UID, this.PWD,
this.RSConnection);
 }
 if(this.RSConnection)
 {
  if(!(this.RSConnection.State & 1/*adStateOpen*/))
  {
   this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
";pwd=" + this.PWD);
  }
  this.RS = Server.CreateObject("ADODB.Recordset");
  if(this.RS)
  {
   var version = parseFloat(this.RSConnection.Version);
   if (version > 1.0)
   {
    this.RS.CursorLocation = this.CursorLocation;
   }

   var SQL = this.SQL;
   if(this.OrderByCol != "")
   {
    SQL += " ORDER BY " + this.OrderByCol;
   }
   if(this.ParamArray != null && this.ParamArray.length > 0)
   {
    // substitute parameters
    SQL = this.SubstituteParams(SQL);
   }

   this.RS.Open(SQL, this.RSConnection, this.CursorType,
this.LockType);
   if (this.RS.State == 1/*adStateOpen*/)
   {
    this.SupportsApproxPosition =
this.RS.Supports(0x4000/*adApproxPosition*/);
    this.SupportsMove = this.RS.Supports(0x200/*adMovePrevious*/);
    this.SupportsCount = this.RS.RecordCount != -1;
    this.RestoreState();
   }
   else
   {
    Response.Write("<BR>Error: Unable to open Recordset!<BR>");
   }
  }
 }

Quote:
}

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
vqZv5EYqHCvHm2D4kaUHUWXp
=ubqi
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I apologize.  The function which causes this error is below:  The
specific line is:

this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
";pwd=" + this.PWD);
(from below (line 339))

How does one set the security level for ASP code to execute under?
If that isnt the cause, how would one go about registering the
'object.'  I have not come across this before with IIS, please
forgive my ignorance here.

Joe Jenkins


Quote:
> ??? the code for this is posted below. ???

> What's on line 339?  0x800a01ad is simply a 429 error.  Whatever
> object this line is trying to create either isn't registered on
> this new IIS box or the NT account under which the ASP code
> executes hasn't been given sufficient NT permissions.

> --
> Michael Harris
> MVP Scripting



> MESSAGE-----
> Hash: SHA1

> I am running a company website on IIS 4.0 / Windows NT Server
> (SP5). Our client uses server-side JavaScript.  When trying to
> process their pages I get this:

> Microsoft JScript runtime error '800a01ad'
> Automation server can't create object

> /asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

> the code for this is posted below.  This site worked fine
> previously on another IIS server.  Any ideas?

> Joe Jenkins

> System Administrator

> Digital Media Asssociates

> http://www.nowalls.com


> function RSOpen()
> {
>  this.RSConnection = this.FindConnection(this.DSN, this.UID,
> this.PWD);
>  if(this.RSConnection == null)
>  {
>   this.RSConnection = Server.CreateObject("ADODB.Connection");
>   this.AddConnection(this.DSN, this.UID, this.PWD,
> this.RSConnection);
>  }
>  if(this.RSConnection)
>  {
>   if(!(this.RSConnection.State & 1/*adStateOpen*/))
>   {
>    this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
> ";pwd=" + this.PWD);
>   }
>   this.RS = Server.CreateObject("ADODB.Recordset");
>   if(this.RS)
>   {
>    var version = parseFloat(this.RSConnection.Version);
>    if (version > 1.0)
>    {
>     this.RS.CursorLocation = this.CursorLocation;
>    }

>    var SQL = this.SQL;
>    if(this.OrderByCol != "")
>    {
>     SQL += " ORDER BY " + this.OrderByCol;
>    }
>    if(this.ParamArray != null && this.ParamArray.length > 0)
>    {
>     // substitute parameters
>     SQL = this.SubstituteParams(SQL);
>    }

>    this.RS.Open(SQL, this.RSConnection, this.CursorType,
> this.LockType);
>    if (this.RS.State == 1/*adStateOpen*/)
>    {
>     this.SupportsApproxPosition =
> this.RS.Supports(0x4000/*adApproxPosition*/);
>     this.SupportsMove = this.RS.Supports(0x200/*adMovePrevious*/);
>     this.SupportsCount = this.RS.RecordCount != -1;
>     this.RestoreState();
>    }
>    else
>    {
>     Response.Write("<BR>Error: Unable to open Recordset!<BR>");
>    }
>   }
>  }
> }

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.2 for non-commercial use
> <http://www.pgp.com>

> iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
> vqZv5EYqHCvHm2D4kaUHUWXp
> =ubqi
> -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

iQA+AwUBOM1chB5u8wXgObczEQJz8wCgsenpwcjHlgNPAiC7ZSVHjyoGolkAlRE/
i1F2KAT4Asjz1pKIj3CunPI=
=m5LI
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
Has the DSN been created on the new IIS box?

--
Michael Harris
MVP Scripting

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I apologize.  The function which causes this error is below:  The
specific line is:

this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
";pwd=" + this.PWD);
(from below (line 339))

How does one set the security level for ASP code to execute under?
If that isnt the cause, how would one go about registering the
'object.'  I have not come across this before with IIS, please
forgive my ignorance here.

Joe Jenkins


Quote:
> ??? the code for this is posted below. ???

> What's on line 339?  0x800a01ad is simply a 429 error.  Whatever
> object this line is trying to create either isn't registered on
> this new IIS box or the NT account under which the ASP code
> executes hasn't been given sufficient NT permissions.

> --
> Michael Harris
> MVP Scripting



> MESSAGE-----
> Hash: SHA1

> I am running a company website on IIS 4.0 / Windows NT Server
> (SP5). Our client uses server-side JavaScript.  When trying to
> process their pages I get this:

> Microsoft JScript runtime error '800a01ad'
> Automation server can't create object

> /asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

> the code for this is posted below.  This site worked fine
> previously on another IIS server.  Any ideas?

> Joe Jenkins

> System Administrator

> Digital Media Asssociates

> http://www.nowalls.com


> function RSOpen()
> {
>  this.RSConnection = this.FindConnection(this.DSN, this.UID,
> this.PWD);
>  if(this.RSConnection == null)
>  {
>   this.RSConnection = Server.CreateObject("ADODB.Connection");
>   this.AddConnection(this.DSN, this.UID, this.PWD,
> this.RSConnection);
>  }
>  if(this.RSConnection)
>  {
>   if(!(this.RSConnection.State & 1/*adStateOpen*/))
>   {
>    this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
> ";pwd=" + this.PWD);
>   }
>   this.RS = Server.CreateObject("ADODB.Recordset");
>   if(this.RS)
>   {
>    var version = parseFloat(this.RSConnection.Version);
>    if (version > 1.0)
>    {
>     this.RS.CursorLocation = this.CursorLocation;
>    }

>    var SQL = this.SQL;
>    if(this.OrderByCol != "")
>    {
>     SQL += " ORDER BY " + this.OrderByCol;
>    }
>    if(this.ParamArray != null && this.ParamArray.length > 0)
>    {
>     // substitute parameters
>     SQL = this.SubstituteParams(SQL);
>    }

>    this.RS.Open(SQL, this.RSConnection, this.CursorType,
> this.LockType);
>    if (this.RS.State == 1/*adStateOpen*/)
>    {
>     this.SupportsApproxPosition =
> this.RS.Supports(0x4000/*adApproxPosition*/);
>     this.SupportsMove = this.RS.Supports(0x200/*adMovePrevious*/);
>     this.SupportsCount = this.RS.RecordCount != -1;
>     this.RestoreState();
>    }
>    else
>    {
>     Response.Write("<BR>Error: Unable to open Recordset!<BR>");
>    }
>   }
>  }
> }

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.2 for non-commercial use
> <http://www.pgp.com>

> iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
> vqZv5EYqHCvHm2D4kaUHUWXp
> =ubqi
> -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

iQA+AwUBOM1chB5u8wXgObczEQJz8wCgsenpwcjHlgNPAiC7ZSVHjyoGolkAlRE/
i1F2KAT4Asjz1pKIj3CunPI=
=m5LI
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, it has.  There are two DSN's (System) Both are set up as SYSTEM
dsn's and are both Microsoft Access Driver (*.mdb) databases.
Verifying the connection in something like ColdFusion adminstrator
seems to work just fine.

Joe


Quote:
> Has the DSN been created on the new IIS box?

> --
> Michael Harris
> MVP Scripting



> MESSAGE-----
> Hash: SHA1

> I apologize.  The function which causes this error is below:  The
> specific line is:

> this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
> ";pwd=" + this.PWD);
> (from below (line 339))

> How does one set the security level for ASP code to execute under?
> If that isnt the cause, how would one go about registering the
> 'object.'  I have not come across this before with IIS, please
> forgive my ignorance here.

> Joe Jenkins



> > ??? the code for this is posted below. ???

> > What's on line 339?  0x800a01ad is simply a 429 error.  Whatever
> > object this line is trying to create either isn't registered on
> > this new IIS box or the NT account under which the ASP code
> > executes hasn't been given sufficient NT permissions.

> > --
> > Michael Harris
> > MVP Scripting



> > MESSAGE-----
> > Hash: SHA1

> > I am running a company website on IIS 4.0 / Windows NT Server
> > (SP5). Our client uses server-side JavaScript.  When trying to
> > process their pages I get this:

> > Microsoft JScript runtime error '800a01ad'
> > Automation server can't create object

> > /asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

> > the code for this is posted below.  This site worked fine
> > previously on another IIS server.  Any ideas?

> > Joe Jenkins

> > System Administrator

> > Digital Media Asssociates

> > http://www.nowalls.com


> > function RSOpen()
> > {
> >  this.RSConnection = this.FindConnection(this.DSN, this.UID,
> > this.PWD);
> >  if(this.RSConnection == null)
> >  {
> >   this.RSConnection = Server.CreateObject("ADODB.Connection");
> >   this.AddConnection(this.DSN, this.UID, this.PWD,
> > this.RSConnection);
> >  }
> >  if(this.RSConnection)
> >  {
> >   if(!(this.RSConnection.State & 1/*adStateOpen*/))
> >   {
> >    this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID
> > + ";pwd=" + this.PWD);
> >   }
> >   this.RS = Server.CreateObject("ADODB.Recordset");
> >   if(this.RS)
> >   {
> >    var version = parseFloat(this.RSConnection.Version);
> >    if (version > 1.0)
> >    {
> >     this.RS.CursorLocation = this.CursorLocation;
> >    }

> >    var SQL = this.SQL;
> >    if(this.OrderByCol != "")
> >    {
> >     SQL += " ORDER BY " + this.OrderByCol;
> >    }
> >    if(this.ParamArray != null && this.ParamArray.length > 0)
> >    {
> >     // substitute parameters
> >     SQL = this.SubstituteParams(SQL);
> >    }

> >    this.RS.Open(SQL, this.RSConnection, this.CursorType,
> > this.LockType);
> >    if (this.RS.State == 1/*adStateOpen*/)
> >    {
> >     this.SupportsApproxPosition =
> > this.RS.Supports(0x4000/*adApproxPosition*/);
> >     this.SupportsMove =
> > this.RS.Supports(0x200/*adMovePrevious*/);
> >     this.SupportsCount = this.RS.RecordCount != -1;
> >     this.RestoreState();
> >    }
> >    else
> >    {
> >     Response.Write("<BR>Error: Unable to open Recordset!<BR>");
> >    }
> >   }
> >  }
> > }

> > -----BEGIN PGP SIGNATURE-----
> > Version: PGPfreeware 6.5.2 for non-commercial use
> > <http://www.pgp.com>

> > iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
> > vqZv5EYqHCvHm2D4kaUHUWXp
> > =ubqi
> > -----END PGP SIGNATURE-----

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.2 for non-commercial use
> <http://www.pgp.com>

> iQA+AwUBOM1chB5u8wXgObczEQJz8wCgsenpwcjHlgNPAiC7ZSVHjyoGolkAlRE/
> i1F2KAT4Asjz1pKIj3CunPI=
> =m5LI
> -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

iQA/AwUBOM1kcx5u8wXgObczEQISlACeKsF+m+OndDsGs6GGi7hUQ1BXRncAn3FU
0JvIlHPjM6MP4MFxGuSW3Vvq
=gAaU
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
Try writing a stripped down standalone .js or .wsf version that you can execute as a logged on user
to the IIS box if possible.  If the ASP works without changes on one IIS box but not another, then
it has to be a configuration or security problem.  Do both IIS boxes have the same version of MDAC?

--
Michael Harris
MVP Scripting

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Yes, it has.  There are two DSN's (System) Both are set up as SYSTEM
dsn's and are both Microsoft Access Driver (*.mdb) databases.
Verifying the connection in something like ColdFusion adminstrator
seems to work just fine.

Joe


Quote:
> Has the DSN been created on the new IIS box?

> --
> Michael Harris
> MVP Scripting



> MESSAGE-----
> Hash: SHA1

> I apologize.  The function which causes this error is below:  The
> specific line is:

> this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
> ";pwd=" + this.PWD);
> (from below (line 339))

> How does one set the security level for ASP code to execute under?
> If that isnt the cause, how would one go about registering the
> 'object.'  I have not come across this before with IIS, please
> forgive my ignorance here.

> Joe Jenkins



> > ??? the code for this is posted below. ???

> > What's on line 339?  0x800a01ad is simply a 429 error.  Whatever
> > object this line is trying to create either isn't registered on
> > this new IIS box or the NT account under which the ASP code
> > executes hasn't been given sufficient NT permissions.

> > --
> > Michael Harris
> > MVP Scripting



> > MESSAGE-----
> > Hash: SHA1

> > I am running a company website on IIS 4.0 / Windows NT Server
> > (SP5). Our client uses server-side JavaScript.  When trying to
> > process their pages I get this:

> > Microsoft JScript runtime error '800a01ad'
> > Automation server can't create object

> > /asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

> > the code for this is posted below.  This site worked fine
> > previously on another IIS server.  Any ideas?

> > Joe Jenkins

> > System Administrator

> > Digital Media Asssociates

> > http://www.nowalls.com


> > function RSOpen()
> > {
> >  this.RSConnection = this.FindConnection(this.DSN, this.UID,
> > this.PWD);
> >  if(this.RSConnection == null)
> >  {
> >   this.RSConnection = Server.CreateObject("ADODB.Connection");
> >   this.AddConnection(this.DSN, this.UID, this.PWD,
> > this.RSConnection);
> >  }
> >  if(this.RSConnection)
> >  {
> >   if(!(this.RSConnection.State & 1/*adStateOpen*/))
> >   {
> >    this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID
> > + ";pwd=" + this.PWD);
> >   }
> >   this.RS = Server.CreateObject("ADODB.Recordset");
> >   if(this.RS)
> >   {
> >    var version = parseFloat(this.RSConnection.Version);
> >    if (version > 1.0)
> >    {
> >     this.RS.CursorLocation = this.CursorLocation;
> >    }

> >    var SQL = this.SQL;
> >    if(this.OrderByCol != "")
> >    {
> >     SQL += " ORDER BY " + this.OrderByCol;
> >    }
> >    if(this.ParamArray != null && this.ParamArray.length > 0)
> >    {
> >     // substitute parameters
> >     SQL = this.SubstituteParams(SQL);
> >    }

> >    this.RS.Open(SQL, this.RSConnection, this.CursorType,
> > this.LockType);
> >    if (this.RS.State == 1/*adStateOpen*/)
> >    {
> >     this.SupportsApproxPosition =
> > this.RS.Supports(0x4000/*adApproxPosition*/);
> >     this.SupportsMove =
> > this.RS.Supports(0x200/*adMovePrevious*/);
> >     this.SupportsCount = this.RS.RecordCount != -1;
> >     this.RestoreState();
> >    }
> >    else
> >    {
> >     Response.Write("<BR>Error: Unable to open Recordset!<BR>");
> >    }
> >   }
> >  }
> > }

> > -----BEGIN PGP SIGNATURE-----
> > Version: PGPfreeware 6.5.2 for non-commercial use
> > <http://www.pgp.com>

> > iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
> > vqZv5EYqHCvHm2D4kaUHUWXp
> > =ubqi
> > -----END PGP SIGNATURE-----

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.2 for non-commercial use
> <http://www.pgp.com>

> iQA+AwUBOM1chB5u8wXgObczEQJz8wCgsenpwcjHlgNPAiC7ZSVHjyoGolkAlRE/
> i1F2KAT4Asjz1pKIj3CunPI=
> =m5LI
> -----END PGP SIGNATURE-----

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

iQA/AwUBOM1kcx5u8wXgObczEQISlACeKsF+m+OndDsGs6GGi7hUQ1BXRncAn3FU
0JvIlHPjM6MP4MFxGuSW3Vvq
=gAaU
-----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 Microsoft JScript runtime error '800a01ad'
Unfort., I am the network administrator and not the developer here.  We took
over hosting of an online auction site from another company and I was given
a cd with thier website on it and not much else (<grrr></grrr>) :) If it is
a security issue with ASP/JScript, what should I be looking for there.  I
installed the latest MDAC after I got the server online (I just barely built
this server about 2 weeks ago.)  I have other IIS servers I could try it on,
if need be.  The server I have it on now is used for our developers to test
new code. This code was developed outside of us however, and we are a
ColdFusion shop and don't do much with Java / Javascript that I am knowing
of......

Joe

Thanks for your input on this, btw.


Quote:
> Try writing a stripped down standalone .js or .wsf version that you can

execute as a logged on user
Quote:
> to the IIS box if possible.  If the ASP works without changes on one IIS

box but not another, then
Quote:
> it has to be a configuration or security problem.  Do both IIS boxes have

the same version of MDAC?
Quote:

> --
> Michael Harris
> MVP Scripting




Quote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1

> Yes, it has.  There are two DSN's (System) Both are set up as SYSTEM
> dsn's and are both Microsoft Access Driver (*.mdb) databases.
> Verifying the connection in something like ColdFusion adminstrator
> seems to work just fine.

> Joe



> > Has the DSN been created on the new IIS box?

> > --
> > Michael Harris
> > MVP Scripting



> > MESSAGE-----
> > Hash: SHA1

> > I apologize.  The function which causes this error is below:  The
> > specific line is:

> > this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID +
> > ";pwd=" + this.PWD);
> > (from below (line 339))

> > How does one set the security level for ASP code to execute under?
> > If that isnt the cause, how would one go about registering the
> > 'object.'  I have not come across this before with IIS, please
> > forgive my ignorance here.

> > Joe Jenkins



> > > ??? the code for this is posted below. ???

> > > What's on line 339?  0x800a01ad is simply a 429 error.  Whatever
> > > object this line is trying to create either isn't registered on
> > > this new IIS box or the NT account under which the ASP code
> > > executes hasn't been given sufficient NT permissions.

> > > --
> > > Michael Harris
> > > MVP Scripting



> > > MESSAGE-----
> > > Hash: SHA1

> > > I am running a company website on IIS 4.0 / Windows NT Server
> > > (SP5). Our client uses server-side JavaScript.  When trying to
> > > process their pages I get this:

> > > Microsoft JScript runtime error '800a01ad'
> > > Automation server can't create object

> > > /asp_code/media/IIS_Gen_3.0_Recordset.js, line 339

> > > the code for this is posted below.  This site worked fine
> > > previously on another IIS server.  Any ideas?

> > > Joe Jenkins

> > > System Administrator

> > > Digital Media Asssociates

> > > http://www.nowalls.com


> > > function RSOpen()
> > > {
> > >  this.RSConnection = this.FindConnection(this.DSN, this.UID,
> > > this.PWD);
> > >  if(this.RSConnection == null)
> > >  {
> > >   this.RSConnection = Server.CreateObject("ADODB.Connection");
> > >   this.AddConnection(this.DSN, this.UID, this.PWD,
> > > this.RSConnection);
> > >  }
> > >  if(this.RSConnection)
> > >  {
> > >   if(!(this.RSConnection.State & 1/*adStateOpen*/))
> > >   {
> > >    this.RSConnection.Open("dsn=" + this.DSN + ";uid=" + this.UID
> > > + ";pwd=" + this.PWD);
> > >   }
> > >   this.RS = Server.CreateObject("ADODB.Recordset");
> > >   if(this.RS)
> > >   {
> > >    var version = parseFloat(this.RSConnection.Version);
> > >    if (version > 1.0)
> > >    {
> > >     this.RS.CursorLocation = this.CursorLocation;
> > >    }

> > >    var SQL = this.SQL;
> > >    if(this.OrderByCol != "")
> > >    {
> > >     SQL += " ORDER BY " + this.OrderByCol;
> > >    }
> > >    if(this.ParamArray != null && this.ParamArray.length > 0)
> > >    {
> > >     // substitute parameters
> > >     SQL = this.SubstituteParams(SQL);
> > >    }

> > >    this.RS.Open(SQL, this.RSConnection, this.CursorType,
> > > this.LockType);
> > >    if (this.RS.State == 1/*adStateOpen*/)
> > >    {
> > >     this.SupportsApproxPosition =
> > > this.RS.Supports(0x4000/*adApproxPosition*/);
> > >     this.SupportsMove =
> > > this.RS.Supports(0x200/*adMovePrevious*/);
> > >     this.SupportsCount = this.RS.RecordCount != -1;
> > >     this.RestoreState();
> > >    }
> > >    else
> > >    {
> > >     Response.Write("<BR>Error: Unable to open Recordset!<BR>");
> > >    }
> > >   }
> > >  }
> > > }

> > > -----BEGIN PGP SIGNATURE-----
> > > Version: PGPfreeware 6.5.2 for non-commercial use
> > > <http://www.pgp.com>

> > > iQA/AwUBOM1QmB5u8wXgObczEQLkfgCfVFLK5BIH2WvF+FLWcKYBT2zo6JMAoLqh
> > > vqZv5EYqHCvHm2D4kaUHUWXp
> > > =ubqi
> > > -----END PGP SIGNATURE-----

> > -----BEGIN PGP SIGNATURE-----
> > Version: PGPfreeware 6.5.2 for non-commercial use
> > <http://www.pgp.com>

> > iQA+AwUBOM1chB5u8wXgObczEQJz8wCgsenpwcjHlgNPAiC7ZSVHjyoGolkAlRE/
> > i1F2KAT4Asjz1pKIj3CunPI=
> > =m5LI
> > -----END PGP SIGNATURE-----

> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>

> iQA/AwUBOM1kcx5u8wXgObczEQISlACeKsF+m+OndDsGs6GGi7hUQ1BXRncAn3FU
> 0JvIlHPjM6MP4MFxGuSW3Vvq
> =gAaU
> -----END PGP SIGNATURE-----



Fri, 30 Aug 2002 03:00:00 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Microsoft VBScript runtime error '800a01ad'

2. Microsoft JScript runtime error '800a138f'

3. Microsoft JScript runtime error '800a1399'

4. Microsoft JScript runtime error '800a138f'

5. Microsoft JScript runtime error '800a138f'

6. Microsoft JScript runtime error '800a000d'

7. VBScript runtime error '800a01ad'

8. Microsoft VBScript runtime error '800a000d'

9. Microsoft VBScript runtime error '800a0007'

10. Microsoft VBScript runtime error '800a0e7d'

11. Microsoft VBScript runtime error '800a01a8'

12. Microsoft VBScript runtime error '800a000d'

 

 
Powered by phpBB® Forum Software