Forum Discussion
ErikFerney
Mar 16, 2024Copper Contributor
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
1 Reply
Sort By
- dkgdbaCopper ContributorHi,
Check more details at below link for ODBC related issues:
https://madesimplemssql.com/odbc-driver-17-for-sql-server/