Permalink
Switch branches/tags
upstream/2.3.1.0 upstream/2.2.3.0 upstream/2.2.0.0 hdbc-testsuite-0.99.0 hdbc-sqlite3_0.5.0 hdbc-sqlite3-0.6.0 hdbc-postgresql-0.99.0.1 hdbc-postgresql-0.99.0.0 hdbc-postgresql-0.6.0 hdbc-odbc-2.3.2.1 hdbc-odbc-0.99.0.0 debian/2.2.3.0-1 debian/2.2.0.0-3 debian/2.2.0.0-2 debian/2.2.0.0-1 debian/2.1.0.0-3 debian/2.1.0.0-2 debian/2.1.0.0-1 debian/2.0.0.0-2 debian/2.0.0.0-1 debian/1.1.6.0.1 debian/1.1.6.0.0 debian/1.1.4.4.1 debian/1.1.4.4.0 debian/1.1.4.2.0 debian/1.1.4.1.0 converted-from-darcs before-making-progress-compatibility-adjustments after-darcs-conversion Very_first_successful_compile_of_sqlite3 Utils_are_working Tests_run_again Ready_for_first_tests RELEASE_1.0.0.0 RELEASE_hdbc-odbc_1.1.4.0.0 RELEASE_hdbc-odbc_1.1.3.1.0 RELEASE_hdbc-odbc_1.1.3.0.0 RELEASE_hdbc-odbc_1.1.2.2 RELEASE_hdbc-odbc_1.1.2.0 RELEASE_hdbc-odbc_1.1.0.0 Passes_all_tests_with_PostgreSQL New_allocation_code_working Initial_testsuite First_passing_of_all_tests Debugging_heisenbug DEBIAN_hdbc-postgresql_0.99.0.0 DEBIAN_hdbc-odbc_1.1.4.0.1 DEBIAN_hdbc-odbc_1.1.4.0.0 DEBIAN_hdbc-odbc_1.1.3.1.0 DEBIAN_hdbc-odbc_1.1.3.0.0 DEBIAN_hdbc-odbc_1.1.2.2 DEBIAN_hdbc-odbc_1.1.2.1 DEBIAN_hdbc-odbc_1.1.2.0 DEBIAN_hdbc-odbc_1.1.0.0 DEBIAN_hdbc-odbc_1.0.1.1 DEBIAN_hdbc-odbc_1.0.1.0 DEBIAN_hdbc-odbc_1.0.0.1 DEBIAN_hdbc-odbc_0.99.2.1 DEBIAN_hdbc-odbc_0.99.2.0 DEBIAN_hdbc-odbc_0.99.0.0 Creation_of_ODBC_branch Checkpointing_attempt_to_wrap_things Before_swich_to_wrapping_C_objects Before_postgresql_cfork After_switchover_to_new_memory_management_code
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
108 lines (69 sloc) 2.9 KB

HDBC-ODBC

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://msdn2.microsoft.com/en-us/library/ms715433(VS.85).aspx

connectODBC :: String -> IO Connection

For example, you might use connectODBC as follows:

connectODBC "DSN=hdbctest1"

For more information about HDBC-ODBC, please visit the wiki.

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.

For the error "2013: Mysql server has gone away" error message, you'll have to use withRTSSignalsBlocked from the HDBC-mysql package.

query conn stmStr binds = withRTSSignalsBlocked $ quickQuery conn stmStr binds

Getting Started

Here are some instructions to set up ODBC with a sqlite3 backend, and how to communicate with that database with HDBC-ODBC. These instructions are written to work with Ubuntu 11.10.

First, we'll need to install the appropriate libraries:

sudo apt-get install unixodbc unixodbc-dev unixodbc-bin
sudo apt-get install libsqliteodbc

Verify that the sqlite ODBC drivers have been set up correctly:

odbcinst -q -d

This should return:

[SQLite]
[SQLite3]

Next, fire up the ODBCConfig too to set up a new DSN:

ODBCConfig

If you want to run the HDBC test suite, then set your DSN to hdbctest, and set up to connect to a database of your choice, such as an empty file in the hdbc-odbc/testsrc directory:

touch hdbc-odbc/testsrc/hdbctest.db

You can check that everything is working appropriately in ghci:

ghci> :m + Database.HDBC Database.HDBC.ODBC
ghci> conn <- connectODBC "DSN=hdbctest"
ghci> hdbcDriverName conn
"odbc"
ghci> hdbcClientVer conn
"03.52"

You can then run some tests on your database:

cd testsrc
runhaskell runtests.hs

Contributing

Contributions are welcome! If you would like to contribute, please fork the the github repository, and submit a pull request.