vscode-sqltools
vscode-sqltools copied to clipboard
Cant use null at the "Database" property
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.
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:
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?
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.
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
where is this setting?
Still assumes the instance with the name of the user.