Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SetLogonInfo parameter in Crystal Reports...

Status
Not open for further replies.

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 &quot;<DSN>&quot;, &quot;<Databasename>&quot;, &quot;username&quot;, &quot;password&quot;

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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top