From: Kyle Date: 2008-07-11T11:50:01+09:00 Subject: MS SQL 2005 Express and MySQL on Windows The short question: Has anybody successfully connected to both MS SQL 2005 Express and MySQL databases using Ruby on Windows XP? How? 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. When I upgraded the POS database to 2005 Express, using ODBC didn't work anymore - that is, until I got a driver 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." That worked fine, but now I'm having troubles getting to a MySQL database using DBI. I can't seem to load the module. I get errors about LIBMYSQL.DLL not existing, and if I 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). When I try to build 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. I'll try to give more info tomorrow. Does anybody have suggestions? I'd really appreciate any help, and I'll be happy to respond with more info. Thanks! -Kyle