8.5 vs 9.0 Set Location

[gleeb]

I am in the process of converting from CR 8.5 to CR 9.0 using ODBC to various SQL 7 datasources. In 8.5 a user was able to click set location, pick their DSN, log in, and then remap the first table. CR would then ask if you want to propagate the changes to the other tables. Pretty Easy.

When I try set location in 9.0, It has an area where you can supposedly click the database of the current connection and then replace it with a new one. I then have to go to every table and do the same thing. Has anyone run inot this and is there a fix. My users won't be able to handle it.

Thanks

 

[synapsevampire]

Yeah, I had the same thing, but I was trying to switch from using tables to using a Command object, here's the solution I ended up using:

http://support.businessobjects.com/library/kbase/articles/c2013530.asp

-k