The server was crashed and reformatted from Win2003-SQL7 into Win2003-SQL2000, and the application can not gives out the report...
I modified the error in rpt file and it gives me :
Error returned: 20614 meaning: Starting background processing failed. (on IE it'll gives "User session has expired")
I'd checked the rpt itself and it gives me the right report, so it shouldn't be a problem with the query string in the report.
hence the problem may lies in the odbc and the connection string in asp.
my first question is, should the login in dsn file setting be the same with the connection parameter in the asp file ? or can I use the file dsn with different valid SQL login in the connection string ?
Thanks in advance,