HDBC-odbc: ODBC driver for HDBC

[ bsd3, database, library ] [ Propose Tags ]

This package provides an ODBC database backend for HDBC. It is cross-platform and supports unixODBC on UnixLinuxPOSIX platforms and Microsoft ODBC on Windows. It is also the preferred way to access MySQL databases from Haskell.


[Skip to Readme]

Modules

[Index]

Flags

Automatic Flags
NameDescriptionDefault
buildtests

Build the executable to run unit tests

Disabled

Use -f <flag> to enable a flag, or -f -<flag> to disable that flag. More info

Downloads

Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees

Candidates

Versions [RSS] 1.0.1.0, 1.1.3.0, 1.1.3.1, 1.1.4.0, 1.1.4.1, 1.1.4.2, 1.1.4.3, 1.1.4.4, 1.1.6.0, 2.0.0.0, 2.1.0.0, 2.2.0.0, 2.2.3.0, 2.2.3.1, 2.2.3.2, 2.3.1.0, 2.3.1.1, 2.4.0.0, 2.4.0.1, 2.5.0.0, 2.5.0.1, 2.5.1.1, 2.6.0.0
Dependencies base (>=4 && <5), bytestring, containers, convertible, HDBC (>=2.1.0), HUnit, mtl, old-locale, old-time, QuickCheck, testpack, time, utf8-string [details]
License LicenseRef-LGPL
Copyright Copyright (c) 2005-2009 John Goerzen
Author John Goerzen
Maintainer John Goerzen <jgoerzen@complete.org>
Category Database
Home page http://software.complete.org/hdbc-odbc
Uploaded by JohnGoerzen at 2010-11-17T21:36:22Z
Distributions Debian:2.5.0.1, NixOS:2.6.0.0
Reverse Dependencies 9 direct, 1 indirect [details]
Executables runtests
Downloads 24953 total (65 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs uploaded by user
Build status unknown [no reports yet]

Readme for HDBC-odbc-2.2.3.1

[back to package description]
Welcome to HDBC, Haskell Database Connectivity.

This package provides a database backend driver for ODBC.  You should
be able to use any ODBC front-end with it.

Please see HDBC itself for documentation on use.

This package provides one function in module Database.HDBC.ODBC:

{- | Connect to an ODBC server.

For information on the meaning of the passed string, please see:

<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqldrivers.asp>

An example string is:

>"DSN=hdbctest1"

-}
connectODBC :: String -> IO Connection

DIFFERENCES FROM HDBC STANDARD
------------------------------

None known at this time.

MYSQL NOTE
----------

Important note for MySQL users:

Unless you are going to use InnoDB tables, you are strongly encouraged to set

Option = 262144

in your odbc.ini (for Unix users), or to disable transaction support in your
DSN setup for Windows users.

If you fail to do this, the MySQL ODBC driver will incorrectly state that it
supports transactions.  dbTransactionSupport will incorrectly return True.
commit and rollback will then silently fail.  This is certainly /NOT/ what you
want.  It is a bug (or misfeature) in the MySQL driver, not in HDBC.

You should ignore this advice if you are using InnoDB tables.