Step 3: Connect to a Database Server

To display and edit data in your application, Iron Speed Designer needs to connect to your database server.  The user name and password information is used by:

• Iron Speed Designer to retrieve the database schema to help you create user interface pages containing database information.  No changes to the database are made during this retrieval process.

• Iron Speed Designer to create a set of stored procedures.

• Your application to display and edit data.

Database Connectivity

Iron Speed Designer uses ADO.NET specific drivers for each database such as Microsoft Access, Microsoft SQL Server and Oracle.  By contrast, Iron Speed Designer does not use ODBC drivers to connect to databases.  ODBC drivers do not support additional database-specific features, such as database-specific field types, which Iron Speed Designer supports.

Related topics

Microsoft Access Options for Database Server Selection

Microsoft SQL Server Options for Database Server Selection

MySQL Options for Database Server Selection

Oracle Options for Database Server Selection

Disconnecting a Database

Working with Complex Databases

Database, Table, and Field Name Restrictions

See Also

Creating Your First Application

Step 1: Prepare your Database

Step 2: Select a Web Page Style

Step 3: Connect to a Database Server

Step 4: Select Pages to Generate

Step 5: Select Virtual Primary Keys and Virtual Foreign Keys

Step 6: Select Language and Localization Settings

Step 7: Name Your Application

Step 8: Build Your Application