Wrox Home  
Search P2P Archive for: Go

  Return to Index  

aspx thread: ADoDB Error


Message #1 by Akthar Dilmohamud <Akthar@f...> on Fri, 12 Oct 2001 15:09:41 +0400
Hi ,

I am Having the following Error



Error Type:

ADODB.Command (0x800A0BB9)

Arguments are of the wrong type, are out of acceptable range, or are in

conflict with one another.



Here are the codes:



Set cnnSimple = Server.CreateObject("ADODB.Command")

cnnSimple.ActiveConnection =  Application("ConnectionString")





Can anyone Help Plzzzzzzz.



Thanks

Akthar

Message #2 by "Chris Scott" <chris@e...> on Fri, 12 Oct 2001 14:02:33 -0700
Hi,



Looks like your Application("ConnectionString") doesn't contain the right

info.



----- Original Message -----

From: "Akthar Dilmohamud" <Akthar@f...>

To: "ASP+" <aspx@p...>

Sent: Friday, October 12, 2001 4:09 AM

Subject: [aspx] ADoDB Error





> Hi ,

> I am Having the following Error

>

> Error Type:

> ADODB.Command (0x800A0BB9)

> Arguments are of the wrong type, are out of acceptable range, or are in

> conflict with one another.

>

> Here are the codes:

>

> Set cnnSimple = Server.CreateObject("ADODB.Command")

> cnnSimple.ActiveConnection =  Application("ConnectionString")

>

>

> Can anyone Help Plzzzzzzz.

>

> Thanks

> Akthar

Message #3 by Akthar Dilmohamud <Akthar@f...> on Fri, 12 Oct 2001 17:36:01 +0400
in fact i am using Global.asa and my string is defined in the global.asa

file.

The datsbase path is Correct.

What can be the problem?



Here are the codes:

****************

<SCRIPT LANGUAGE=vbscript RUNAT=Server>

 

Sub Application_Onstart 

 

Application("ConnectionString") = "Provider=Microsoft.Jet.OLEDB.4.0; Data

Source=c:\database\leaves.mdb;" 

End Sub

 

Sub Application_OnEnd

 

 Session.abandon

 Application ("ConnectionString") = nothing

 

End Sub

*********************





-----Original Message-----

From: Chris Scott [mailto:chris@e...]

Sent: Saturday, October 13, 2001 1:03 AM

To: ASP+

Subject: [aspx] Re: ADoDB Error





Hi,



Looks like your Application("ConnectionString") doesn't contain the right

info.

Message #4 by "Steven K. Glosny" <glosny@m...> on Mon, 15 Oct 2001 05:12:28
The ActiveConnection property is expecting a "Connection" object, not the 

connection string.  You first have to create the object, then set the 

property.



Steve
Message #5 by "Chris Scott" <chris@e...> on Mon, 15 Oct 2001 08:29:59 -0700
The ActiveConnection property can be a string or a connection object.



Chris



----- Original Message -----

From: "Steven K. Glosny" <glosny@m...>

To: "ASP+" <aspx@p...>

Sent: Monday, October 15, 2001 5:12 AM

Subject: [aspx] Re: ADoDB Error





> The ActiveConnection property is expecting a "Connection" object, not the

> connection string.  You first have to create the object, then set the

> property.

>

> Steve


  Return to Index