Home Forums SQL Server 2005 T-SQL (SS2K5) OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column RE: OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column

  • I reply not because I know the solution but I want to share that I got the same problem with MySQL linked server (through ODBC). It seems that the problem occurs with columns with CHAR(1) and CHAR(2) data types when the data is empty. NULL does not create errors.

    I have searched for several hours and found no clear solution. Now all I can do is avoiding those columns in the queries.