I’m trying to write a script to pull data out of a MS SQL 2003
database and manipulate it a bit. I’ve found ActiveRecord to be slim
on examples outside of the Rails environment.
I’ve tried lots of variations on the name of the driver; mssql, msql,
dbh = DBI.connect(“dbi:msql:wbctest:chad”, “testuser”, “testpass”)
I’ve dug into the dbi code some, found that it is case-insensitive
and, I believe, confirmed that msql is the appropriate one for my
needs and that it exists under the DBD directory.
Maybe I’m making this harder than it needs to be? That would be
common. I will gladly accept corrections in my direction of attack.