readODBC box, truncation error messages

[Lucy_dor]

when using the readODBC box, I get this error messages:

ODBC Warning 'FetchScroll': continued:State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
ODBC Warning 'FetchScroll': continued:State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation

 

[Support]

when using the readODBC box, I get this error messages:

ODBC Warning 'FetchScroll': continued:State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
ODBC Warning 'FetchScroll': continued:State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation
State:01004, Native Error Code:0, Error Text: [Microsoft][ODBC Driver 17 for SQL Server]String data, right truncation

this is because the database failed to report correctly the length of a cell. No Worries. Just put "2000" in this parameter here:

if "2000" is not enough, continue increasing the number up to the point the error disappear