Hi there

Does anyone now how to make work a database up the httpdocs directory like "httpdocs\db\mega.mdb"

If i try to access it i got an error, then i look it up on the logs of the iis and it says that the server map goes to

c:\inetpub\vhosts\default\db\mega.mdb ???????

And on my asp conection string i put this.

conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/db/mega.mdb")
' conn.Open("DSN=MEGA-48")

and i create a dsn pointing to the dir

I don't know what to doo, the only thing is that if i put it on the root of the site..it works perfectly but i need to fix it coz my clients don;t want to put the db on the home dir ...so anyone can download it....

Thanks!!

Diego
.

 

When you want to know the real path to the database file. Run this script in the directory of the database:

Just put it in a example.asp (or something like that)
<%
Response.Write Server.MapPath(Request.ServerVariables("PATH_INFO"))
%>
this line shows the real path to the databasefile.

View this example on: http://mappath.denit.net

You can add this path it in the plesk control panel under odbc. Test the connection et voila.

Do not forget to set write permissions on the database file.

 

Deny .mdb downloads

Hi

You can safely put .mdb files in your root folder, I've had to do the same for my ColdFusion databases (httpdocs/databases).

I use URLScan to deny access to .mdb extensions (throws an error) on the server.

http://www.microsoft.com/windows2000/downloads/recommended/urlscan/default.asp

Just add .mdb to the denied extensions section.