From: Dave Halliday <davehal01@...>
Date: 2003-09-11T11:51:08+09:00
Subject: DBI/ODBC question: how to create DB programmatically?

Hi,

I've been trying to figure out how to use ODBC with DBI.  So far, I have
created a DSN for an existing DB and managed to read tables, update them,
etc, but I'd like to be able to create a new DB from scratch
programmatically (i.e. without any manual steps to create a DSN and add a
database).

Is there a way to do this from the DBI interface?  I've found a few VB
examples and dug around in the ODBC source code, but I can't quite make the
leap from the VB code to the DBI API.

I'm using Windows XP and Ruby 1.8.0.

Thanks,

Dave Halliday