From: Sean Armstrong <phinsxiii@...>
Date: 2005-09-17T00:53:19+09:00
Subject: MySQL, Ruby, DBI connetc problem...help please

------=_Part_15700_15620411.1126885995155
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I currently have the MySQL binary for Windows installed. I have ruby under=
=20
both cygwin and windows installed. I can not get the DBI module for either=
=20
ruby version to connect to my mysql database. Here is the code:

require 'dbi' # so far so good

dbh =3D DBI.connect('DBI:Mysql:test', 'testuser', 'testpwd') # here's
where it crashes
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:499:in `load_driver'
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in `_get_full_driver'
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in `connect'
 from (irb):5

I thought that maybe I had to declare the host so:

dbh =3D DBI.connect('DBI:Mysql:test:.', 'testuser', 'testpwd') # here's
where it crashes
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:499:in `load_driver'
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:401:in `_get_full_driver'
 from /usr/lib/ruby/site_ruby/1.8/dbi/dbi.rb:381:in `connect'
 from (irb):5

I thought maybe there was something wrong with the database but the=20
following connects just fine in the terminal:

mysql -u testuser -p -h . test

I can not seem to get the DBI to work with Windows, apparently the ruby=20
modules are only good with Unix and not Windows. Please do not say try=20
mysql-ruby. I can not even get that to compile. I've tried compiling Mysql=
=20
source for the libs but it still refuses to find the mysql libs no matter=
=20
wher I point extcong.rb. So I tried going back to DBI. That is where I stan=
d=20
now. Certainly someone out there has been able to get this module to work=
=20
properly with the MySQL binary install and WinXP?

Thanks:)

SA

--=20
"I can do everything on my Mac that I could do on a PC."
-- Me

------=_Part_15700_15620411.1126885995155--