topic SQL OLEDB CONNECTION ERROR: Arithmetic overflow error converting float to data type numeric. in QlikView

SQL OLEDB CONNECTION ERROR: Arithmetic overflow error converting float to data type numeric.

Navneet07 — Mon, 26 Jan 2026 21:26:37 GMT

Hi ,

While fetching one qlikview table i am facing the below issue
Error: Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Arithmetic overflow error converting float to data type numeric.

how to solve this issue

Re: SQL OLEDB CONNECTION ERROR: Arithmetic overflow error converting float to data type numeric.

Anil_Babu_Samineni — Tue, 12 Nov 2019 07:41:55 GMT

Is that error while creating the connection?

While fetching the data?

Can you please provide sample data how it is there in SQL side?

Re: SQL OLEDB CONNECTION ERROR: Arithmetic overflow error converting float to data type numeric.

Brett_Bleess — Thu, 14 Nov 2019 13:42:13 GMT

Here are a few Google posts I found, believe this is going to be something you need to solve on the SQL Server side of things, not QlikView.

https://blogs.msdn.microsoft.com/sqlforum/2011/04/19/forum-faq-why-do-i-get-a-arithmetic-overflow-error-when-assigning-1234-to-a-decimal52-variable/

https://stackoverflow.com/questions/19326520/arithmetic-overflow-error-converting-float-error-in-sql

About the best I have in addition to Anil's comment. If you did figure things out, consider posting what the issue was and then use the Accept as Solution button on that post to mark it as the solution to let others know that was the issue and the fix.

Regards,
Brett