how to solve the run time error, '-2147217865(80040e37)' microsoft[odbc sql server driver] (sql server), invalid object name'ecounter--parcelcoddisasterrecover
asked May 15, 2014 at 08:29 PM in Default
Either the object you're trying to select from doesn't exist, or you don't have permissions to access it, or your connection isn't in the right database, or your table belongs to a schema other than the default schema for your connection.
To test for these:
The first statement checks the current database for a table with the right name.
The second statement checks using a three-part qualified name, that should be good against your server.
Based on the output of these statements, you may be able to work out what's wrong.
answered May 15, 2014 at 10:08 PM