Solved

Error writing to DB

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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

630 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