Solved

no globa.asa, but have error Name redefined /test/lib/adovbs.inc, line 14, column 6

Posted on 2001-06-08
11
505 Views
Last Modified: 2012-05-04
i don know why, I have been searching for global.asa but
there is not such file in my w2k.

but when i remove this include adovbs.inc file, i have no
problem running the file, but when i try to do searching
i got error

ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.
/test/listing-search.asp, line 88

which is this line:

objPagingRS.CursorLocation = adUseClient


for your info, this is my page architecture

default.asp <- login.asp
            <- content.asp (also include  searching.asp)
            <- search_form.asp


klia
0
Comment
Question by:klia
11 Comments
 
LVL 2

Expert Comment

by:_marko_
ID: 6167108
Hi!

Try this and tell me if it solves anything:

objPagingRS.CursorLocation = 3

-Marko
0
 

Author Comment

by:klia
ID: 6167115
new error come out. i think all the variable use in adovbs.inc can't use???

objPagingRS.Open strSQL, objPagingConn, adOpenStatic, adLockReadOnly, adCmdText


FYI, listing-search.asp & search_form.asp can execute
without any error.

thanks for prompt reply
klia
0
 

Author Comment

by:klia
ID: 6167122
i mean in the listing-serch.asp (did include adovbs.inc)


klia
0
 
LVL 11

Expert Comment

by:ASPGuru
ID: 6167147
did you included the same file twice?

i mean if you look at the including tree you probably get the same file more than once at the root:

e.g.

fileA
    fileX
    fileB
    fileC
        fileX

in this example fileA includes fileX twice....
0
 
LVL 20

Expert Comment

by:Silvers5
ID: 6167151
you need the adovbs.inc.. can you post more code
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 11

Accepted Solution

by:
ASPGuru earned 50 total points
ID: 6167154
or you defined a variable/constant with the same name in the main page and in an included page....

if you don't find the problem yourself, then post your pages and we'll find it for you...
0
 

Author Comment

by:klia
ID: 6167163
ok,

this is default.asp :


<TABLE WIDTH="760" BORDER="0" CELLSPACING="0" CELLPADDING="0" HEIGHT="363"><TR BGCOLOR="212c77"><TD HEIGHT="91" COLSPAN="2"><FONT COLOR="#FFFFFF" SIZE="4" FACE="Arial, Helvetica, sans-serif"><B><FONT SIZE="+6">&nbsp;Alai
Osai</FONT></B></FONT> </TD></TR><TR BGCOLOR="#6571A3"><TD WIDTH="170" BGCOLOR="#6571A3" ALIGN="CENTER">
<TABLE WIDTH="150" BORDER="0" CELLSPACING="0" CELLPADDING="0" NAME="login" BGCOLOR="#FFFF33" ALIGN="CENTER"><TR BGCOLOR="6571a3"><TD>&nbsp;</TD></TR><TR BGCOLOR="212c77"><TD><FONT COLOR="#FFFFFF" SIZE="3"><B><FONT FACE="Arial, Helvetica, sans-serif">&nbsp;&nbsp;LOGIN</FONT></B></FONT></TD></TR><TR><TD>
<!--#include file="login.asp"--> </TD></TR> <TR BGCOLOR="6571a3"><TD HEIGHT="17">&nbsp;</TD></TR></TABLE><TABLE WIDTH="150" BORDER="0" CELLSPACING="0" CELLPADDING="0" NAME="Browse"><TR><TD>&nbsp;</TD></TR><TR BGCOLOR="#FFFFFF"><TD>Browse</TD></TR><TR><TD>&nbsp;</TD></TR></TABLE><TABLE WIDTH="150" BORDER="0" CELLSPACING="0" CELLPADDING="0" NAME="search"><TR><TD>&nbsp;</TD></TR><TR BGCOLOR="212c77"><TD><FONT COLOR="#FFFFFF" SIZE="3"><B><FONT FACE="Arial, Helvetica, sans-serif">&nbsp;&nbsp;SEARCH</FONT></B></FONT></TD></TR><TR BGCOLOR="#66FFFF">
<TD> <!--#include file="search_form.asp"-->
</TD></TR> <TR><TD>&nbsp;</TD></TR></TABLE></TD><TD VALIGN="MIDDLE" ALIGN="CENTER">
<!--#include file="content.asp" --> <DIV ALIGN="CENTER"></DIV></TD></TR></TABLE><!--#include file="footer.asp"-->
</BODY>
</HTML>
0
 

Author Comment

by:klia
ID: 6167180
ok ok ....sorry ...my fault! i didn't check the code
properly (too many include files)

i found the problem.

thanks for your prompt reply and help.

klia


0
 
LVL 7

Expert Comment

by:weesiong
ID: 6167205
klia,

Better way, dont include any file:

objPagingRS.Open strSQL, objPagingConn, 3, 1, &H0001

:p



Regards,
Wee Siong
0
 
LVL 11

Expert Comment

by:ASPGuru
ID: 6167206
can you outline the include tree?

this is what we already know:

default.asp
    login.asp
    search_form.asp
    content.asp
        searching.asp
    footer.asp


where comes adovbs.inc into play?


also note, that instead of including adovbs.inc anywhere you could create a file named global.asa in your application root and put this text in it:

<!--METADATA NAME="Microsoft ActiveX Data Objects 2.5 Library" TYPE="TypeLib" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"-->


... now you can use the ADO constants in every asp file and don't have to include adovbs.inc...
0
 

Author Comment

by:klia
ID: 6167219
aspguru,

is it mean is just include this line will help?
(can easily reply the whole adovbs.inc)???

<!--METADATA NAME="Microsoft ActiveX Data Objects 2.5 Library" TYPE="TypeLib" UUID="{00000205-0000-0010-8000-00AA006D2EA4}"-->

then what for we have such a file (adovbs.inc)???

for in house development, i think no problem but i'm not
sure about the production place whether they allow global.asa file.

anyway, thanks for the help from everyone!!!!

what a shame for me, doesn't check properly. maybe not used
to much include files :-P

cheers!
klia
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now