Re: [q-lang-users] ODBC connection with MS Access

[Albert G. <Dr....@t-...>]

Tim Haynes wrote:
> The error code, HY104, is `Invalid precision or scale value'; `The value
> specified for the argument ColumnSize or DecimalDigits was outside the
> range of values supported by the data source for a column of the SQL data
> type specified by the ParameterType argument'. So what it's saying is when
> you're binding to a char field, a length of 0 is not permitted.

Tim, you hit the nail on the head there! :)

Access doesn't like a zero precision, not even for NULL parameter
values. This is clearly an Access-specific problem, MySQL and PostgreSQL
both work fine. I also digged through the ODBC docs, but nowhere does it
say that a NULL or empty string parameter is supposed to need a nonzero
precision, so I consider this a bug in the Access ODBC driver.

Anyway, I worked around the bug by adding an extra dummy byte for both
strings and () values, so that the precision value is never zero now.
Seems to work fine so far. I'm currently uploading a new release
candidate (7.11rc2) so that you can give it a whirl.

Jiri, could you please try the Qpad-7.11rc2.msi in testing and see
whether it works for you? You can download the msi here:
http://sourceforge.net/project/showfiles.php?group_id=96881&package_id=188958&release_id=568981

Albert

-- 
Dr. Albert Gr"af
Dept. of Music-Informatics, University of Mainz, Germany
Email:  Dr....@t-..., ag...@mu...
WWW:    http://www.musikinformatik.uni-mainz.de/ag