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!

ASP, CR, and SQL Server connection types

Status
Not open for further replies.

shmiller

Programmer
Aug 16, 2001
103
US
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
 
This issues is with how the CR binds to the SPROC via the ODBC driver vs a native connection OLEDB
 
I'm not sure what you mean, could you give me some more details?
Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top