Unable to access views and stored procedures from asp -- sql server odbc

manju
5/24/2005 6:31:56 AM

hai all,

This is manju, I am not able to execute views and stored procedures
but able to excute tables. Back end is SQL SERVER. I am accesing
database tables , views and stored procedures from ASP.

Error while executing views and stored procedures

Error: Object not found.

All the tables , views and stored procedures have same user name and
are created using query analyser. All have access permissions.

Thaks
Manju
kanna_manju2000@krify.com

Uwa Agbonile [MSFT]
5/27/2005 3:12:27 PM

Not much information to go on here but I would advise
1. Make sure you are in the right database context
2. Make sure you are using the right schema context to access the views and
procs objects

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Uwa Agbonile[MSFT]

[quoted text, click to view]

sql server odbc : Unable to access views and stored procedures from asp