Name redefined: 'adOpenForwardOnly'

Name redefined: 'adOpenForwardOnly'

There is only one instance of adOpenForwardOnly in the whole project.

I am therefore assuming that the file it is defined within is included twice.

However I have been unable to track this down.

I put a JavaScript alert at the top and botton of the file but I only ever get the alert 'Top' once, then the 'name redefined' error - I was expecting to get 'Top', 'Bottom', 'Top' then name defined error.

Can anybody give me some pointers for how to track this down.

Classic ASP
Windows 2003 Server
IIS6
RynertAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

daveamourCommented:
0
RynertAuthor Commented:
Sounds great but the site/download is no longer there!
0
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

RynertAuthor Commented:
That has a broken installation...

Back to square one!
0
Wayne BarronAuthor, Web DeveloperCommented:
Remove the 1 instance of
adOpenForwardOnly

You have it written twice, it is most likely in another page that is connected through an INCLUDE.
Just remove the 1 that the error is pointing to.
And then run your page.
And you should be good to go.

Carrzkiss
0
Wayne BarronAuthor, Web DeveloperCommented:
Can you provide some code please?
Also.
Do you call any include files within' a loop?
If you have an INCLUDE FILE within' a loop, then you are calling it many times.

Carrzkiss
0
daveamourCommented:
It will be in an include file and an include file explorer is the easiest way to find it!
Here is the asp explorer - I downloaded it ages ago.
http://www.audacs.co.uk/ee/ASPExp10.zip
 
 
 
0
Wayne BarronAuthor, Web DeveloperCommented:
Nice little program.
Might come in handy for structuring my projects.
The Treeview (Family Tree) is a good touch.

Carrzkiss
0
daveamourCommented:
Yes its a brilliant idea and so easy to write yourself too if you wanetd to.
I found it so valuable when working with other peoples messes!
 
0
RynertAuthor Commented:
@carrzkiss As I said in the OP there is only one instance, removing it leaves it undeclared when it is required.  That's why I suspect it is included twice.  

@carrzkiss  I can't upload the code - if I could do that it would be small enough for me to find it.  Lots of includes, which include includes, which include includes... No loop.

@daveamour That's the same App I tried to install before and your link craps out with installation error just the same.  Maybe it doesn't like XP?

0
daveamourCommented:
I just installed it myself and Carrzkiss did too.
I have it installed too on XP at work.
0
daveamourCommented:
PS - yes I knew it was the same app - I thought the one you had was corrupted.
0
Wayne BarronAuthor, Web DeveloperCommented:
@Rynert:
If you read my post at http:Q_24427985.html?cid=238#a24448150
You will see that I refrence how Nice the little program is.

It works.
If you are getting errors then there is a problem with your computer and the installer.
You might have some more issues that you are unaware of here.

Carrzkiss
0
daveamourCommented:
Do you maybe have another computer you can install on just to get your problem fixed.
Once you get this app working you wil fix it in 2 minutes I bet.
0
Wayne BarronAuthor, Web DeveloperCommented:
>>>>which include includes, which include includes...
Are you sure that you are not over-lapping that paticalur include within
Another page that is included into another page
Which is included into the page that is giving the error?

Do This. (As I mentioned before)
Remove the 1 single instance and run your page.
And see if it will load without errors?
If it runs then you are good to go.
IF it does not run, and gives you an error, then you will be in a better position to track it down.

Good Luck
Carrzkiss
0
daveamourCommented:
What if the instance removed is in an include which is used by other pages?
0
RynertAuthor Commented:
@ daveamour - installed it on the server and it worked ok.  However, the file that defines the variable is only in the tree once, where it should be.

None the wiser!
0
daveamourCommented:
Don't bother looking at the tree - you want a flat file representation of all your includes and then just search through that for adOpenForwardOnly
0
RynertAuthor Commented:
@carrzkiss - when I remove it from the one instance the SQL that needs it craps out.  It does not appear to be defined in a second place.
0
daveamourCommented:
Ok if you really can't get this wokring at all no matter how hard you try just replace all adOpenForwardOnly with 0 as in adovbs.inc:
http://www.academyx.com/resources/documents/adovbs.txt
 
0
RynertAuthor Commented:
@ daveamour - it's in the flat text file just once :(
0
RynertAuthor Commented:
@ daveamour - that is the file that is included, with the same value.

Going to set it up on a new IIS website to ensure it has nothing to do with the one I am trying on.

The pages work on another site, the only difference is some path and root domain changes.
0
daveamourCommented:
Do you have any of this stuff going off?  In Global.asa maybe.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RynertAuthor Commented:
<!-- METADATA TYPE="typelib" FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->

That is in the global.asa

Removed it and problem sorted!!!!!!!

Thanks :D
0
daveamourCommented:
Ok cool - should have thought of this ages ago as it used to be a common problem but I haven't done classic ASP seriously for many years.
Its ok to have that in Global.asa but not with adovbs.inc included too I think.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.