467,923 Members | 1,178 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

Urgent help - setup test environment

I am new to ASP, but been asked to look into a production issue.
I was looking at the code and found this,

data_source = "driver={Microsoft Access Driver (*.mdb)};dbq=d:\database\clienthomedbo.mdb"

I would like to create a test environment in my C drive. So I copied all active server pages from the prodcution drive (D drive) to my C drive. I was going into each active server page code and changing d:\database\ to c:\work\projects\database\ inorder to point to my test environment which is my C drive. I have almost 200 active server pages. My question is is there a better way to setup my test environment other than copying all to my drive and then going in and changing the path?

Please treat this as urgent.

Jan 2 '08 #1
  • viewed: 1130
1 Reply
Expert 2GB
The better way to do this is set up a data source name "DSN" in control panel -> administrative tools -> Data sources, then you only need to refer to the data source name in your scripts and you only need to change its location once. Now that your scripts have already been written with a long file path, I don't see an easy way around going into each of them and changing them individually. Of course, you could write a script to make the change in each of them... Let me know if this answers your question.

Jan 3 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Tom Jones | last post: by
1 post views Thread by Kiran | last post: by
4 posts views Thread by Pete H | last post: by
16 posts views Thread by | last post: by
10 posts views Thread by shsandeep | last post: by
6 posts views Thread by globalrev | last post: by
2 posts views Thread by Scav | last post: by
3 posts views Thread by Jean-Paul Calderone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.