Hi all, I'm trying to use DBI to connect to MySQL from ruby. Unfortunately, as soon as I use execute to try to send a query, it seg-faults. Here's a sample of code which does this: require 'rubygems' gem 'mysql' gem 'dbi' require 'dbi' require 'mysql' dsn = "DBI:Mysql:DATABASE:www.HOSTNAME.net" dbh = DBI.connect(dsn, "USERNAME", "PASSWORD") sth = dbh.execute("select * from pm limit 10;") I've checked the value of dbh, and it's not nil, and looks fine. No exceptions are thrown, as I've checked for that too. I'm running this on Windows - not sure if that makes a difference? Does anyone know what I'm doing wrong? Thanks, Ben
on 2009-01-12 19:35
on 2009-01-13 00:20
On Jan 12, 3:31 pm, Ben <firstname.lastname@example.org> wrote: > require 'mysql' > Does anyone know what I'm doing wrong? What is your ruby version? Can you provide more information about the MySQL version (more importantly the libmysql.dll that is in the path, which version it is?