Servermap path

Customer Support H-Sphere Shared Hosting
1

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

2

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

3

[QUOTE=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
[/QUOTE]

thanks Yash,

I will give it a try

Topshed

4

[QUOTE=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

5

umm… no, that statement is incorrect

[CODE]<%
Dim sPath

sPath = Server.MapPath(“../mydb.mdb”)

cnnSearch.Open “Provider=Microsoft.Jet.OLEDB.4.0; Data Source=” & sPath
%>[/CODE]

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