haskelldb-users

[Haskelldb-users] haskelldb-hdbc-odbc

[Guenther S. <gue...@we...>]

Hi all,

how can I "connect" to an ODBC data base, ie. what do I need for "withDB" ?

Günther

Re: [Haskelldb-users] haskelldb-hdbc-odbc

[Justin B. <jgb...@gm...>]

For specifics on using HDBC-ODBC, you'll want to look at their
documentation. Each driver is a little different. Here is what i used
to connect to postgres:

import Database.HaskellDB.HDBC.PostgreSQL
...

login :: MonadIO m => String -> Int -> String -> String -> String ->
(Database -> m a) -> m a
login server port user password dbname = postgresqlConnect [("host", server),
  ("port", show port),
  ("user", user),
  ("password", password),
  ("dbname", dbname)]


On Sun, Apr 5, 2009 at 9:05 AM, Guenther Schmidt <gue...@we...> wrote:
> Hi all,
>
> how can I "connect" to an ODBC data base, ie. what do I need for "withDB" ?
>
> Günther
>
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Haskelldb-users mailing list
> Has...@li...
> https://lists.sourceforge.net/lists/listinfo/haskelldb-users
>

Re: [Haskelldb-users] haskelldb-hdbc-odbc

[Guenther S. <gue...@we...>]

Hi Justin,

I think I will try to use haskellDB as a template to create an AST and 
then just create SQL from that. Right now I don't really have the time 
to check out all of haskellDBs capabilities and then maybe find myself 
in need of something that can't be done within haskellDB.

Primarily I need to get in control of the wallpaper-sized SQL statements 
my app uses, it isn't really all that necessary to perfectly type safe, 
especially not the incoming part, ie. the results of the queries.

Thanks for your help and patience.

Günther