[Haskell-beginners] Re: [Haskell-cafe] can someone point me to more help about Database.HDBC.ODBC?

Michael Mossey mpm at alumni.caltech.edu
Sat May 30 03:09:23 EDT 2009


This is on Windows, by the way. Do you know the equivalent file names and 
locations? What is DSN?

Thanks,
Mike

Евгений Тарасов wrote:
> Usually you should pass only DSN name in the string, if you used InnoDB 
> database in MySQL.
> 
> For example, /etc/odbc.ini file:
> ;
> ;  odbc.ini configuration for MyODBC and MyODBC 3.51 Drivers
> ;
> [.....]
> 
> [Default]
> Driver       = MySQL
> Description  = MySQL ODBC 3.51 Driver DSN
> Server       = localhost
> Port         =
> User         = root
> Password     =
> Database     = test
> Option       = 3
> Socket       =
> 
> [......]
> 
> Next step, you can test a connection with command:
> $ isql Default
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL>
> 
> And finally, the haskell code:
> 
> conn <- connectODBC "DSN=Default;"
> 
> 


More information about the Beginners mailing list