Solved

Error writing to DB

Posted on 2014-02-13
4
239 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 32

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:
ScottPletcher 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL server 2008 SP4 29 33
Backup Job question 4 19
How to find duplicates in SQL Server 3 21
Base1 Encode/Decode 3 30
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
A short article about problems I had with the new location API and permissions in Marshmallow
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

708 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

17 Experts available now in Live!

Get 1:1 Help Now