Re: Unable to access views and stored procedures from asp

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxx> wrote in message
news:1116941516.687174.321740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxx
>


.

Relevant Pages

  • Unable to access views and stored procedures from asp
    ... This is manju, I am not able to execute views and stored procedures ... Back end is SQL SERVER. ...
    (microsoft.public.sqlserver.odbc)
  • Re: USE Command With Dynamic Database Names Fails to Change Database
    ... "Changes in database context last only until the end of the EXECUTE ... > stored procedures. ...
    (microsoft.public.sqlserver.programming)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)
  • Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC ... I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... > having executing Sysbase stored procedures via JDBC. ... > stored procedure which contains DDL and with AutoCommit set to false I ... > The explanation for this behaviour I have found is that the JDBC ... > I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)