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

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

Albert Graef wrote:
> Tim Haynes wrote:
>>> ==> sql DB "insert into data_nrg_101a values ('c', 'c', 'c', 'c', 'c', 
>>> 123, ?)" ("")
>>> sql_exec <<ODBCHandle>> "insert into data_nrg_101a values ('c', 'c', 
>>> 'c', 'c', 'c', 123, ?)" ""
>>> Empty strings in parameters are not accepted, no error message.
> 
> The strange thing is that it doesn't even give back an error there, as
> the relevant code at line 622 in modules/odbc/odbc.c does check for an
> error condition in the return code of SQLBindParameter().

Yes, this is indeed a bug in odbc.c (the SQL statement is freed before
the error code is retrieved). I've fixed this now, so that the proper
error code HY104 is reported. Of course this doesn't solve the original
problem, but at least sql_exec returns a proper odbc_error term now.

-- 
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