Part IX: Reference

 

Part IX: Reference

System Requirements

System Requirement for Iron Speed Designer Software

Generated Application System Requirements

Application User System Requirements

Running on Microsoft .NET

.NET Framework 3.0 Compatibility for Iron Speed Designer

Activating and Deactivating Iron Speed Designer

Offline Activation of Iron Speed Designer

Downloading MSDE

How to Check Your MDAC Version

Proxy Server Configuration

Running Iron Speed Designer Remotely

Browser Compatibility

FireFox Browser Compatibility

Troubleshooting Iron Speed Designer Installation

Installer Hangs on Setup Status Screen

Installer Hangs on “Preparing to Install” Step

Incorrect version of the Xheo DLL loaded

Product key activation fails to register

Compatibility Between Professional and Enterprise Editions

Generated Web Pages

Table Controls and .NET DataGrid Controls

Page History (Back Button) Handling

Naming Policies for Generated Controls

Control Text Naming Policies

Control Name Naming Policies

Customizing the Control Name Naming Policy

Section 508 Compliance

Part 1194.22, Web-based Intranet and Internet Information and Applications

Part 1194.21, Software Applications and Operating Systems

Enabling the ‘Skip Navigation Links’ Link

Transaction Management

Page-Based Transaction Model

Database Stored Procedures

Database Views

Primary Key Use

Foreign Key Use

Default Values for Primary Keys and Foreign Keys

Concurrency Control

What is Pessimistic Concurrency?

What is Optimistic Concurrency?

Concurrency Handling in Generated Applications

Cursor Management

Full-Text Database Search

ADO DataSets

.NET Data Application Blocks

ODBC Driver Support

Exception and Error Management

Application Security Management

User Authentication and Access Control for .NET

Implementing Windows Authentication with .NET Impersonation

Automatic Sign-Out

Data Transmission Encryption

SSL Encryption and Security Certificates

URL Parameter Encryption

Password Storage

Firewall Security

Handling SQL Injection Attacks

Other Security-Related Materials

Application Folder Organization

...\<App>

...\<App>\bin

…\<App>\DataAccess

…\<App>\Images

...\<App>\<Sub Folder>

...\<App>\Shared

...\<App>\StoredProcedures

...\<App>\Styles

Base Classes Folder Organization

...\<Base>

...\<Base>\Bin

...\<Base>\Configuration

...\<Base>\Data

...\<Base>\Data\Columns

...\<Base>\Data\DataReader

...\<Base>\Data\SQLProvider

...\<Base>\obj

...\<Base>\Utils

...\<Base>\Web

...\<ProjectTemplates>

Iron Speed Designer File Folder Organization

…\Code Customizations

...\Design Themes

...\Designer

...\Designer\Bin

Microsoft Access Support

Microsoft Access 2000 Versions

Microsoft Access Database Field Support

Query Support in Microsoft Access

Linked Databases in Microsoft Access

Relative and Absolute Path Names for Microsoft Access Databases

Accessing Microsoft SQL Server Tables through Microsoft Access Queries

Microsoft SQL Server Database Support

Field Support in Microsoft SQL Server

User-Defined Database Field Types in Microsoft SQL Server

Sorting Collation Sequences in Microsoft SQL Server

Transact-SQL Stored Procedures for Microsoft SQL Server

Add Transact-SQL Stored Procedure

Delete Transact-SQL Stored Procedure

DeleteRecords Transact-SQL Stored Procedure

DrillDown Transact-SQL Stored Procedure

Export Transact-SQL Stored Procedure

Get Transact-SQL Stored Procedure

GetList Transact-SQL Stored Procedure

GetStats Transact-SQL Stored Procedure

Update Transact-SQL Stored Procedure

Linked Databases in Microsoft SQL Server

Database Owners in Microsoft SQL Server

Migrating from Microsoft Access to Microsoft SQL Server

Views in Microsoft SQL Server

User and Group Security in Microsoft SQL Server

Stored Procedure Naming Policy

MySQL Database Support

Driver Requirements

Database Field Support in MySQL

Data Formatting

Oracle Database Support

Using Oracle with Iron Speed Designer

Database Field Support in Oracle

Minimum Permissions Needed for Oracle Users

Changing an Oracle Database Schema Name in an Application

PL/SQL Stored Procedures

Matching Oracle Sequences with Primary Keys

App.config Configuration File

Web.config Configuration File

appSettings Element

Run-Time Configuration Elements

ADO and ADO.NET Data Source Connection Strings

Web.Config Settings for Microsoft Access Databases

Microsoft .NET Educational Resources

AjaxPro License Agreement

PDF Reporting using iTextSharp

Excel Export using CarlsoAg ExcelXmlWriter

FCKEditor License Agreement