crystal news datasource remap
i am operative clear reports ms sql server.
i need remap clear news indicate opposite database same sql server. there an involuntary proceed doing this, i have remap each unparalleled report? i am now doing adding new information connection, following updating stored way specified paramether change database(catalog). also, after remaping, .asp displays news crashes this:
active server pages, asp 0115 (0x80004005)
a trappable blunder (e06d7363) occurred an outmost object. book can't continue running.
the formula is:
set mainreporttablecollection = session("orpt").database.tables
for any mntable mainreporttablecollection
mntable.connectionproperties
.item("user id") = "<some_login_name>"
.item("password") = "<some_password>"
.item("dsn") = "<some_dsn>"
.item("database") ="<some_database>"
finish with
next
it runs, however, i critique out final twin assignations.
thanks advance.
yours trully, silviu.
Comments
Post a Comment