vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

Cant use null at the "Database" property

Open finete opened this issue 3 years ago • 6 comments

I have a database without a database name, when I push TEST CONNECTION it connects. However I cant save the connection as It's a required property.

image

image

finete avatar Nov 03 '20 12:11 finete

I have the same issue, I want to create/save a connection to a server, without providing a specific database. Maybe specifying a database is mandatory for some engines, but in my case (MariaDB) it should be an optional field, and databases/schemes/... should be listed upon connecting to the server.

I attached a screenshot of how it is done in PHPStorm:

image

Zutatensuppe avatar Nov 12 '20 13:11 Zutatensuppe

For MSSQL, is it possible to leave this blank and the Broswer view show the schema tables for ALL the DBs instead of the one which is currently selected?

metalshanked avatar Apr 11 '21 04:04 metalshanked

Maybe try using the "Connection String" option and set a string that doesn't name a database. For example with the MySQL driver:

mysql://username:password@server:port/

Make sure you don't omit the trailing slash.

gjsjohnmurray avatar Jan 06 '23 17:01 gjsjohnmurray

Maybe try using the "Connection String" option and set a string that doesn't name a database. For example with the MySQL driver:

mysql://username:password@server:port/

Make sure you don't omit the trailing slash.

where is this setting?

seems like a large oversight to make this field required when neither engine actually requires it

safejace avatar Apr 28 '23 19:04 safejace

where is this setting?

image

gjsjohnmurray avatar May 04 '23 10:05 gjsjohnmurray

Still assumes the instance with the name of the user.

saltybaker avatar Feb 14 '24 23:02 saltybaker