[Haskell-cafe] HDBC-odbc 1.1.4.4 fixes Windows linking problems

[Greg Matheson]

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