CODEWITHSUNDEEP
databasevisual-studioserver-explorer
John Gaby
John Gaby

Reputation: 1522

Visual Studio 2017 Show Table Data does not work

I am using Visual Studio 2017's 'Server Explorer' to connect to a Microsoft SQL database. I set up the connection and successfully connect to the database and can see the tables. However when I choose the 'Show Table Data' from one of the tables, I get the error 'An unexpected error occurred while populating the table or view information.'

Interestingly, if I execute the query: 'SELECT * from table' for the same table, this seems to work correctly and shows the table data.

Note also, that if I use Visual Studio 2010, I can connect to this same database and everything works as expected.

Does anyone have an idea why this does not work in the 2017 version?

Thanks.

Upvotes: 1

Views: 1031

Answers (1)

Guppy
Guppy

Reputation: 426

I solved it by deleting the connection and adding it again. No need for restarting. I use Microsoft Visual Studio Community 2019.

Upvotes: 0

Related Questions