The steps for connecting to any database

Zee

The steps for connecting to any database are the same.

1) Create an ODBC connection (also called a DSN - data source name) to the database.

For this you will need an ODBC driver. For microsoft databases (Access and SQL Server), the ODBC driver is usually included in the operating system. For other types of databases, you will need to install the client software.

2) Insert the db_connect function from the function generator.

a) Create->Insert Function->From Function Generator
b) Select db_connect
c) Press the Args>> button
d) Next to Connec Str, pres the ... button
e) The select data source dialog appears
f) Select the data source created in step 1
g) enter your username and password
f) the connect string is generated for you!
g) press the paste button to paste the function in your script!

shyfish

To any kind of DSN rather than to any database
To any database means connecting DIRECTLY, I think