Takusen - is anyone currently using it on Win32 - ODBC?

Hi all, is anyone currently using takusen with odbc on Win32? In particular with MS Access? I'm asking because I noticed that when database libraries are declared to work with ODBC no one seems to mean Win32 ODBC, but rather Unix ODBC. Günther

2009/8/23 Günther Schmidt
is anyone currently using takusen with odbc on Win32? In particular with MS Access?
I'm asking because I noticed that when database libraries are declared to work with ODBC no one seems to mean Win32 ODBC, but rather Unix ODBC.
Yes. The ODBC backend is tested on Win32, although not with MS Access (Oracle, PostgreSQL, and MS SQL Server have been tested). If you have problems with MS Access, do let me know. Alistair

Hi Alistair,
I'm using Takusen to read in static data from an SQLite database and that
works just fine.
My app then needs to read in dynamic data, a set of 4 CSV files, and I had
been using Microsofts ODBC driver with HDBC.ODBC and that worked too.
When I try to swap it for Takusen though I get an
*** Exception: DBError ("HY","C00") 106 "[Microsoft][ODBC Text Driver]
Optional Feature was not implemented
Which is a bit of a shame, because using the ODBC text driver was much
simpler than parsing the CSV files.
I'm using WinXP Pro with ghc 6.10.4 (Haskell plattform) here.
Günther
Am 23.08.2009, 22:47 Uhr, schrieb Alistair Bayley
2009/8/23 Günther Schmidt
: is anyone currently using takusen with odbc on Win32? In particular with MS Access?
I'm asking because I noticed that when database libraries are declared to work with ODBC no one seems to mean Win32 ODBC, but rather Unix ODBC.
Yes. The ODBC backend is tested on Win32, although not with MS Access (Oracle, PostgreSQL, and MS SQL Server have been tested).
If you have problems with MS Access, do let me know.
Alistair

Günther Schmidt wrote:
My app then needs to read in dynamic data, a set of 4 CSV files, and I had been using Microsofts ODBC driver with HDBC.ODBC and that worked too. When I try to swap it for Takusen though I get an
*** Exception: DBError ("HY","C00") 106 "[Microsoft][ODBC Text Driver] Optional Feature was not implemented
Which is a bit of a shame, because using the ODBC text driver was much simpler than parsing the CSV files.
A simple but powerful way to access CSV files is via TxtSushi, which gives SQL access to CSV files, without needing ODBC: Home page: http://keithsheppard.name/txt-sushi/ Hackage: http://hackage.haskell.org/package/txt-sushi You'd have to use it directly, since afaik it won't work with Takusen, although a Takusen back end for it ought to be possible. Anton
participants (3)
-
Alistair Bayley
-
Anton van Straaten
-
Günther Schmidt