ADO (MDAC) issue

Discussion in 'ASP General' started by ivy, Oct 7, 2003.

  1. ivy

    ivy Guest

    I have a problem lies with a meta tag. Below is my code:
    <!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5
    Library" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"
    VERSION="2.5"-->
    This is suppose to set a reference to a MDAC file which will hold many
    constants. The error appears on the following line:
    oComp.AddParam "@UserID", adVarChar, adParamInput, 100, msUserID
    Error message.
    Microsoft VBScript runtime (0x800A01F4)
    Variable is undefined: 'adVarChar'

    I actually narrowed it down to an ADO (MDAC) issue. What I did was
    that I included the adovbs.inc file which has all the constants
    defined. Next, I ran the application. The error that I received
    before went away but I encounter a error executing an ado command.
    So, I tried to set the constants on the page and it help but not
    entirely because I think this is a MDAC issue.

    Can anyone help please?

    Thanks!
     
    ivy, Oct 7, 2003
    #1
    1. Advertising

  2. ivy

    Bob Barrows Guest

    ivy wrote:
    > I have a problem lies with a meta tag. Below is my code:
    > <!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5
    > Library" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"
    > VERSION="2.5"-->
    > This is suppose to set a reference to a MDAC file which will hold many
    > constants. The error appears on the following line:
    > oComp.AddParam "@UserID", adVarChar, adParamInput, 100, msUserID
    > Error message.
    > Microsoft VBScript runtime (0x800A01F4)
    > Variable is undefined: 'adVarChar'


    Your meta tag is probably referring to the wrong version of ADO. see this
    page for the correct metadata tag for the version of ADO on your server:
    http://www.aspfaq.com/show.asp?id=2112

    >
    > I actually narrowed it down to an ADO (MDAC) issue. What I did was
    > that I included the adovbs.inc file which has all the constants
    > defined. Next, I ran the application. The error that I received
    > before went away but I encounter a error executing an ado command.


    What error?

    > So, I tried to set the constants on the page and it help but not
    > entirely because I think this is a MDAC issue.
    >
    > Can anyone help please?
    >

    Not without knowing the error.

    Bob Barrows
     
    Bob Barrows, Oct 7, 2003
    #2
    1. Advertising

  3. --
    compatible web farm Session replacement for Asp and Asp.Net
    http://www.nieropwebconsult.nl/asp_session_manager.htm

    "ivy" <> wrote in message
    news:...
    > I have a problem lies with a meta tag. Below is my code:
    > <!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.5
    > Library" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"
    > VERSION="2.5"-->



    > This is suppose to set a reference to a MDAC file which will hold many
    > constants. The error appears on the following line:
    > oComp.AddParam "@UserID", adVarChar, adParamInput, 100, msUserID
    > Error message.
    > Microsoft VBScript runtime (0x800A01F4)
    > Variable is undefined: 'adVarChar'
    >
    > I actually narrowed it down to an ADO (MDAC) issue. What I did was
    > that I included the adovbs.inc file which has all the constants
    > defined. Next, I ran the application. The error that I received
    > before went away but I encounter a error executing an ado command.
    > So, I tried to set the constants on the page and it help but not
    > entirely because I think this is a MDAC issue.
    >
    > Can anyone help please?


    Be sure you have ADO 2.5 installed and second, you should include that tag
    in global.asa but not within the <% %> tags!
    Third, do not use both. OR use advbs.inc OR use the metatag...

    > Thanks!
     
    Egbert Nierop \(MVP for IIS\), Oct 7, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. nita
    Replies:
    1
    Views:
    908
    Saravana
    Nov 20, 2004
  2. ronaldlee

    Transfer ADO Code to ADO.NET

    ronaldlee, Dec 17, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    494
    Kevin Spencer
    Dec 17, 2004
  3. Replies:
    0
    Views:
    1,346
  4. Navin
    Replies:
    1
    Views:
    770
    Ken Schaefer
    Sep 9, 2003
  5. ivy

    ADO (MDAC) issue

    ivy, Oct 7, 2003, in forum: ASP General
    Replies:
    0
    Views:
    128
Loading...

Share This Page