ADO (MDAC) issue
 

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!

Re: ADO (MDAC) issue
 

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

Re: ADO (MDAC) issue
 

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

"ivy" <ing@xanedu.com> wrote in message
news:55083c22.0310070751.5e38e597@posting.google.c om...
> 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!