Bug report #14368
MSSQL datetime field type error with memorylayer
|Affected QGIS version:||2.8.4||Regression?:||No|
|Operating System:||Windows||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||invalid|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||22351|
Mssql Server fields of datetime type cannot be added to a memory layer. If QGSFIELD is a List (with members of Type QgsField), derived from a Mssql Server Table layer connected to QGIS,
This is for both, tables that are connected using the MSSQL driver and tables that are connected over ODBC. However, the same procedure is successful, if the destination layer aMemoryLayer is a file based Shapefile. So it seems, that only Memory Layer Storage Types are affected by this bug.
The MSSQL Server Version is 2012.