Set DataSource Location Problem

[NewTerminator]

I have a Report that is created using rows returned by a Stored Procedure from SQL Server 7.0. The Report works fine, no issues with that.

Now i want to set the datasource location of the report to one more SQL Server where a copy of the same database exists.

When i try to do this i get an error message stating :

'Some tables could not replaced, as no match was found in the new datasource. Please specify the table required for any unmodified tables'. When i click on ok i get one more messaged saying 'Not Supported'

What does this mean? Can any one plz help me out of this. The databases in both the SQL Servers are identical.(latest backup of the first one exists on the 2nd one).

I even tried selecting only the Stored procedures in both the servers and updating it. Afer i do that i get a ADO Error Message with Error Code:0x80040e14 that also says "Incorrect syntax near ')' SQL State: 42000 , Native Error : 170" .

Both the Databases have the same name and run on SQL 7.0

Any solutions for the above will be appreciated.

Thanks,

The New Terminator

 

[StevenK]

Are you attempting to change the database table location through Crystal Reports itself (using Database->Set Location) or some other means ?
Steve

 

[NewTerminator]

Yes i am trying to the Set Location through Crystal Reports!

 

[shokti]

i believe you can achieve the same thing by using SetLogonInfo. i can switch to differrent sql server using SetLogonInfo.