False hope.  If I fire up irb, require 'dbi', and then try to load a
mysql connection, I get the same error:

> mysql = DBI.connect('dbi:Mysql:.....')
DBI::InterfaceError: Unable to load driver 'Mysql'
...

If I "require 'mysql'", I get "true".  If I then try to load a mysql
connection, I get this interesting error:

> require 'mysql'
true

> mysql = DBI.connect('dbi:Mysql:.....')
DBI::InterfaceError: Could not load driver (uninitialized constant
Mysql:Driver)
	from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:344:in
'load_driver'
	from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in
'_get_full_driver'
	from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:213:in
'connect'

Any other thoughts?  I'm sorry to bombard the list like this...

-Kyle


On Jul 11, 10:55   򮮮
> Update: the 64/32 threw me a bit.   賲 ̬ > at least now, I'm getting "require 'mysql'" to return "true".
>
> Sorry about that.  §    >
> -Kyle
>
> On Jul 11, 10:48   򮮮
>
> > Thank you for your tips.  §    > > I'd have to re-write my scripts to use ActiveRecord, and from what I
> > hear, it's not necessarily easy to get Rails to talk to
> > MSSQL2005Express anyway...but I'll certainly give it a shot if nothing
> > else works!
>
> > I installed the MySQL Essentials and am getting the following errors:
>
> > > require 'mysql'
>
> > LoadError: 193: %1 is not a valid Win32 application. = C:/Program
> > Files/Ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-mswin32/ext/mysql.so
> > from C:/Program Files/Ruby/lib/ruby/gems/1.8/gems/mysql-2.7.3-mswin32/
> > ext/mysql.so
> > from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/rubygems/
> > custom_requirement.rb:32:in 'require'
>
> > > mysql = DBI.connect('dbi:Mysql:.....')
>
> > DBI::InterfaceError: Unable to load driver 'Mysql'
> > from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:329:in
> > 'load_driver'
> > from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:227:in
> > '_get_full_driver'
> > from C:/Program Files/Ruby/lib/ruby/site_ruby/1.8/dbi.rb:213:in
> > 'connect'
>
> > I hate to even think about this, but could this be an issue with Win
> > XP x64?     箮    
> > on a Win32 machine, though, with MySQL already installed.   > > checked that the MySQL directory was in my PATH, too.
>
> > Any other ideas?       > > Ruby to talk to a MySQL database on Windows.
>
> > -Kyle
>
> > On Jul 11, 8:18   
>
> > > On Fri, Jul 11, 2008 at 8:20 AM, Kyle <kyle.r... / gmail.com> wrote:
> > > > The short question: Has anybody successfully connected to both MS SQL
> > > > 2005 Express and MySQL databases using Ruby on Windows XP?  >
> > > > The long description: My company's point-of-sale system uses MS SQL.
> > > > A recent upgrade to the software required an upgrade of the database.
> > > > I was using ruby on ubuntu with DBI to synchronize the POS (MSSQL
> > > > 2000) and site (MySQL) databases.    
> > > > 2005 Express, using ODBC didn't work anymore - that is, until I gotriver from EasySoft that will cost 499 pounds if I want to use it for
> > > > more than 14 days.
>
> > > > My next thought was, "Oh, I'll put ruby on Windows and use MS's ODBC
> > > > driver to connect."   ɧ 
> > > > getting to a MySQL database using DBI.      > > > > module.    ̮  > > > > install the mysql gem, I get other errors (sorry - I'm not by that
> > > > machine now).
>
> > > > I'm using the Windows 1-click installer (186-26).   > > > > DBI, I get compile errors. I'm also unable to build the mysql-ruby (or
> > > > ruby-mysql) package that the DBI resources seem to point to.
> > > > Essentially, it looks like I'm having driver errors...or something
> > > > like that.  §    >
> > > > Does anybody have suggestions?  §   > > > > I'll be happy to respond with more info.
>
> > > Your mysql problems has nothing to do with your sql server. You don't
> > > have client libraries for mysql i believe.
>
> > > Download "mysql essentials" from following page your mysql driver
> > > issues should be gone:
>
> > >http://dev.mysql.com/downloads/mysql/5.0.html#win32
>
>