ASP calling stored procedure not working after sql 2k to 2k5 upgrade

[mdwu]

I had an asp script the exec stored procedure in sql 2000. I have upgrade to sql 2005 and it doesn't exec the stored procedure anymore. no error in sql log or event viewer. It's seems like it not doing anything. Anyone know if I need to do something special (coding changes, permission changes, etc)

Thanks.

 

[Qik3Coder]

can you still run the stored proc correctly from query analyzer?

-The answer to your problem may not be the answer to your question.

 

[mdwu]

Qik2Coder, thanks for the reply.
Yes, I can run the stored prodecure within SQl Management studio fine. It just that seems like the asp page when calling for the stored procedure it's not doing anything.

 

[Qik3Coder]

can you run other stored procedures okay? What i am getting at is whether or not you can touch the database. You may need to modify your connection string in your web.config

-The answer to your problem may not be the answer to your question.