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

Greg Matheson greg at momotaro.chinmin.edu.tw
Thu Jun 5 05:03:27 EDT 2008

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 

> 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- is good here.

Dr Bean                          Make a mistake.
                                 Try it, you'll like it.
                                 --Dr Bean

More information about the Haskell-Cafe mailing list