adUseServer Constant Undefined

I have an ASP page in which I reference quite a few ADO constants such as
adOpenStatic, adLockReadOnly and they work fine but a reference to
adUseServer comes up as undefined?

I have a typelib definition in that page:

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

For the time being I used the constant 2 to replace that reference - I hope
that is correct?

Any ideas on why that constant remains undefined?

--
------------------------------------
Wayne Wengert
wayne@wengert.org

Curt_C
Sun Sep 14 14:09:20 CDT 2003

do an INCLUDE of the adovbs.inc file


--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------


"Wayne Wengert" <wayne@wengert.org> wrote in message
news:e612lpueDHA.2432@TK2MSFTNGP11.phx.gbl...
> I have an ASP page in which I reference quite a few ADO constants such as
> adOpenStatic, adLockReadOnly and they work fine but a reference to
> adUseServer comes up as undefined?
>
> I have a typelib definition in that page:
>
> <!--METADATA TYPE="typelib"
uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
>
> For the time being I used the constant 2 to replace that reference - I
hope
> that is correct?
>
> Any ideas on why that constant remains undefined?
>
> --
> ------------------------------------
> Wayne Wengert
> wayne@wengert.org
>
>

dlbjr
Sun Sep 14 14:15:22 CDT 2003

If Using Stored Procs:

Try to add SET NOCOUNT ON as a very first statement inside each SP.
It may fix your problem with returning result and improve performance as
well.

--
dlbjr

Unambit from meager knowledge of inane others,
engender uncharted sagacity.

Wayne
Sun Sep 14 14:37:07 CDT 2003

But that is what the typelib reference is supposed to take care of isn't it?
All the other constants work?

Wayne

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:eMAkhOveDHA.392@TK2MSFTNGP12.phx.gbl...
> do an INCLUDE of the adovbs.inc file
>
>
> --
> ----------------------------------------------------------
> Curt Christianson (Software_AT_Darkfalz.Com)
> Owner/Lead Designer, DF-Software
> http://www.Darkfalz.com
> ---------------------------------------------------------
> ..Offering free scripts & code snippits for everyone...
> ---------------------------------------------------------
>
>
> "Wayne Wengert" <wayne@wengert.org> wrote in message
> news:e612lpueDHA.2432@TK2MSFTNGP11.phx.gbl...
> > I have an ASP page in which I reference quite a few ADO constants such
as
> > adOpenStatic, adLockReadOnly and they work fine but a reference to
> > adUseServer comes up as undefined?
> >
> > I have a typelib definition in that page:
> >
> > <!--METADATA TYPE="typelib"
> uuid="00000205-0000-0010-8000-00AA006D2EA4" -->
> >
> > For the time being I used the constant 2 to replace that reference - I
> hope
> > that is correct?
> >
> > Any ideas on why that constant remains undefined?
> >
> > --
> > ------------------------------------
> > Wayne Wengert
> > wayne@wengert.org
> >
> >
>
>

Bob
Sun Sep 14 14:42:59 CDT 2003

Wayne Wengert wrote:
> But that is what the typelib reference is supposed to take care of
> isn't it? All the other constants work?
>
This usually means you referenced the wrong version of the type library. See
here for the version-specific references:
http://www.aspfaq.com/show.asp?id=2112

You can determine the ADO version by checking the Version property of the
connection object.

HTH,
Bob Barrows

Wayne
Sun Sep 14 20:32:11 CDT 2003

Ah ha...

I suspect that is it - I'll pursue that.

Wayne

"Bob Barrows" <reb_01501@yahoo.com> wrote in message
news:uWp$lhveDHA.2576@TK2MSFTNGP11.phx.gbl...
> Wayne Wengert wrote:
> > But that is what the typelib reference is supposed to take care of
> > isn't it? All the other constants work?
> >
> This usually means you referenced the wrong version of the type library.
See
> here for the version-specific references:
> http://www.aspfaq.com/show.asp?id=2112
>
> You can determine the ADO version by checking the Version property of the
> connection object.
>
> HTH,
> Bob Barrows
>
>

lukezhan
Mon Sep 15 01:51:29 CDT 2003

Hi Wayne,

What is the version of MDAC installed on your computer? I have MDAC 2.8
installed, and following code seems to work:

<%@ Language=VBScript %>

<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

<html>
<head>
<title>Test Page</title>

</head>
<body >

<%



dim re

set re=server.CreateObject("adodb.recordset")

re.CursorLocation = adUseServer

re.CursorType =adOpenStatic

%>


</body>
</html>

By the way, you are right that the value for adUseServer is 2.

Luke
Microsoft Online Partner Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)