adUseServer Constant Undefined

Wayne Wengert · Sep 14, 2003

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:



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?

Curt_C [MVP] · Sep 14, 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 said:
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" -->

dlbjr · Sep 14, 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.

Wayne Wengert · Sep 14, 2003

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

Wayne

Bob Barrows · Sep 14, 2003

Wayne said:
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 Wengert · Sep 15, 2003

Ah ha...

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

Wayne

MSFT · Sep 15, 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 %>



<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.)

Global.asa	1	Apr 23, 2004
ADO (MDAC) issue	2	Oct 7, 2003
Help! CDO.Send returns error '8004020f' -- why???	6	Feb 19, 2004
CDO.Send - does not appear to work sending to outside domains.	5	Feb 19, 2004
2 global.asp questions	2	Jul 21, 2003
Can't attach attachments in email using ASP CDO	15	Aug 23, 2004
"CDO for Windows 2000 Library" on Exchange 2003	3	Oct 25, 2005
Non-constant constant strings	561	Jan 19, 2014

adUseServer Constant Undefined

Wayne Wengert

Curt_C [MVP]

dlbjr

Wayne Wengert

Bob Barrows

Wayne Wengert

MSFT

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads