Relative path to my database on ipower...
I have no idea if being on an ipower server makes any difference. It seems that I've encountered different protocals depending on the ISP. In any case, I hoping there are some common denominators that apply so here's what I've got...
I'm using a Global.asa doc.
Where does it go? Does it go in the wwwroot directory or is it positioned outside that directory? Then, what should the script look like? Here's the way I have it on my C drive...
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
Session("dbConn_Connection
End Sub
</SCRIPT>
How will it look on an ipower?
I appreciate the help...
I'm using a Global.asa doc.
Where does it go? Does it go in the wwwroot directory or is it positioned outside that directory? Then, what should the script look like? Here's the way I have it on my C drive...
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
Session("dbConn_Connection
End Sub
</SCRIPT>
How will it look on an ipower?
I appreciate the help...
Put your global.asap in your wwwroot directory or any virtual directory you create. Each virtual directory starts it's own ASP space, so you can use a different global.asa per virtual directory. For you, it looks like you need it in your root.
ASKER
Does my path need to be anything more than Data/Shiny.mdb provided it's in the root directory?
you could just put your connection string in a file and include that file on all the pages instead of using the session object.
db.asp______
<%
Dim connstring
connstring = "Provider=Microsoft.Jet.OL
%>
___________
anypage.asp____
...
<!--#include file="../Connections/db.as
<%
dim conn
set conn = server.CreateObject("ADODB
conn.open connstring
...
______________
db.asp______
<%
Dim connstring
connstring = "Provider=Microsoft.Jet.OL
%>
___________
anypage.asp____
...
<!--#include file="../Connections/db.as
<%
dim conn
set conn = server.CreateObject("ADODB
conn.open connstring
...
______________
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So the code would look like:
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
Session("dbConn_Connection
End Sub
</SCRIPT>
The big thing is that I'm not including "C:/Inetpub..." etc because I'm not on my computer, correct? This is for my ISP so I don't need to worry about that. Also, since I'm putting this in my root directory and there isn't a BSP folder, I'm going right to my Data folder, correct?
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Sub Session_OnStart
Session("dbConn_Connection
End Sub
</SCRIPT>
The big thing is that I'm not including "C:/Inetpub..." etc because I'm not on my computer, correct? This is for my ISP so I don't need to worry about that. Also, since I'm putting this in my root directory and there isn't a BSP folder, I'm going right to my Data folder, correct?
Try this on YOUR computer, it will work too :)
Server.MapPath will map a virtual directory to it's physical location :)
Yes on Data folder so:
Provider=Microsoft.Jet.OLE
Have you been able to test any of this?
Server.MapPath will map a virtual directory to it's physical location :)
Yes on Data folder so:
Provider=Microsoft.Jet.OLE
Have you been able to test any of this?
ASKER
The ipower protocol had me document the path like this: C:/Accounts/bigshiny/wwwro
Thanks for the feedback!
Thanks for the feedback!