sydneyshaw

Unable to get table definition when adding FileMaker as linked server

Discussion created by sydneyshaw on Jun 27, 2017
Latest reply on Jun 27, 2017 by mikebeargie

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!

Outcomes