|
II: Where's your data?
Obviously, DB2ASP needs to connect with your database to create the interface for it. This page is where
you specify its location.
But first, there is a question about your connection type - DSN, or non-DSN? DSN means using
connecting with an ODBC driver. This is a fairly old practice, and can end up disabling some features of
your database. You probably do not need a DSN connection. Try to avoid using DSN connections in any
case. If in doubt, choose the DSN-less option.
Now let's find your database.
Check the box next to "Use a custom connection string" if you have one. Checking this box will give you
a window to paste the connection string into.
Otherwise, click the "Connect To Database" button.
If you are using Microsoft Access
- On the "Provider Tab" choose "Microsoft OLE DB JET 4.0"
- On the "Connection" tab
1. Click the "..." button and select your *.mdb database file.
2. For advanced users, if the DB has a password, use the "All" tab (See Below)
- Click "Test Connection"
- If you have a good connection click
"OK"
If you are using Microsoft SQL Server
- On the "Provider" tab, choose "Microsoft OLE DB Provider for SQL Server"
- On the "Connection Tab"
1. Enter a server name or IP address, eg, "DBCOMPUTER" or "123.1.1.1"
2. Enter a specific user name and password, "sa" is often used
Check "Allow Saving Password"
3. Select the database or type it in, eg, "pubs"
- Click "Test Connection"
- If you have a good connection click
"OK"
If you are using Oracle
- On the "Provider Tab" choose "Microsoft OLE DB Provider for Oracle"
- On the "Connection" tab
1. Enter a server name.
2. Enter a user name and password.
Check "Allow Saving Password"
- Click "Test Connection"
- If you have a good connection click "OK"
Make
sure you have entered all relevant username and password information
that your database may require.
|