'Server has not yet been opened' error message

[selvirino]

I am attempting to run a simple report through ASP (ActiveX report viewer & RDC) connected to a SQL Server 2000 stored procedure. The code fails on the following line:

session("oRpt&quot.ReadRecords

And I receive the following error message:

Server has not yet been opened.

The report runs fine in the Crystal Reports development GUI. The stored procedure is fairly simple, and requires one parameter. There are no subreports.

Any help will be most appreciated.

Greg

 

[bdotzour]

I ran into this problem and it took me a long time to figure out.

My problem was that I wasn't setting the logon info for the tables I was trying to access.

I don't know how this applies to using a stored procedure, but I had to do this:

Report.Database.Tables.Item(1).SetLogonInfo <server> <database> <user> <pass>

Then my problem went away.