Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

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.

 

 

Sitemap