"User Session has expired" error

[mmaz]

Hello,

I'm calling Reports (CR8) from ASP, using OLE DB connection to a SQL Server db on a server. I have about 20 reports, some with subreports, some without.

Here's my problem:

reports that have a subreport: works perfectly
reports that do not have a subreport: "user session has expired" in a message box, and "server has not yet been opened" with a response.write.

I know that a connection is being made to the db, because my recordset is not empty, but the .TestConnectivity method returns False (no connection to the server) for the report without a subreport.

Note:
+ I previously had an ODBC connection to SQL Server and everything worked fine. I started having those problems after changing ODBC to OLE DB...
+ After changing the connection, I cannot open my reports in Crystal Reports without first Logging on to the server (Logon/Logoff Server under File menu)...

What's the problem? Any tips would be appreciated. I've already read all the documentation I could find about those problems on Seagate's web site... didn't find anything that helped.

Thank you in advance!

Marie

 

[mmaz]

Please disregard this post. I've solved the problem. It had something to do with the db driver.

 

[siri]

mmaz i am facing the same problem that u mensioned the first post.

but i am getting this errors (user session has expired on report viewer message box And Server has not yet been opened with response.write) when i am connecting to remote SQL Server using ODBC connections.

it's working fine on my local sql server.

please help how to solve this problem.

thanks in advance