System.Runtime.InteropServices.COMException (0x80040E37): Invalid object name

Posted on 2007-09-28
Last Modified: 2013-11-26
Getting this message on VB App when trying to run on server - works great on my XP machine.....

System.Runtime.InteropServices.COMException (0x80040E37): Invalid object name 'A'.
   at ADODB.ConnectionClass.Execute(String CommandText, Object& RecordsAffected, Int32 Options)
   at PNOC.mssql_connect.Get_Records(String& strSQL)
   at PNOC.mainform.ProcessData(String& strFile)
   at PNOC.mainform.Timer1_Tick(Object eventSender, EventArgs eventArgs)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Question by:tmhechler

    Author Comment

    Oops...forgot to say...PLEASE HELP!  My applciation was working FINE..then the SQL log file for the DB became "FULL"....Applcation crashed....I get same error now as when it initially crashed. (I have been rebuilding/republishing for two days now, trying to figure this out).

    This is a shared server, so someone could have made changes to it that I am unaware of....however, I've checked the logs for the time it crashed, and don't see anything except for the fact that the LOG file got full (which I have rectified now with a scheduled DTS package to shrink once a day...)

    LVL 21

    Accepted Solution

    I believe this can be a sql error.  You might display the exact sql being run and then eyeball it or try it from query analyzer.

    Author Comment

    Thanks.  The query ran fine.  However, while in SQL I did check a few other things out, and it ended up being a bad update trigger on the main table.  So, your answer led me to the issue.  Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    760 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

    15 Experts available now in Live!

    Get 1:1 Help Now