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

[expired user #8144]'s profile image [expired user #8144] posted 9 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 9 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 from ansgarbecker, 9 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 9 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 9 years ago Permalink
Forgot to answer - works back fine. Thanks Ansgar.

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