Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Connecting to DB from ASP pages

Connecting to DB from ASP pages

Connecting to DB from ASP pages


There have been some people who tried to help me with this, but I could not find an answer to this question. If anyone has experienced this problem, then please do let me know how this can be solved.

Whenever we develop the reports, we need to set the database location by specifying the database server and the table or view which we want to refer to.

I have come to a stage where there are a large number of reports - reports and sub-reports. Last two times, when I shipped these reports to UK, a person over there had to manually change the database server all over again because it pointed to an entirely different server even though it had the same database. Similarly, when we send these reports to the customers where they have a local database server, the same thing has to be done then as well.

It really takes a lot of time to change the database server location in each and every report.

What I wanted to ask in this perpective was is there a way where we can give instructions from the ASP pages such as the Database Server Name, Database Name just in one place and then the reports uses this to refer to that database server. Tables or views are the same.

I have used the SetLogonInfo property and I have not been able to pass the Database ServerName and the Database Name, but I do definitely want to get rid of changing the database server (Using the Database-> Set Location method) everytime we send it to some client site for demonstration or to a new laptop for sales guys.

Hope to hear some positive feedback on this.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close