SQL Statement lenght limits for SQL Server Native Client and ODBC Driver for odbc
Hi, I have an application that use SQL Server from 2012 to 2022. It executes SQL Statements with up to 88.000 characters With SQL Server Native Client 2012 it works, however with ODBC Driver 18 for SQL Server it doesn't, ODBC limit the SQL Statement up to 65000 characters, I noticed this in SQL Profiler I will need ODBC Driver for SQL because SQL Native Client doesn't support sql server 2022 I don't know if there is a solution to this issue I'm using DELPHI and FireDAC for the development and I don’t need create a DNS to connect the application to the database, I set the necessary params to FireDAC so it does the connection thanks for your supporSQL Server 2012 Native Client
Microsoft SQL Server 2012 Native Client is being flagged an obsolete software and will stop receiving security updates starting July 12th, but I have done a lot of searching on the internet and getting a mixed results on whether this is true or not. So I figured I would ask here to see if anyone else is dealing with this situation and what conclusion can be made here. For example, Microsoft has a blog post regarding the software that says the software is obsolete on July 12th, which can be seen here: https://techcommunity.microsoft.com/t5/sql-server-blog/snac-lifecycle-explained/ba-p/385381 However, I have been told that there is an exception to the rule that says it is supported "in SQL Server 2012 through 2019 until their respective end-of-support lifecycles", described at the bottom here: https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-ver16 So I guess my ultimate question is: Will "SQL Server 2012 Native Client" still receive security updates post July 12th of this year?