On Wed, 04 Jun 2008, John Goerzen wrote: > > Prelude Database.HDBC Database.HDBC.ODBC> conn <- connectODBC "dictation"
> Please note that this is not a valid connection string. I need to remember the connection functions are specific to the drivers and there are differences between connectODBC and connectSqlite3. > The HDBC-odbc API docs ... give the example string of: "DSN=hdbctest1" > as well as a link to the Microsoft document that describes the string: > http://msdn.microsoft.com/en-us/library/ms715433(VS.85).aspx > That URL also contains error message descriptions. For your state > 01S00, it lists: > Invalid connection string attribute > Your fix may be as simple as prepending the string with "DSN=". That did the trick. And I can insert and query the database. So HDBC-odbc-1.1.4.4 is good here. -- Dr Bean Make a mistake. Try it, you'll like it. --Dr Bean _______________________________________________ Haskell-Cafe mailing list Haskell-Cafe@haskell.org http://www.haskell.org/mailman/listinfo/haskell-cafe