Error opening table in linked server with Objects Explorer:

Error opening table in linked server with Objects Explorer:


contains nocolumns that can be selected or the current user does not havepermissions on that object. Reply The message "contains no columns that can be selectedor the current user does not have permissions on that object" indicatesthat the query to obtain the data you have obtained the tables using the SQL Server ManagementStudio Object Explorer Wizard. Unfortunately, this wizard does not supportoperation with third-party ODBC sources. We cannot influence this behavior. This means that, toobtain the data from table, you can use the following query without using thewizard: Select * From [LinkedServerName]...[table]


    • Related Articles

    • Error when creating a Linked Server with ODBC Drivers: "The specified DSN contains an architecture mismatch"

      The error "The specified DSN contains an architecture mismatch" occurs due to a difference in architecture between the ODBC driver and SQL Server. To ensure proper operation of the Linked Server, the ODBC driver must be installed on the same machine ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

    • Error created linked server with ODBC Drivers. Error: "Data source name not found"

      Please note that the error "Data source name not found" occurs because Microsoft SQL Server cannot access the driver. To resolve this issue, please ensure that the driver is installed on the same computer as the Microsoft SQL Server instance that you ...

    • Table script generation (dbForge Studio for SQL Server)

      In order to create the table script, you may open the "Depends on" node for the procedure, choose all objects (tables), and choose the following command in the pop-up window which will appear: Generate Script As->Create->To New SQL Window. Once this ...

    • Lost Connection to MySQL Server

      If you are experiencing a loss of connection to MySQL servers (applies to any server), we would like to highlight that in most cases, this issue is not related to our product (dbForge). Typically, this problem can be resolved by following the ...