In ODBC data source System DSN
Add new DSN
Name = test
Desc = test
server = lksql
user login id and password enterer by user
check Connect to sql server to obtain default setting
enter user name and pw
change the default database to: only has the default db the user is assigned on the sql server.
I’ve tried typing a db – error The database entered is not valid.
If I remove the check mark from Connect to SQL server to obtain default settings for the additional configuration options and leave authentication using login id and password checked, I can add the db and the test works.
But when I reopen I get error The database entered is not valid.