Link to home
Start Free TrialLog in
Avatar of rahul kumar
rahul kumar

asked on

Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Oracle][ODBC][Ora]ORA-00942: table or view does not exist

dim rs
dim user1
dim pass1
dim role
dim strsql

set rs=server.CreateObject("ADODB.Recordset")

if session("user")="" then
      Response.Redirect "loginpage.asp"
end if




'Response.Write session("user")
strsql="select granted_role from user_role_privs"
rs.Open strsql,Session("conn")
role=rs.Fields(0)
rs.Close()
set rs=nothing
'-----------for war alert...-----------

if session("user")="ADMINISTRATOR" or role="CSG_ROLE"  then
            
            
            set rs=server.CreateObject("ADODB.Recordset")
            strsql="select WARRANTY_DT,asset_no from tabasset where WARRANTY_DT<=(sysdate+90) and WARRANTY_DT>=(sysdate-30)"
            rs.Open strsql,session("conn"),3 ( Shows Error in this line)
            'Response.Write rs.Fields(0)
            if not rs.EOF then%>
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

It seems that your user has no privilegies on table tabasset.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.