ASP error

[Frank Py]

I'm trying to connect with an Access database with this snip from a
sample application originally designed for SQL Server. There is an
include file for the ADO connection statements. Can anyone tell me why I
might be getting this error? Help appreciated. Thanks. Frank

Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/NewDB/ASPTableEdit/opentable.asp, line 9

<!-- Statement -->
<!-- #include file="defaultheader.asp" -->
<!-- #include file="ado.asp" -->
<%
dim cnn, rst, tbl, fld
tbl = Request.QueryString("table")
set cnn = getconnection
set rst = server.CreateObject("ADODB.Recordset")
rst.Open tbl,cnn,adOpenKeyset,adLockOptimistic

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[SPA]

The syntax for rst.open is wrong

Use

Dim strSql

tbl = Trim(Request.QueryString("table"))
strSql = "select * from " & tbl

rst.Open strSql, cnn, adOpenKeyset,adLockOptimistic

How does this "set cnn = getconnection" work?
The actual way to use connection object is:

Set cnn = CreateObject("ADODB.Connection")
cnn.Open <connection string>

SPA

"Frank Py" <fpy@proactnet.com> wrote in message news:eXHKbRaRDHA.1804@TK2MSFTNGP11.phx.gbl...

> I'm trying to connect with an Access database with this snip from a
> sample application originally designed for SQL Server. There is an
> include file for the ADO connection statements. Can anyone tell me why I
> might be getting this error? Help appreciated. Thanks. Frank
>
> Error Type:
> ADODB.Recordset (0x800A0BB9)
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
> /NewDB/ASPTableEdit/opentable.asp, line 9
>
> <!-- Statement -->
> <!-- #include file="defaultheader.asp" -->
> <!-- #include file="ado.asp" -->
> <%
> dim cnn, rst, tbl, fld
> tbl = Request.QueryString("table")
> set cnn = getconnection
> set rst = server.CreateObject("ADODB.Recordset")
> rst.Open tbl,cnn,adOpenKeyset,adLockOptimistic
>
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[craig hillyard]

I'm getting the following error after installing SUS on a
IIS running on a W2K server.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

-----------------------------------------------------------
---------------------

Technical Information (for support personnel)

Error Type:
(0x8002801D)
Library not registered.
/autoupdate/administration/shared/corporate.inc, line 37


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 1.1.4322)

Page:
GET /autoupdate/administration/en/default.asp

Time:
Thursday, January 08, 2004, 2:35:22 PM

[Ray at]

Use this type to find out what the errror is.

[url]http://www.aspfaq.com/show.asp?id=2109[/url]

Ray at work

"craig hillyard" <surf_ninja_uk@hotmail.com> wrote in message
news:015c01c3d627$3f7bea60$a601280a@phx.gbl...

> I'm getting the following error after installing SUS on a
> IIS running on a W2K server.
>
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> -----------------------------------------------------------
> ---------------------
>
> Technical Information (for support personnel)
>
> Error Type:
> (0x8002801D)
> Library not registered.
> /autoupdate/administration/shared/corporate.inc, line 37
>
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
> CLR 1.1.4322)
>
> Page:
> GET /autoupdate/administration/en/default.asp
>
> Time:
> Thursday, January 08, 2004, 2:35:22 PM
>
>

[Vincent]

I get this error "ASP 0141" - page command repeated.

How do I get past this? It says that "@" has been repeated
and I cannot locate where

Vincent

[Roland Hall]

"Vincent" wrote:
: I get this error "ASP 0141" - page command repeated.
:
: How do I get past this? It says that "@" has been repeated
: and I cannot locate where

Generally this happens when you have an include file that has:
<%@ LANGUAGE=VBScript %>

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - [url]http://www.microsoft.com/technet/scriptcenter/[/url]
WSH 5.6 Documentation - [url]http://msdn.microsoft.com/downloads/list/webdev.asp[/url]
MSDN Library - [url]http://msdn.microsoft.com/library/default.asp[/url]

[Roy - Topup Communications]

I recieve on the explorer an error message saying: 'An error occurred while
creating object 'WScript'. Active Server Pages error '8002802b' Create object
failed '.
Event viewer warning message: event id 9 source: active server pages.
IIS log failed to write entry, File ? Create object failed. An
error occurred while creating object 'JSProxy'..

What can be done to solve this issue?

[Steven Burn]

[url]http://aspfaq.com/show.asp?id=2323[/url]

--
Regards

Steven Burn
Ur I.T. Mate Group
[url]www.it-mate.co.uk[/url]

Keeping it FREE!

"Roy - Topup Communications"
<RoyTopupCommunications@discussions.microsoft.co m> wrote in message
news:5B030090-76FE-426A-8D9B-F633D8AF2EAA@microsoft.com...

> I recieve on the explorer an error message saying: 'An error occurred

while

> creating object 'WScript'. Active Server Pages error '8002802b' Create

object

> failed '.
> Event viewer warning message: event id 9 source: active server pages.
> IIS log failed to write entry, File ? Create object failed. An
> error occurred while creating object 'JSProxy'..
>
> What can be done to solve this issue?

[ZaM]

Hi all.

I have the same issue, and there is no place with some resolution.
aspfaq.com does not have an answer for the "An error occurred while
creating object 'JSProxy'" message.

My server was working fine for a couple of months (win2000, iis, sql)
but a few weeks ago starts to send me this messages. The weird thing is
that the script execution remains working good after the error was
thrown.

Any ideas?

Steven Burn ha escrito:

> [url]http://aspfaq.com/show.asp?id=2323[/url]
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> [url]www.it-mate.co.uk[/url]
>
> Keeping it FREE!
>
> "Roy - Topup Communications"
> <RoyTopupCommunications@discussions.microsoft.co m> wrote in message
> news:5B030090-76FE-426A-8D9B-F633D8AF2EAA@microsoft.com...

> > I recieve on the explorer an error message saying: 'An error occurred

> while

> > creating object 'WScript'. Active Server Pages error '8002802b' Create

> object

> > failed '.
> > Event viewer warning message: event id 9 source: active server pages.
> > IIS log failed to write entry, File ? Create object failed. An
> > error occurred while creating object 'JSProxy'..
> >
> > What can be done to solve this issue?

[ZaM]

Auto-answer

After a deep lookup into the event viewer, i've found that the first
error was logged 1 hour after an antivirus update. After uninstalled
(for testing purposes obviously) the message stops.. So I can believe
that the source of the problem comes from the antivirus software.