mxODBC

M.-A. Lemburg mal at lemburg.com
Mon Oct 22 13:20:43 CEST 2001


Ben C wrote:
> 
> Hi there,
> 
> I am pushing text data to a MS SQL Server DB using the mxODBC module
> which seems to work fine ... most of the time. One of the columns I am
> pushing this text to has the data type set to Text. However ... I am
> getting data truncation when attempting to upload some largish strings
> ~ 14kb ... the Text datatype should handle 2 gigabytes of data ... the
> warning message is as follows
> 
> Warning: ('22001', 0, '[Microsoft][ODBC SQL Server Driver]String data,
> right truncation', 4490)
> 
> Would this have something to do with a buffer size setting?
> 
> any suggestions most appreciated..

This could be a problem with the network buffer size used by the 
ODBC driver. Please check the MSDN for possible workarounds or
how to increase the buffer size.

-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
______________________________________________________________________
Consulting & Company:                           http://www.egenix.com/
Python Software:                        http://www.lemburg.com/python/




More information about the Python-list mailing list