Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

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