Are used to define the connection parameters to a database. The dialog box contains the parameters that correspond to the connection attributes
Data Source Name (DSN)
Required.
Unique name of Server Type
Example
: “Connect from FbEmbed” or “ConnectFbServer”
Description
Not Required.
A more detailed description of the data source.
Driver
Required.
Always
: IscDbc
Database
Required.
Specify the location of a database, locally, remotely or via an alias.
See examples
Client
Required when using the embedded Server Allows you to specify a command line to start the Firebird embedded database(fbembed) or Firebird SQL client (gds32,fbclient).
Database Account
Not Required.
The user name to be used when connecting to a Firebird database.
If not used, ODBC will prompt you for a user ID
(UID or USER) when connecting to the data source.
Password
Not Required.
The password to be used with the User ID when connecting to a Firebird
database. If not used, ODBC will prompt you for a password ( PWD
or PASSWORD ) when connecting to the data source.
If used the password is automatically encrypted and saved in odbc.ini.
Setting the password here should not be a security risk.
Role
Not Required.
Rules:
1. If defined, but login is SYSDBA, role ignored is used.
2. If defined, and login is not SYSDBA, login ignored is used.
Character Set
Not Required.
Set the default character set.
Options
Read (default write)
Write: Access the database in Read/Write mode.
Read: Access the database in Read Only mode.
Nowait (default wait)
Wait: The transaction will wait if it encounters a lock conflict.
Nowait: The transaction will immediately return an error if it
encounters a lock conflict.
Dialect
Typically 1 or 3, SQL dialects were introduced in InterBase 6.0, to support a number of new SQL features including delimted identifiers. Valid dialects are:
Quoted Identifier
This option ensures compatibility with databases created in dialect 1
Sensitive Identifier
This option changes the property of SQL_IDENTIFIER_CASE (Default SQL_IC_UPPER, select SQL_IC_UPPER or SQL_IC_SENSITIVE)
Autoquoted Identifier
default NO (select YES or NO)
Should change from