SERVER NOT OPENING???

[121278]

i'm trying to access the reports via rdc
(asp samples from the seagate homepage aspxmps85.zip)

when opening one of the seagate reports they run correctly,
opening a report without database fields works,
opening reports with database fields fail,
must be a problem with the odbc con, i guess,
error message:
Error Occurred Reading Records: Server has not yet been opened

on one pc the whole thing is running although setup
is exactly the same - is it a web component error???

did anyone had this error yet, can someone tell me what
i did wrong???

 

[mthakershi]

Hi All Numbers,

You are very late to this trap. But it is never too late.

I got the same error month ago. My task was to work with reports upgraded from 7.0 to 8.5 with 8.5 runtime. Reports were having p2ssql or pdssql database driver (SQL server).

If you are using LogonServer method (with p2ssql or pdssql) to logon to the report database, it will give you this error. There might be no defects in the code but it is a cruel bug.

What you need to do is, if you can change your reports to have ODBC driver (pdsodbc.dll or p2sodbc.dll). You need to create one system DSN on the server machine and use that DSN in the LogonServer method instead of the database. Same think is working with p2soledb and pdsoledb drivers.

But if you have 8.5 runtime on the server, you can do this.

Post again if you have any further problems.

Have Fun,
Malay M. Thakershi
mthakershi@yahoo.co.in