2. ASPRunnerPro General questions
  3. Using the same database in two different projects
This topic is locked

Using the same database in two different projects

 		3/26/2007 3:40:59 AM
ASPRunnerPro General questions
R
 rdstaff author

I want to create two types of ASP pages, each which use the same database. I need a set of pages that allow a handful of users to login and edit the database and another set of ASP pages that let web users search and sort the entries in the database without any ability to edit.
Example: When I select my MS Access database file the program writes a new copy of the database and puts it into a db folder which I then publish to my server. These are the ASP pages that I'm now using to login and edit the database. So now when creating a second project how do I correctly write the file path so that it looks at the database which is the one that is being updated on the server rather than creating another copy of the database and putting it in it's unique db folder?
OR is there a different way that I should be going about doing what I'm trying to do?
V
 		Vladimir 3/26/2007

Dawna,
you should uncheck Use Server.MapPath option on "Database File" tab in ASPRunner and rebuild project. Then move your database to special folder with write and read permissions on your webserver. There must be a folder at your server designed specially for storing database. To specify folder path contact admin of your web-hosting.

Then you need to move database file to that directory and update connection string accordingly.
http://xlinesoft.com/asprunner/docs/troubl...ery__errors.htm
R
 		rdstaff author 3/26/2007

Vladimir,
Thanks for your response. It shows me that I was on the right track. I did figure that I needed to change the default Server.MapPath string and I found the asp include file which specifies the connection string. The db is in a folder with the proper permissions but for some reason I'm having trouble writing the connection string properly (as I'm not a programmer). Can you give me advice on how to write the connection string? I know this is such a simple thing I'm trying to do but for some reason I can't seem to get the right combination.
Dawna
J
 		Jane 3/27/2007

Dawna,
here is the step-by-step instruction on how to modify connection string:

http://xlinesoft.com/asprunner/docs/troubl...ery__errors.htm