SSI

Hey,
   I'm pretty new to asp but I'm working on a page that uses it and has two ADO connections. A friend of mine suggested that instead of putting the ADO code in the main page that I use a SSI, which I thought was great but then realized that I couldn't get it to work. Anyway here is what the code looks like.
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\Inetpub\wwwroot\asp\Orders.mdb"
%>
<%
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select [DEALER NAME], Address, CITY, STATE, Zip From [CURRENT ORDERS] WHERE ORIGIN='Z00'", conn
%>
<%
for each x in rs.Fields
      Response.Write(x.value & "<br />")
%>
      <%next%>

This is the file included with this string
<--!#include file="C:\Inetpub\wwwroot\asp\ADO\consignee.asp"-->

If anyone knows why this might not work I would appreciate any help.
StratocasterAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

GaryCommented:
You shouldn't put the literal path in the include tag e.g.

If the include file is in the same folder
<--!#include file="consignee.asp"-->

If its in folders below the current folder prefix the folder path to the filename
<--!#include file="asp\ADO\consignee.asp"-->

If you want to go up a directory (and then down another folder path, ../ tells the server to go up one folder level
<--!#include virtual="../asp/ADO/consignee.asp"-->

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
StratocasterAuthor Commented:
Gary,
   Thanks for the reply. I actually figured out after I posted this question that I didn't need the full pathname in the include but, since you had the right answer the points are yours.

Thanks again.

Stratocaster
GaryCommented:
Glad you got it sorted but why the grade of B?
StratocasterAuthor Commented:
Gary,
   Tha only reason I didn't post an A is because the A grade seemed to be for over-achievement like posting links to reference materials and that sort of thing. You got an A in my book though.

I really do appreciate the help Gary.

Thanks,
     Stratocaster.
StratocasterAuthor Commented:
Lunchy,
     Thanks for the post. I do understand the grading policy.. in fact I re-read it right before I awarded a grade to this reply. I was however in a bit of a rush since I was at work while I was replying to this response. I do think that Gary should receive an A for his post. It did after all effectively answer the question I posted. I apologize to Gary for mis-grading his answer.


Thanks,
    Stratocaster
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
Web Languages and Standards

From novice to tech pro — start learning today.