bindParamenter issue: [Microsoft][ODBC Microsoft Access Driver]String data, right truncated
Posted: 29 Oct 2015 16:19
I have taken the example project "SimpleODBC". changed 1 line
%Stmt:setParameterValue(1, string(Name)),
Stmt:bindParameter_string(1, string::length(Name), odbcStatement::input),
And now the program errors with:
Native ODBC exception
Predicate name = execute
StatementString = insert into PersonBin(name, age, birthday, longfield) values
(?,?,?,?)
ChildClassName = odbcStatementSupport
SqlState = 22001
NativeErrorCode = 31
NativeErrorMessage = [Microsoft][ODBC Microsoft Access Driver]String data, right truncated
We have been working on same error message in our Project onsite, but using SQL Server driver.
Any help would be appreciated.
Thank you;
Kevin Allen
Kevin.Allen@McKesson.com
%Stmt:setParameterValue(1, string(Name)),
Stmt:bindParameter_string(1, string::length(Name), odbcStatement::input),
And now the program errors with:
Native ODBC exception
Predicate name = execute
StatementString = insert into PersonBin(name, age, birthday, longfield) values
(?,?,?,?)
ChildClassName = odbcStatementSupport
SqlState = 22001
NativeErrorCode = 31
NativeErrorMessage = [Microsoft][ODBC Microsoft Access Driver]String data, right truncated
We have been working on same error message in our Project onsite, but using SQL Server driver.
Any help would be appreciated.
Thank you;
Kevin Allen
Kevin.Allen@McKesson.com