ADO (MDAC) issue

[ivy]

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!

[Bob Barrows]

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

[Egbert Nierop \(MVP for IIS\)]

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

"ivy" <in*@xanedu.com > wrote in message
news:55******** *************** ***@posting.goo gle.com...

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!