Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Set Location required when I change my database server..

Status
Not open for further replies.

Vinodpillai

Technical User
May 12, 2001
18
0
0
IN
I am using Oracle as backend, Segate V7.0 as report tool. I fire reports using crystal control on a vb form. to connect i use Microosft odbc DSN and send the user id and password.
My problem is when I change the database server to a different machine with same user id and password, i need to reverify all reports. Goto each report and do a set location on the tables used.

Every time i need to do a uat all my reports need to be set location . To move it onto production, I again need to do a set location. How do i avoid or solve this problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top