Solved

Error writing to DB

Posted on 2014-02-13
4
245 Views
Last Modified: 2014-02-14
I am running the same codebase on two different sites.  When writing a record to the DB on one I am getting the following error:

Microsoft OLE DB Provider for SQL Server error '80040e14'
The request for procedure 'user_audit' failed because 'user_audit' is a table object.


I am attempting to write a record to a table called user_audit - there are no stored procedures or anything with the same name.

Same exact code works on another site - hosted on same server.  Is there anything IIS related that may cause this to error?  I am not seeing anything different between the two instances, but may be missing something.
0
Comment
Question by:ccleebelt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 39856878
What is the relevant SQL/ASP code?
0
 
LVL 34

Expert Comment

by:sarabande
ID: 39856880
I found the following regarding your error in the ms article http://support.microsoft.com/kb/173335 which is about a different problem:

The following scenario illustrates the problem:

 If User A (USERA) owns Table A (TABLEA) and runs EXEC USERA.TABLEA, the error message returned is:

The request for procedure 'USERA.TABLEA' failed because 'USERA.TABLEA' is a table object.

if that also applies to your issue, it would mean that the table was accessed by a user that is not the owner of the table.

Sara
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 39860612
It means your code attempted to "EXEC" a table name, which is not logical and of course not allowed.

You can produce a very similar error message in any db:

EXEC sys.tables
0
 

Author Closing Comment

by:ccleebelt
ID: 39860702
Ha..Turns out the problem was that D: was full,,,doh.
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question