I have a crystal report which connects to an iSeries box via an OLE DB datasource, however i need to have this same report conect to two different iSeries, with the tables for the sql (command) located in two different libraries.
Is it possible to change the command in vb (as well as the connection etc) so i can change the box and library t execute the sql against at run time ?