[Haskell-cafe] Re: HDBC/ODBC using mysql appears broken...
jgoerzen at complete.org
Thu Nov 4 17:09:24 EDT 2010
On 11/04/2010 04:03 PM, Neil Davies wrote:
> simple queries seem to work fine.
> main = do
> db<- connectODBC connect'string
> quickQuery db "select serial from CPE_DEVICE" >>= print . take 3
> describeTable db "CPE_DEVICE"
I'm going to guess that the MySQL ODBC driver isn't implementing the
metadata stuff, which is kind of weak in ODBC in general.
Can I interest you in PostgreSQL or Sqlite3? ;-)
> [[SqlByteString "1MD16BBV00F74"],[SqlByteString "1MD16BB700D03"],[SqlByteString "1MD16BBH02DCD"]]
> *** Exception: Prelude.(!!): index too large
> if that helps..
> On 4 Nov 2010, at 19:41, John Goerzen wrote:
>> On 11/04/2010 01:39 PM, Neil Davies wrote:
>>> I've been trying to get the "hello world" example below to work:
>>> main = do
>>> db<- connectODBC connect'string
>>> get Tables db>>= print
>> I wonder if you might try something other than getTables, which requires some metadata support on the backend? Some simple inserts orselects, perhaps?
>> Haskell-Cafe mailing list
>> Haskell-Cafe at haskell.org
More information about the Haskell-Cafe