ADODB.Command error '800a0bb9'


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: ADODB.Command error '800a0bb9'

  1. #1
    Jon Crosse Guest

    ADODB.Command error '800a0bb9'


    When trying to write to a database on my site, i constantly get the following
    error:

    > ADODB.Command error '800a0bb9'


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

    -> conflict with one another.

    > /postmsg2server.asp, line 19


    The Line of code this relates to is:

    > rsMsgBoardAdd.CommandType = adCmdText


    Any ideas what could be causing the error and how to fix it?


    Any help appreciated
    Thanx in advance

    ____________________
    Jon Crosse

  2. #2
    Vinita Guest

    Re: ADODB.Command error '800a0bb9'


    Jon,

    Either try doing this ...

    rsMsgBoardAdd.CommandType = adCmdText(Set the number equivalent of this constant,
    which is 4 or something, I am not sure you can look up.)
    rsMsgBoardAdd.CommandType = 4

    Or...

    Set a reference to "Microsoft ActiveX Data Objects 2.6 Library"

    Hope this helps.


    "Jon Crosse" <j_crosse@hotmail.com> wrote:
    >
    >When trying to write to a database on my site, i constantly get the following
    >error:
    >
    >> ADODB.Command error '800a0bb9'

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

    >-> conflict with one another.
    >
    >> /postmsg2server.asp, line 19

    >
    >The Line of code this relates to is:
    >
    >> rsMsgBoardAdd.CommandType = adCmdText

    >
    >Any ideas what could be causing the error and how to fix it?
    >
    >
    >Any help appreciated
    >Thanx in advance
    >
    >____________________
    >Jon Crosse



  3. #3
    Kris Eiben Guest

    Re: ADODB.Command error '800a0bb9'

    You probably don't have adovbs.inc, a text file that has all of these
    VBscript constants, included on the page. If you don't want to include the
    file, just use the value inline -- look up the value for adCmdText in
    adovbs.inc, and use that instead of the variable.

    "Jon Crosse" <j_crosse@hotmail.com> wrote in message
    news:3cd8283f$1@10.1.10.29...
    >
    > When trying to write to a database on my site, i constantly get the

    following
    > error:
    > > ADODB.Command error '800a0bb9'
    > > Arguments are of the wrong type, are out of acceptable range, or are in

    > -> conflict with one another.
    > > /postmsg2server.asp, line 19

    > The Line of code this relates to is:
    > > rsMsgBoardAdd.CommandType = adCmdText




  4. #4
    Harish Kumar Guest

    Re: ADODB.Command error '800a0bb9'


    Kris,

    Were you able to identify the problem? If not, suggest you to have a look
    at this article -

    http://www.adopenstatic.com/faq/800a0bb9.asp

    Harish
    "Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote:
    >You probably don't have adovbs.inc, a text file that has all of these
    >VBscript constants, included on the page. If you don't want to include

    the
    >file, just use the value inline -- look up the value for adCmdText in
    >adovbs.inc, and use that instead of the variable.
    >
    >"Jon Crosse" <j_crosse@hotmail.com> wrote in message
    >news:3cd8283f$1@10.1.10.29...
    >>
    >> When trying to write to a database on my site, i constantly get the

    >following
    >> error:
    >> > ADODB.Command error '800a0bb9'
    >> > Arguments are of the wrong type, are out of acceptable range, or are

    in
    >> -> conflict with one another.
    >> > /postmsg2server.asp, line 19

    >> The Line of code this relates to is:
    >> > rsMsgBoardAdd.CommandType = adCmdText

    >
    >



  5. #5
    Kris Eiben Guest

    Re: ADODB.Command error '800a0bb9'

    I didn't have a problem, just a solution. But it's a good article.

    "Harish Kumar" <HarishM@MailCity.Com> wrote in message
    news:3cda81b7$1@10.1.10.29...
    >
    > Kris,
    >
    > Were you able to identify the problem? If not, suggest you to have a look
    > at this article -
    >
    > http://www.adopenstatic.com/faq/800a0bb9.asp
    >
    > Harish
    > "Kris Eiben" <eibenkthisisforspammers@yahoo.com> wrote:
    > >You probably don't have adovbs.inc, a text file that has all of these
    > >VBscript constants, included on the page. If you don't want to include

    > the
    > >file, just use the value inline -- look up the value for adCmdText in
    > >adovbs.inc, and use that instead of the variable.
    > >
    > >"Jon Crosse" <j_crosse@hotmail.com> wrote in message
    > >news:3cd8283f$1@10.1.10.29...
    > >>
    > >> When trying to write to a database on my site, i constantly get the

    > >following
    > >> error:
    > >> > ADODB.Command error '800a0bb9'
    > >> > Arguments are of the wrong type, are out of acceptable range, or are

    > in
    > >> -> conflict with one another.
    > >> > /postmsg2server.asp, line 19
    > >> The Line of code this relates to is:
    > >> > rsMsgBoardAdd.CommandType = adCmdText

    > >
    > >

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center