Database Connection Info

[drofnarc]

Previously, I have used ASP and DHTML to produce simple on-line reports for my data (stored in a SQL Server database). I am attempting to replace those reports with something created in CR 8 that looks a little nicer than my plain html reports.

However, it appears that I have to pass the database connection info in the url (ex:?user0=blah&password=blah). This would be very unnacceptable in our environment. Can this information be stored directly into the .rpt file somehow or suppressed in some other way? With ASP, I could create the connection string on the server and users would never see it.

Also, even if I pass the user and pw info on the url, when I link to an On Demand SubReport it prompts the user for this information again. At the very least I would like to be able to pass this as parameter information to the subreport. Can this be done?

Thanks.

--Brad

 

[dcm]

Brad: Have a look at the SetLogonInfo method which enables you to pass the login variables in code David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[drofnarc]

I can't find any reference to a SetLogonInfo method. I'm using CR 8 Developer.

I've searched the help, looked through my 3rd party book and the index of the user's guide and I don't see any reference to anything like that.

--Brad