I receive the following error message in the Database Export Connector:
Error: Script #1 (Database Export Connector) [5 ERROR  [Microsoft][ODBC SQL
Server Driver][SQL Server] Error converting data type nvarchar to numeric.]
How can I resolve this issue?
The issue is that one of the Field Types being exported to the database is decimal type, and by default, the Support Locale Format option is checked (enabled).
The locale format for the Windows PC is set to enter an exponential expression after the decimal point: For example, during Validation, the value is entered as
The Field Type is saved as
4.e-002 because of the Windows locale setting.
The Database Export connector will send the value as
4.e-002 instead of
.04, causing the error.
The solution is to uncheck the Support Locale Format option for the Numeric Field Type that’s being exported.
Level of Complexity
Article # 3031387