Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
I set the login information for Crystal Reports from ASP using the following code...
set crtable1 = session("oRpt".Database.Tables.Item(1)
crtable1.SetLogonInfo "<DSN>", "<Databasename>", "username", "password"
Is there a way to assign the SetLogonInfo parameter in the form of a string... similar to the connection strings that we specify in global.asa??
so that in the code we can have
crtable1.SetLogonInfo CR_Connection_String
and CR_Connection_String can be provided in global.asa as an Application variable
We have a lot of reports... So, if the login info is hardcoded and the password changes for the user-id, it will be difficult to change it in each page. If we have a connection string which could be assigned, then we need to provide the change in info at only one place.
Any idea how to accomplish this?? I tried but it didn't work out...
I set the login information for Crystal Reports from ASP using the following code...
set crtable1 = session("oRpt".Database.Tables.Item(1)
crtable1.SetLogonInfo "<DSN>", "<Databasename>", "username", "password"
Is there a way to assign the SetLogonInfo parameter in the form of a string... similar to the connection strings that we specify in global.asa??
so that in the code we can have
crtable1.SetLogonInfo CR_Connection_String
and CR_Connection_String can be provided in global.asa as an Application variable
We have a lot of reports... So, if the login info is hardcoded and the password changes for the user-id, it will be difficult to change it in each page. If we have a connection string which could be assigned, then we need to provide the change in info at only one place.
Any idea how to accomplish this?? I tried but it didn't work out...