Re: Query problems

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: A-Face (AFace_at_discussions.microsoft.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 14:09:06 -0800

Sorry I forgot to mention connect.asp is an #include file posted at the
beginnning of every page, that is how all the pages are running off the db.

"Bob Barrows [MVP]" wrote:

> A-Face wrote:
> > mydb is defined in connect.asp:
> > <%
> > Option Explicit
> > Dim myConn, mydb, rs, rs2, sql
> > mydb = "DRIVER={Microsoft Access Driver
> > (*.mdb)};DBQ=e:\webareas\sa143\CHIS\CHIS.mdb"
> > Set MyConn=Server.CreateObject("ADODB.Connection")
> > myconn.open mydb
> > set rs = server.createobject("ADODB.Recordset")
> > set rs2 = server.createobject("ADODB.Recordset")
> > %>
>
> Your current page does not know the variables defined in another page unless
> you #include that other page
>
> >
> > So since evrything is already defined somewhere, I can't make sense
> > of the problem.
>
> Define mydb in this page.
>
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>