Re: Select on Foreign table is not working

Holger Jakobs <holger@xxxxxxxxxx> · Wed, 11 Jan 2023 09:37:48 +0100



    Am 11.01.23 um 09:12 schrieb Sahil
      Khan:

    
        Hi,
        

        Hope you are doing
          well,
        

        I have created a
          foreign table on my postgresql server to select the data on
          external table which is reside on MS SQL Server, everything
          went well from installing to freetds and installing and
          configuring tds_fdw tool, and created foreign server and user
          mapping then created foreign table, but when i do select from
          table_name then it throws an error which is i mentioned below
          as.
        

        ERROR:  DB-Library
          error: DB #: 20018, DB Msg: General SQL Server error: Check
          messages from the SQL Server, OS #: -1, OS Msg: , Level: 16

        
        will be highly
          grateful for your valuable suggestions, where to look for to
          get this done.
        

        Thank You.
        
          
                    Regards,
                  Sahil |
                      +919892569610
                
              
    I would suggest to do as the
        message says:
        Check messages
        from the SQL Server
    So, the log on the foreign
        server should have more information, which isn't forwarded to
        PostgreSQL:
    Kind Regards,

        Holger

      
    -- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
  

Attachment:
OpenPGP_signature

Description: OpenPGP digital signature