azure sql managed instance – Getting Invalid Field Size error using ODBC for column of datatype varchar(max)

admin

I migrated a database to an Azure SQL Server Managed Instance.
When I try to do a SELECT on a specific column, I get this error:

Invalid Field Size

The column is defined as VARCHAR(MAX).

I get no error if:

  • I query Azure SQL Server MI via SSMS (20.2)
  • I query the old on premise database via SSMS (20.2)
  • I query the old on premise database via ODBC Driver 17 for SQL Server
  • I query the old on premise database via SQL Server Native Client 11.0 (v. 2011.11)

Any of the ODBC driver with Azure end up errorring out for that specific column.

The ODBC drivers are 32 bit. Application using them need it like that.

Read more here: Source link