Field list
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|---|---|---|---|---|
|
ID |
|
Alphanumeric characters and symbols (#1) |
No |
50 bytes or fewer |
|
Business group |
|
A business group for which general users have access permissions. Alternatively, a business group whose only purpose is to be used for filter conditions. |
Yes |
|
|
Comment |
|
Characters(#10) |
Yes |
255 bytes or fewer |
|
Product type (#6) |
SQLite3 |
SQLite3, Oracle, DB2, SQL Server (#2), PostgreSQL, ODBC, Excel (#8) |
No |
|
|
Kanji code type (#7) (#9) |
Undefined |
Undefined, |
No |
|
|
Select Database name |
Database name |
Database name, DSN, TNS |
No |
|
|
Database name |
|
Characters |
No |
255 bytes or fewer |
|
DSN |
|
Characters |
No |
255 bytes or fewer |
|
TNS |
|
Characters |
No |
255 bytes or fewer |
|
Host name |
|
Alphanumeric characters and symbols (#3) |
No |
255 bytes or fewer |
|
Port number |
|
1 to 65535 |
No (#4) |
|
|
User ID |
|
Characters |
No (#4) (#5) |
255 bytes or fewer |
|
Password |
|
Alphanumeric character: |
No (#4) (#5) |
32 bytes or fewer |
|
Authentication methods |
Windows authentication |
Windows authentication, SQL Server authentication |
No |
(#2) |
|
#1 |
: |
You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()). |
|
#2 |
: |
For Windows only. |
|
#3 |
: |
You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), ampersands (&), commas (,), or semicolons (;). |
|
#4 |
: |
If the product type is SQLite3 or ODBC is set, this can be omitted. |
|
#5 |
: |
If the product type is SQL Server and Windows authentication is set for the authentication method, it can be omitted. |
|
#6 |
: |
Only SQLite3 can use the DataMagic Desktop grade. |
|
#7 |
: |
In the case of DataMagic Desktop grade, this field is not displayed. |
|
#8 |
: |
In future upgrades or revisions, the settings for accessing Excel files using database connection information might become obsolete. When using Excel files, be sure to use Excel information. |
|
#9 |
: |
If the product type is ODBC or SQLite3, do not select Undefined in kanji code type, set the code type of your database correctly. |
|
#10 |
: |
No line breaks can be registered. |