zwieback89
Programmer
Hi,
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.
Regards,
Padmaja.
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.
Regards,
Padmaja.