Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Enterprise
Expertise: Intermediate
Jun 2, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Avoid ODBC Truncation Warnings From MS SQL Server

You can use ODBC settings to avoid truncation warnings from MS SQL Server. These warnings occur when the application tries to insert or update data that is larger than its length in the database. The default behavior of the ODBC driver is to return these warnings to the application. You can change this behavior using ODBC DSN configuration settings. The ODBC Data Source Administrator is present in the control panel of Windows NT 4.0 and Windows 95 machines. The dialog box shows the setting as a check box with the caption "Use ANSI nulls, paddings and warnings." If this check box is unchecked then the ODBC driver will not return truncation warnings to the application if connected to this configured DSN.
KulBhushan Sharma
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date