ODBC Sql Server Error
Posted: Wed May 16, 2018 9:52 am
Hi all,
I have a problem when I try to write into a Sql Server Db (from db2), and the datatype of target column is "money".
the log show this errror: ODBC function "SQLExecute" reported: SQLSTATE = 22018: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver]Invalid character value for cast specification (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 731)
I tried also this: change (column_name,",",".") but in this case the job write always 0 (0,00).
My ODBC properties:
Array size: 1
Fail on size mismatch: No
Fail on type mismatch: No
Drop unmatched fields: No
Code page: Default
Fail on row error: Yes
Have you any suggestion?
Thanks and regards.
Antonio
I have a problem when I try to write into a Sql Server Db (from db2), and the datatype of target column is "money".
the log show this errror: ODBC function "SQLExecute" reported: SQLSTATE = 22018: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver]Invalid character value for cast specification (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 731)
I tried also this: change (column_name,",",".") but in this case the job write always 0 (0,00).
My ODBC properties:
Array size: 1
Fail on size mismatch: No
Fail on type mismatch: No
Drop unmatched fields: No
Code page: Default
Fail on row error: Yes
Have you any suggestion?
Thanks and regards.
Antonio