Iron Speed Designer is not currently able to connect to databases whose database names have these characteristics:
The # character is not supported in database names.
Due to limitations in Microsoft Windows, Iron Speed Designer is not able to use or reference database tables with these names:
AUX
CLOCK$
COM1-COM9
CON
LPT1-LPT9
NUL
PRN
Other table name restrictions include:
Table names may not exceed 50 characters in length.
Table names may not contain leading or trailing blanks.
Many, but not all, special characters are supported. Note, however, that table name containing some special characters may cause problems. Iron Speed Designer replaces special characters such as +, -, *, and % by the underscore character (“_) when creating table names, class names based on table names, and stored procedure names based on table names. This can lead to situations where two different table names have the same class name or stored procedure name because of this underscore mapping. Moreover, MSI Deployment Installers created by Iron Speed Designer may not function properly because the MSI Deployment Installer will not install stored procedures containing underscores in their names.
Two or more table names differing only in special characters (i.e., “A+B” and “A-B”) will cause a conflict because both map to the same modified name (e.g., “A_B”). Iron Speed Designer does not guarantee uniqueness when mapping special characters.
Table names with multiple brackets (i.e., “A[B])]C”) are not supported because the multiple brackets cause problems with SQL statements.
The same table name may not be included from two different databases in a multi-database application. Iron Speed Designer creates class names based on the underlying table name or database view name, which conflicts when two tables have the same name.
Iron Speed Designer must create SQL statements that conform to the underlying database, such as Microsoft SQL Server. Accordingly, there are several restrictions as to table names and field names used in the underlying database.
Field Names May Contain |
Field Names May NOT Contain |
Letters as defined in Unicode Standard 2.0. Decimal numbers from either Basic Latin or other national scripts. @ “at” sign |
These special characters: comma, single quote, and double quote. Microsoft SQL Server only. A Transact-SQL reserved word. Microsoft SQL Server reserves both the uppercase and lowercase versions of reserved words. |
Note: Iron Speed Designer replaces spaces and dash characters with underscores.
Step 3: Connect to a Database Server
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
Working with Complex Databases
Database, Table, and Field Name Restrictions