|   Home   |   Back   |

Getting Started

To fetch data from a database most of the time only very few steps have to be taken:

• The fist step is to load the Database Link.

• The second step is to connect to the database. If the target database is file based like a MS Access database just feed DatabaseConnect with the filename including the full path.

• Retrieve the data with a standard SQL command as a string embedded in the Mathematica Sql-command which comes with the Database Link

Getting information on a database

The previous example assumed that the user already knows enough about the database to do the query. To get informations on a database the command DatabaseInfo is provided.

• To get basic information on a database just use DatabaseInfo together with the handle pointing to the target database after the conncetion (for connecting see: Retrieving data from a database)

• To retrieve information on a specific table use

• To see what a query is about use

top

---

Converted by Mathematica      December 14, 1999