x

how to solve the run time error '-2147217865(80040e37)'

how to solve the run time error, '-2147217865(80040e37)' microsoft[odbc sql server driver] (sql server), invalid object name'ecounter--parcelcoddisasterrecover

more ▼

asked May 15, 2014 at 08:29 PM in Default

avatar image

gagan
1 1 1 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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:

 SELECT * FROM sys.tables WHERE name = 'MyTableName'

 SELECT * FROM MyDatabaseName.SchemaName.MyTableName


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.

more ▼

answered May 15, 2014 at 10:08 PM

avatar image

ThomasRushton ♦♦
42.2k 20 57 53

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2034

asked: May 15, 2014 at 08:29 PM

Seen: 2924 times

Last Updated: May 15, 2014 at 10:08 PM

Copyright 2018 Redgate Software. Privacy Policy