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.
Table names with multiple brackets (i.e. "A[B]]]C") are not supported because the multiple brackets cause problems with SQL statements.
Two or more table names differing only in special characters (i.e. "A+B" vs. "A-B") will cause a conflict because both will map to the same modified name (i.e. "A_B"). Iron Speed Designer does not guarantee uniqueness when mapping special characters.
Iron Speed Designer must generate 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. The at sign (@) sign, dollar sign ($), number sign (#), or underscore (_). |
These special characters: comma, single quote, and double quote. Non-English characters, such as characters with umlauts, tildes, etc. 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.