I keep getting the following error:


Microsoft VBScript compilation error '800a0411'

Name redefined

/databass/site/globals/adovbs.inc, line 15

Const adOpenForwardOnly = 0
------^




what am i doing worng?

That just means you're trying to define the same constant twice, so you either have it twice in your copy of adovbs.inc, or else its defined in your asp page (or another include called from that page) as well as in adovbs.inc.

A simple text search will enable you to find the duplicate ocurrence which you need to delete.

hth
Phil

Instead of adding the include to every page Put this tag in your global.asa file

<!-- METADATA
        TYPE="typelib"
        FILE="C:\Program Files\Common Files\System\ADO\msado20.tlb"
-->

Now you never have to use the include for adovbs.inc ever again!

full reference http://www.4guysfromrolla.com/webtech/110199-1.shtml

Just a note of caution:
As Owain mentioned in http://p2p.wrox.com/topic.asp?TOPIC_ID=2990
you should beware of .inc

A detailed discussion of INCLUDE:
http://www.4guysfromrolla.com/webtech/020400-2.shtml