Whats happening is that I use the same db connections on my pages. and I use the same variable names. but I have one page calling another and I get this error:<BR><BR>Microsoft VBScript compilation error '800a0411' <BR>Name redefined <BR>/projects/forgotpwd.asp, line 3 <BR>dim DataConn<BR>----^<BR><BR>On that page I am going to access the database again and I want to use the normal variables it only seems to do it on this page? not all the rest?<BR><BR>So I want to ensure that the variable is no longer in memory so I can use it again.
Its indicating that you are declaring Dataconn in the same page twice. <BR>Please check it again in the page you are getting the error.<BR><BR>if you are including the connection object then don't declare it again.
Whether the variable holds a reference to anything is irrelevant. What's happening here is that you're trying to declare the same variable in two differnet places - in forgotpwd.asp and in an include file. Since includes are processed first this ends up looking like:<BR><BR>Dim DataConn<BR>...<BR>Dim DataConn<BR><BR>Which is always illegal. Removing the line Dim DataConn from forgotpwd.asp, line 3 should fix it.<BR><BR>Dunc