I want to create a cross connection query. The query will mainly source from Oracle and some of it will source from SQL Server. I connected to both systems and clicked to open a cross connection editor, but then the Object Explorer will only display the tables from the SQL Server connection…nothing happens to the connection tree view when I click/double-click on the Oracle connection. I have tried changing the explorer to use a different display mode than connection tree, but it will not change to drop down, etc.
Another strange thing is that if I right-click the Oracle connection and select View Details…it does display the details of the first table in that connection…but I can’t see that table or any others from Oracle in the Explorer.
Version 188.8.131.528 (32 bit)