3 Replies Latest reply on Jun 27, 2017 8:37 AM by mikebeargie

    Unable to get table definition when adding FileMaker as linked server

    sydneyshaw

      Hi guys,

       

      I'm unable to get any table definition when adding FileMaker as linked server is SSMS, does anyone know how I can remedy this?

       

      Also if I right click on a table, click script to then select into I get the following error:

       

      Enumerate columns failed for LinkedServer 'MY_LINKED_SERVER'.  (Microsoft.SqlServer.Smo)

       

      An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

       

      Cannot get the data of the row from the OLE DB provider "SQL Server" for linked server "(null)". Conversion failed because the data value overflowed the data type used by the provider. (Microsoft SQL Server, Error: 7346)

       

      Any help will be gratefully received!