2. ASPRunnerPro General questions
  3. Live Data vs DB Folder
This topic is locked

Live Data vs DB Folder

 		10/1/2003 23:11:42
ASPRunnerPro General questions
V
 vbrimley author

Hi,
Is it possible for ASPRunner to pull data from a live mdb via a virtual folder <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=185&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' /> in IIS. Simply put can I have a mdb on another box with a virtual folder configured on my web server and have an ASPRunner SQL statement extract data? If so please tell me how to do it.
Thanks In Advance
Sergey Kornilov admin 10/3/2003

Hi,
your connection string usually points to db/database.mdb. If you create a virtual directory on your Web server named db and point it to directory on another server this will give you exactly what you need.
Best regards,

Sergey Kornilov
V
 		vbrimley author 10/7/2003

Sergey,
I really appreciate you taken the time to respond to lack of knowing. That being said Runner creates the db folder no matter what I do if I use server.map. Any other ideas?
Thanks In Advance.

Virgil
Sergey Kornilov admin 10/7/2003

Virgil,
I'm not sure I understand your question.
Did you try to use method I described in my previous message?

Did you have any problems doing this?
Best regards,

Sergey Kornilov
V
 		vbrimley author 10/11/2003

Sergey
Yes, I did try your previous post. It did not work it simply created the db folder and added the mdb, even though I have a VD setup with the name db.
Sergey Kornilov admin 10/12/2003

Hi,
after DB folder is created and database is copied to that folder you can delete this DB folder to force ASP engine use your virtual directory named DB that resides on another box.
Best regards,

Sergey Kornilov
V
 		vbrimley author 10/12/2003

Hello Again,
Got your test email, my reply was returned undeliverable. I understand exactly your advice however once the db folder is removed I get access errors. I am pretty certain that priviliges are set correct to the vd folder in question.
V
 		vbrimley author 10/16/2003

Sergey
If possible can I send a sample of the file and a detailed description of where the file actually resides and how I point to it?
V
 		vbrimley author 10/17/2003

Sergey,
Thanks for the input I back tracked myseld and found that the vd and the location of the generated files were at different dir levels. Problem resolved!