Refresh issue with multiple scheme database

Ruh's profile image Ruh posted 7 years ago in General Permalink

I'm using more than one scheme in my databases. When I first open the DB in the treeview, no schemes are displayed and when I click on a table I get an error message "Invalid Object Name". After an explicitly refresh everything work fine.

Any thoughts?

ansgar's profile image ansgar posted 7 years ago Permalink

Not really.

Could you please add some more details, like server version and session configuration. And please ensure you are on the latest HeidiSQL build.

Ruh's profile image Ruh posted 7 years ago Permalink

Thx for your quick answer.

HeidiSQL is up to date. Database is SQL-Server 2014 Express.

See picture1: First click to database. Picture2 is after explicite refresh.

2 attachment(s):
  • Picture1
  • Picture2
ansgar's profile image ansgar posted 7 years ago Permalink

Hm, I have the same SQL server running on my PC, but cannot reproduce that behaviour. Is there something I am missing? Probably you have a specific schema in your session configuration?

Ruh's profile image Ruh posted 7 years ago Permalink

Made some tests again and found a way to reproduce it:

  1. Start up HeidiSQL
  2. Click on a database with only dbo scheme.
  3. Click on '+' (1) to expand tree view of database with multiple schemes. ==> Error occure, no scheme name displayed and error message when I click on a data table But, if I click to the database (2) name after second step everthing works well.

Maybe that helps you.

1 attachment(s):
  • Picture3

Please login to leave a reply, or register at first.