u have to follow the following steps while changing the database connection : -
Once you've opened the document on your local server, to change it to point to your local database, use the "Change Datasource Location..." option from the Database menu.
From the resulting dialog box, click on the bottom line (i.e. the Stored Procedure name or table name ) in the tree control in the upper box, then choose the OLE DB ADO option from the tree control in the lower box.
This leads to another dialog box, choose Microsoft OLE DB Provider for SQL Server. From the next dialog box, enter your Database Server, User Id., Password and Database. Click Finish to point to your new database.
You then need to re-point to the Stored Procedure or table name . In the tree control in the lower box, new db branches will appear. Choose Stored Procedure then find the stored procedure or table name matching the name in the top. Once you've found the right one, click on the Update button. Once you have done this, click on Close.To check all is ok, click on the Verify Database option from the Database menu
Edited by purva - 12 Mar 2007 at 1:03am
IP Logged
