Home > Archive > MS SQL Server ODBC > May 2005 > Unable to access views and stored procedures from asp









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Unable to access views and stored procedures from asp
manju

2005-05-24, 9:23 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@krif
y.com

Uwa Agbonile [MSFT]

2005-05-27, 8:23 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]

"manju" < kanna_manju2000@krif
y.com> wrote in message
news:1116941516.687174.321740@g49g2000cwa.googlegroups.com...
> 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@krif
y.com
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com