I am trying to populate multiple cells in an excel sheet with the results of
a query executed on a sybase database.
I get the query parameters, which I get from some pre-defined cells in the
Excel sheet. Obviously, the parameter values vary and accordingly the query
executed gets different results.
This works perfectly or some cells, but for other cells I get this error:
[INTERSOLV][ODBC SQL Server driver] Timestamp parameters with zero scale
must have a precision of 13, 16, or 19. Parameter number: 3, precision:34.

Parameter #3 is a date and I am passing values like '4/1/2005' etc to it.
Not sure why it fails selectively, and does not even consistently fail for a
given value for the parameter - i.e. it can pass for one cell where
param3='4/1/2005' and fail for another cell where param3 is the same, but
param2 is different. Checked the db - the date field corresponding to param3
a null precision & null scale.

Query executes fine if executed directly on the sql db.
Thanks for any suggestions.