sowais:

Update: Never mind, I answered the wrong question below. I'd suggest adding RaiseError=>1 to your database handle constructor.

Inside the log data is ERROR: 1 '[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)'. So it looks like one of your columns is an incompatible data type, and isn't automatically converting from string to that data type.

Looking at the parameters, I'd guess that you've got a date column in table, and that the date isn't specified in a way that the driver understands.

I've had that sort of problem before, and solved it by changing the SQL to something like:

insert into recordcount values (?, ?, ?, ?, convert(datetime, ?, 120),
+ ?)
[download]

...roboticus

When your only tool is a hammer, all problems look like your thumb.