vrs
vrs copied to clipboard
SQL Server Plugin does not populate flight table under SS2017
See forum posting here: https://forum.virtualradarserver.co.uk/viewtopic.php?f=11&t=1914&p=8896#p8884
SQL Server is complaining that @HadSpi is not a parameter for the Flights_Insert procedure. However, it is a parameter and the same parameter & call works fine on earlier versions of SQL Server.
This looks like a case sensitivity issue. Looking through the code the casing of HadSPI is always: HadSPI, except in one location in the code for the SQL Server plugin. If the collation of the database being used for the data in SQL Server happens to be case sensitive It will fail like this, regardless of MSSQL Version.
I'll clone and try and reproduce later when I've got a moment and try to create a PR soon(tm).