Servermap path

[topshed]

Hi I am moving over from brinkster where I need a fairly long map path

ie:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\premfs8\sites\premium1\ursname\database dir\blah.mdb;" & _
"Persist Security Info=False"

From reading stff in hear I understan the database goes into the root (login) Directory
So should my map path be a simple


cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=blah.mdb;" & _
"Persist Security Info=False"

Or am I missing something ?

Thanx Topshed

 

[Yash]

No, this would be correct:

Data Source = Server.MapPath("../blah.mdb")

Make sure you request Parent Paths to be enabled on your domain (by opening a ticket) otherwise that would generate an error

 

[topshed]

No, this would be correct:

Data Source = Server.MapPath("../blah.mdb")

Make sure you request Parent Paths to be enabled on your domain (by opening a ticket) otherwise that would generate an error

thanks Yash,

I will give it a try

Topshed

 

[topshed]

thanks Yash,

Well I took a ticket and they fixed it but I still get an error or just a blank screen. I am using :

cnnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = Server.MapPath("yadyada.mdb")"

Any ideas welcome

Topshed

 

[Yash]

umm... no, that statement is incorrect

<%
Dim sPath

sPath = Server.MapPath("../mydb.mdb")

cnnSearch.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & sPath
%>

I'm really not an ASP expert but that should work.