On Apr 8, 4:29 pm, sean <[email protected]> wrote: > newbie here. > > have ruby/sequel/sqlite and windows 2003 server working smooth. > > but have problem with mysql > > "gem install mysql" > > run a basic ruby test script, got error popop > > "this application has failed to start because LIBMYSQL.dll was not > found. Re-installing the application may fix the problem." > > Then copy LIBMYSQL.dll from my sql/bin to ruby/bin > > this fixed the problem. Basic ruby / sql connection passed. > > Then try to use sequel model with my sql code as following, > > DB = Sequel.mysql(db_name, db_user, db_password, db_host, db_port)
This may be part of your problem. That call should bring up an error (not sure why it didn't). You should be using: DB = Sequel.mysql (db_name, :user=>db_user, :password=>db_password, :host=>db_host, :port=>db_port) > connection looks ok but error on the filter().first same code works > for sqlite. > > Any idea? Try using the above code and see if it makes a difference. If not, add an SQL logger and post again with the output. Thanks, Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
