[Haskell-cafe] Re: HDBC/ODBC using mysql appears broken...

[John Goerzen]

On 11/04/2010 04:03 PM, Neil Davies wrote:
> John
>
> 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? ;-)

- John

>
> returns
>
> [[SqlByteString "1MD16BBV00F74"],[SqlByteString "1MD16BB700D03"],[SqlByteString "1MD16BBH02DCD"]]
> *** Exception: Prelude.(!!): index too large
>
> if that helps..
>
> Neil
>
> On 4 Nov 2010, at 19:41, John Goerzen wrote:
>
>> On 11/04/2010 01:39 PM, Neil Davies wrote:
>>> Hi
>>>
>>> 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
>> http://www.haskell.org/mailman/listinfo/haskell-cafe
>
>