> ODBC I know about from developing in Java with JDBC, but whenever they wanted
> to switch over to Microsoft databases we needed to use ODBC to connect (using
> Administrative Tools > Data Sources). Hopefully this will answer my
> question, and hopefully there will not be a lot to change.
The cool thing about ODBC is that it is a standard. In
Windows/MSSQL, you use Administrative Tools > Data Sources to make it
possible to use the standard commands. For Windows/Oracle, or
whatever, there are ODBC drivers available. On other platforms like
Linux/PostgreSQL or Linux/MySQL, there are other ways to implement
ODBC.
Using a native database driver is more efficient, and using the DBI
library is more powerful (I think) but ODBC in my experience is by far
the simplest and most portable way to talk to databases.
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general
