2. ASPRunnerPro General questions
  3. updates to source database
This topic is locked

updates to source database

 		2/29/2004 5:24:59 PM
ASPRunnerPro General questions
A
 apscnjohnnie author

I would like to use the source database to make updates to records instead of the edit version via asprunner. The users are use to using this method )via Access) and don't want to use the web interface to add/delete/edit records in asprunner. I have management that still want to view the results of the database via the asprunner interface. Can I somehow point the website to the actual database that is in use? No new columns will be created only add/delete records. That way they can continue to make changes to the database and all query results to the database will by dynamic in it's content.
Thanks,

Johnnie
Sergey Kornilov admin 2/29/2004

You can point ASP pages to your live database. Just use physical path to the database in connection string ( do not use Server.MapPath option ).
A
 		apscnjohnnie author 3/2/2004

Thanks. I got another error http://www.xlinesoft.com/asprunner/faq.htm#exclusively

so I just unchecked the Server.MapPath box and pointed to the place where I have my virtual directory pointing to. Instead of trying to go to the database on another server I think I will have the user come to the database. I am curious why I was getting that error though. Is it because none of the asp pages are created at the location of the database? I have checked permissions and all appropriate permissions are applied. I even opened it to everyone just to test but with no success.
Sergey Kornilov admin 3/2/2004

This error can happen for a number of reasons.
For example, you will see this error message when somebody opened a table in MS Access in design mode while other person connecting to this database via ASP.
Also I recommend to put ASP pages on the same server where database is located because network paths will be unaccessible for IUSR_... user in most cases.