Our client is trying to export their data from their FileMaker 10 database into a MS SQL system via ODBC.
We have the DSNs set up, and can import date and number fields, but text fields fail with:
“requested conversion is not supported” Cannot get the current row value of column “[TQG6]...[Referral].ReferralAccountName” from OLE DB provider for MSDASQL for linked server “TQG6”
We've updated the ODBC drivers to SequeLink 6.0 Also tried with a temporary FileMaker 11 server and related driver.
It looks like there is a problem converting from FileMaker's rather generic 'Text' data type to SQL Server's more specific Char, Varchar or Text fields (and their unicode equivalents, nchar, etc.).
I encountered this exact same issue attempting to communicate with a FileMaker 12 server from MS SQL. This version of FileMaker uses a proprietary "FileMaker ODBC" driver. We resolved the error by selecting "Describe text fields as long varchar" in the ODBC configuration.