Forum Discussion

ErikFerney's avatar
ErikFerney
Copper Contributor
Mar 16, 2024

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 suppor

Resources