I'm using IIS as a testing server for a musical instrument dealer's website. 99% of the data is to be displayed dynamically via an access database. Much of the asp programming is done and works fine (the whole site was created in Dreamweaver 8.2) but now i keep getting an error in explorer upon testing my latest page:

Error Type:
Microsoft VBScript compilation (0x800A0411)
Name redefined
/apm/Connections/conn_APM.asp, line 8, column 4
Dim MM_conn_APM_STRING

Conn_APM is the name of my database.

Basically, I'm coding the parameters to be added to each links URL on a homepage include. Specifically, upon clicking my "electric guitars" link i need it to query the database and display only electric guitars on the proceeding page (called product listings).

When i hover over the electric guitars link i see:

localhost/apm/product_listings.asp?SubCategoryID=1

The subcategoryID of 1 should display the correct items but i get an error page instead.

I'm a newbie to asp programming, having just read a book to learn how to implement it into my site.

Any suggestions?



Edited by - uncleremus on 25 Jan 2007 21:34:18

This has happened to me randomly several times. Dreamweaver will sometimes get confused and "re-include" the connection file. All you need to do to fix it, is open the page that is causing the error (product_listings.asp), and within the first few lines you will see a line of code that is duplicated. It will look someting like this:

<pre id=code><font face=courier size=2 id=code>&lt;!--#include file="../Connections/yourconfile.asp" --&gt;
&lt;!--#include file="../Connections/yourconfile.asp" --&gt;</font id=code></pre id=code>

All you need to do is remove one of these lines.

Edited by - flexman44 on 29 Jan 2007 22:18:38