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;"