I have a report that is based on a SQL stored proc with several input parameters. I am opening it from an ASP page. Is there any way to do this without using DSN's? I first tried to get this to work with a report that was based on an OLEDB connection, but anytime I tried to set the parameters instead of leaving the default, I got the error, Server has not been opened yet. I rebuilt the report based on a DSN, and have it working now, using SetLogonInfo and passing it parameters. But I would like to be able to use an oledb type connection string. Is there a way to do this, or should I just stick with DSN's. One thing I'm confused on: Why was I able to run the report with the oledb connection as long as I didn't set any of the parameters.
Thanks,
Shanti Miller
Thanks,
Shanti Miller