×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

ODBC question

ODBC question

ODBC question

(OP)
I have to troubleshoot asp stuffs that's using odbc connection into sql server, using crystal report.
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,

RE: ODBC question

Unfortunately, I cannot help with asp although with on ODBC connection, since you are downgrading, did you have it originally set to use SQL Native Client or SQL Server.  Native client did not exist for SQL 2000.

You may need to reset the report connections as well.

If at first you don't succeed, then sky diving wasn't meant for you!

RE: ODBC question

(OP)
Well, that's just what I did few days ago...more and less...made new db user and set the report to use that new user instead...along with that changing the username and password in the asp file.

Thanks for replying though.
Anyway problem is solved.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close