vrs icon indicating copy to clipboard operation
vrs copied to clipboard

SQL Server Plugin does not populate flight table under SS2017

Open vradarserver opened this issue 5 years ago • 1 comments

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.

vradarserver avatar Sep 07 '19 11:09 vradarserver

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).

ge0metrix avatar Jul 27 '21 16:07 ge0metrix