So I am using a Connect In DB tool to read data from Microsoft SQL Server. I have set the connection in ODBC Admin and connect it to the Microsoft SQL Server. And I find a place where I can choose different databases. But the database that I need to connect is not showing up. The structure in the SQL Server is SQL Server/System Databases/master, so I could only choose master here. But the database I need is SQL Server/<other databases>/<the database>. How could I change reading System Databases to <other databases>?
Solved! Go to Solution.
You change it in your ODBC admin configuration where I have squiggled out mine with the black pen. Tick off the "Change the default database :" and enter the database you want to connect to.
Sorry, this is my fault. I should have used the OLEDB connection rather than ODBC connection.