Adding an ODBC Datasource
to Windows
xleINSERTOR  -  
A command-line
insertion utility
for Microsoft Excel

xleXTRACTOR  -  
A command-line
extraction utility
for Microsoft Excel

xSolver  -   
Non-linear, least
squares solver
add-in for Excel

bbExtractor  -  
Extractor for
Blackberry .ipd
backup files

wxArCeEs  -  
Graphical user
interface for RCS  
   (Coming Soon)
Other
Products
First, select 'Administrative' tools from the Control Panel.
Next select 'Data Sources (ODBC)'.
Click 'Add'.  A screen like the one below will come up.

Scroll through the list of drivers until you find the one that
matches your database.  In this tutorial we are adding a
Datasource from a MySQL database.  MySQL is a widely used
database system that is freely available from here.

If your database is not on the list, you must obtain and install
the proper ODBC driver.  Drivers for Oracle as well as all
Microsoft products (Access, Paradox, Fox-Pro, MS SQL Server)
should be on the list.  The MySQL driver is available here.

Drivers for other databases can be obtained from the vendor,
or you can download a third party commercial driver from here
or here.
When you click 'Finish' you'll get a screen like the one below
and to the left.  The one on the right has been filled out for the
purposes of this example.  The Data Source Name 'Big Dance'
is given to the existing database 'wxtest'.  'Big Dance' is the
name to use in the 'Data Source' field for the ODBC Data
Source field in Visual Pipe-Fu. Server is the name of the
machine where the database resides, if that machine is the one
you're using now, use 'localhost'.



And that's it.  You're ready to use your new Data Source.