Solved

Error writing to DB

Posted on 2014-02-13
4
242 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
4 Comments
 
LVL 59

Expert Comment

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

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now