In DB Connect to Micrsoft SQL Server unable to find related database
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Database Connection
- In Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sorry, this is my fault. I should have used the OLEDB connection rather than ODBC connection.
