2. ASPRunnerPro General questions
  3. Hosting issue help
This topic is locked

Hosting issue help

 		4/5/2008 5:37:14 PM
ASPRunnerPro General questions
D
 dunga author

please help setting the dbconnection.asp file
currently hosting provider (godaddy) has provided a folder named "access_db" with all WRW permissions needed.

however here how is the folder structure:
root

----access_db

----output --this is the folder where I upload the asp generated files made by the asprunner.
here is the dbconnection file
<%

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("access_db\banknotes.mdb") & ";Jet OLEDB:Database Password="

%>
I have addedd .. like this but it did not work ((((((((((((((((((
<%

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("..\access_db\banknotes.mdb") & ";Jet OLEDB:Database Password="

%>
please help if possible.

thank you
Sergey Kornilov admin 4/6/2008

Second connection string looks fine.
What exactly didn't work?

Post exact error message here.
D
 		dunga author 4/7/2008

i figured it out.
here what the problems was:

  1. host creates a special folder called access_db - with all"appropriate permissions"
    howevere placing the database into this folder it does not allow to save into the access database.
  2. I have also changed permissions to the output folder to RW and that solved the problem.
    apparently one of the files in the output directory(where all asp files are located) requires a read/write permissions.
    which one I do not know.
    but to be sure I set same read-write permissions to all files in the application.
    thank you
    dunga
Sergey Kornilov admin 4/7/2008

Setting RW permissions to the whole output folder is a great security risk. Don't do this.
D
 		dunga author 4/8/2008

ok, <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=27740&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' /> then what files exactly I have to set RW permissions to, please?
Sergey Kornilov admin 4/8/2008

Just the folder where database resides.
If you use upload or import features set write permissions on corresponding folders as well.