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?
ODBC Driver 11 and above fails with Output parameter of type SQL_VARIANT
First published on MSDN on Jun 29, 2016 Problem:If you have an application which is using ODBC driver 11 or above and is executing a stored procedure with an output parameter of type SQL_VARIANT, the execution fails with the following exception:An error encountered: SQLState = HY000, NativeError: 0, ErrorMessage: [Microsoft][ODBC Driver 11 for SQL Server]Protocol error in TDS stream.
