[BUG] Selecting multiple databases in a session errors out in SQLServer

[expired user #8144]'s profile image [expired user #8144] posted 10 years ago in Creating a connection Permalink
Using 92.2 4958 build
SQL Server 2014
US regional settings

When I select multiple Databases in the drop down in session manager, I get an "SQL Error (0): Invalid connection string attribute" when trying to connect. No issue if only one Database is selected.
Note that the string in Databases screen field shows as semi-comma delimited - wonder if 9.2 was not hardcoded to parse based on comma (Europe). However, weird is 9.1 worked fine.

Regards, Yannick
ansgar's profile image ansgar posted 10 years ago Permalink
That's because v9.2 supports MS Azure hosts, where you need to pass a database in the connection string ("Database=xyz"). HeidiSQL uses the database(s) setting for that purpose. This is wrong - I think I should not do that if it's more than one database in the list.
Code modification/commit d741514 from ansgarbecker, 10 years ago, revision 9.2.0.4959
MSSQL: Do not pass "Database=xyz" to connection string if database(s) setting contains more than one database. See http://www.heidisql.com/forum.php?t=18559
ansgar's profile image ansgar posted 10 years ago Permalink
Done in r4959. Works fine here. Please update HeidiSQL and see if that works for you.
[expired user #8144]'s profile image [expired user #8144] posted 10 years ago Permalink
Forgot to answer - works back fine. Thanks Ansgar.

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