I am making a call to an API that is on SQL SERVER 7.0 and when I pass my parameters, I get an OLE error: Out of Present Range. The parameters I am passing are:

A begining date (character type)
An Ending Date (character type)
An Integer as a unique id.

Here is my thing, the value that is in my Integer variable (li_intval) is 67750. But when I change it to anything under 31000, it actually works fine. This also happens when I change the variable to a Numeric data type with the same value.

What could be happening? What is the syntax for making a variable an integer?

I am sorry if this questions makes no sense, the actual issue makes no sense to me as well.