John Goerzen wrote:
GЭnther Schmidt wrote:
Kyra I've tried any sort of values to any sort of columns. I tried "insert into somesinglecolumntable (someNumbercolumn) values (?)" [toSql 5] ... and so on.

So I'm not certain at all the error message does actually give the right clue.

It just blows no matter what.

It seems, I've managed to track down the issue.

Access ODBC driver doesn't support sqlDescribeParam.

bindCol (Database/HDBC/ODBC/Statement.hsc) contains the following stub for this:

          do poke pdtype #{const SQL_CHAR}
             poke pcolsize 0
             poke pdecdigits 0

This does not work.

I've made an experiment replacing 'poke pcolsize 0' with 'poke pcolsize 255'. Now all integer or varchar bindings work!

It seems simpleSqlColumns or something similar must be used.

Cheers,
Kyra
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe

Reply via email to