dbeaver / dbeaver/dbeaver

Connecting to MS SQL server - can query against DB2 linked server objects, but can't browse in Navigator

Open
#3,148 7 comments 10 reactions 0 assignees View on GitHub
x:mssql xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

Good afternoon. I'm using DBeaver EE 5.01 to connect to a MS SQL Server that has a linked server connection to a DB2 server.

I can see the MS SQL databases in the Database Navigator, but not other server objects. I would like to be able to browse (and autocomplete) the objects on the linked server, but can't figure out how to do it in DBeaver. I'm having to do this work SSMS instead. :-/

Queries against the linked server tables work just fine, but they can't be browsed in the Database Navigator.

This happens for both the jTDS and the Microsoft drivers.

Thank you for any ideas or assistance that you can provide.
Cheers, --Nick

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.