Table Of Contents

Using A DSN vs DSNLess Connection
ODBC vs OLE DB Connection
Using An ODBC Connection
Using An OLE DB Connection

Choose A Table
Choose Field/s

Location Of Web Server
Web Site Directory
Name Of The List Web Page
Name Of The Detail Web Page
Web Site Root URL
Detailed Information On Website URLs

• DB2ASP™ web enables your databases in seconds.
• DB2ASP™ is the first program to easily create fully functional, professional quality coded asp pages.
• With DB2ASP™, you can view/edit/add/delete data in your database.
• Even more, once created the asp pages are fully customizable!
• With DB2ASP™ you do not write one single line of code, It's all done for you.
• DB2ASP™ is designed for both beginners and professionals to use.

DB2ASP™ was designed to quickly create, in seconds, asp pages that often take professional web developers many tedious hours to write and debug. DB2ASP™ will create two asp files. One is a list of records in your table and the other is a detail page that displays detailed information for the contents of one record. These two pages hyperlink to each other.

When running DB2ASP™, it first helps you Connect to a database on your computer or on a network server step by step. Once a Connection is established, you highlight the table you would like to web-enable. Then you choose the fields you would like to appear on the web pages. Next, you set the look and feel of the web pages. And finally, you set your web server properties and the location of the web files to create.

This is mostly a matter preference. Both of these are pretty much the same thing. DSN Connections differ in that they are managed, created and edited, by the ODBC Connection Manager in your Control Panel. DSNLess Connections have the actual Connection parameters on the asp page, where a DSN Connection is a reference to an Connection parameters located elsewhere. DSNLess Connections are more often used.

More most users, it does not matter which method you use. On the one hand ODBC has been around longer and is more tried and true. On the other hand OLE DB is Microsoft's latest and greatest. OLE DB is the future of database connectivity. It claims to be faster and more scalable. Both are used extensively in the industry.

• Driver - The type of database is being used.
• Server (Optional) - The computer or server the database is on.
• Database - The name of the actual database.

Click the "Connect" button and a Connection dialog box will appear.

• Provider Tab - The type of database is being used.
• Connection Tab - The setting on this tab differ based on the provider chosen.
  • Server (Optional) - The computer or server the database is on.
  • Logon Info (Optional)- The default is "Use a specific name and password". For SQL Server, "sa" is often the user name and the password is blank. Please check "Blank password" if no password is used. Please check "Allow saving password" when using DB2ASP.
  • Database - The name of the actual database. A list of available databases should appear in the drop down box if the server name and login is correct.
  • Test Connection - Click button to see if there is a good Connection.
• Advanced Tab - You do not need to use this tab.
• All Tab - This is just a review of all the current settings.

Once you click on the one of tables, the fields area should fill with a list of all the fields in that table.

CLICK THE NEXT BUTTON AT THE BOTTOM

The simplest thing to do here is to double click the Primary Key Field, or highlight the Key Field and click the submit button. A primary key is a field or group of fields. It is most often a single field that contains a unique ID. This means that all the records in the table have unique field values for each of the records. This field is often named "UID", "ID", "Sequence", "SEQ", "CODE", or "CD" among many others.

It is possible there is no Unique ID Field. In this case click the "No Primary Key" button. If there is no primary key for the table, only one asp page will be created, since there is no field that can enable a unique link.

STEP 3 - Look & Feel

Here You Can Change The Appearance Of The ASP Pages

• Title - Is automatically set to the name of the table being converted.
• JavaScript Form Validation - Click yes to have javascript created for your web pages. This will make most fields required when using the web pages to add or edit records. For example, if there is a field named "Email" this option would require the field to contain a valid email address.
• Web Style - You have a choice of two different table layouts.
• Font - Choose one of the four typical font faces, or click the ... button to choose another font face. In the font dialog box - the bold or font size options will be ignored.
• Font Color - Choose the color of the text on your web pages.
• Background Color - Change the background color.
• Outline Color - Change the color of the edge of the table.
• Dark Color - Change the color of your table heading where the field names will appear.
• Light Color - Change the color of your table where the record data will appear.

Any of the these settings can be change later once you have created the web pages. Click the "Reset" button to make all the setting go back to default values.

• Local - Choose this option if the web server you are using is on the same computer you are using DB2ASP on.
• Remote - Choose this option if the web server you are using is on the a different computer than the one you are using DB2ASP on. Network servers would also being indicated by this option.

• Select the Drive where your web site files are located.
• Select the Folder where your web site files are located.

This is the name of the first web page created that lists the records in your table. This asp file will hyperlink to the second asp page - the detail page.

This is the name of the second web page created that shows the contents of the fields you selected for one record.

This is the web site address for your web pages. For example, if you are using your computer as a development web server, you would enter http://localhost OR http://127.0.0.1 If you have a virtual web site, you might enter "http://localhost/MyWebSite". If you are using a remote web server, you might enter "http://lunar/MyWebSite". Please remember to have the file folder location point to the same place as you web site does. (see note)

To create a virtual web site on your computer, you must first have Personal Web Server (PWS) or Internet Information Server (IIS) installed on you computer. This works for most Windows computers.

1. Open your WINDOWS Explorer.
2. Select the folder where your web site files are located or will be located.
3. Right click on the folder with your mouse.
4. Select "Sharing..." from the list.
5. A dialog box will appear. Click on the "Web Sharing" tab.
6. Click "Share This Folder".
7. Another dialog box will appear. Type in the name (Alias) of your new web site. For example "MyHomePage"
8. Click "Ok".
9. Click "Ok" on the original dialog box.
10. Your Done. You can now place asp files into this folder using DB2ASP™.
11. To view this virtual web site, open a browser window and enter "http://localhost/MyHomePage/" + the name of an asp page in that directory.