Configuring InterBase ODBC DSN

Gemini InterBase ODBC Driver

Select Gemini InterBase ODBC Driver, and then click Finish. The InterBase ODBC Data Source Setup dialog box appears:

• In the Data Source Name box, enter the name of the data source you want to access. It can be any valid name that you choose.
• In the Description box, enter the description needed for the DSN.
• For Server box, enter the destination name (or IP) of the computer on which the InterBase server is installed.
• In the Database File box, enter the full path to .gdb file containing the database. The path must conform to file name syntax rules of server OS.
• In the Default User Name, enter your InterBase username (your database user ID).
• In the Password box, enter your password.
• Click OK to add this data source.

Note: Upon clicking OK, the Data Sources dialog box appears, and the ODBC Administrator updates the registry information. The username and connect string that you entered become the default connection values for this data source when you connect to it.

You can also test whether your settings are suitable for connecting to the server using the button Test.

Note: It is recommended to use '3' Dialect option to ensure proper driver work.

EasySoft InterBase ODBC Driver

Select EasySoft IB ODBC, and then click Finish. The EasySoft InterBase ODBC DSN Setup dialog box appears:

• In the DSN box, enter the name of the data source you want to access. It can be any valid name that you choose.
• In the Description box, enter the description needed for the DSN.
• In the Database box, enter the full path to .gdb file containing the database. The path must conform to file name syntax rules of server OS.
  This attribute may be entered in several formats, depending on where the database is located and the connection method required: When connecting to a local database (i.e. on the same machine as the client) the attribute should contain only the location of the InterBase database. For example, on Windows:
      c:\programfiles\borland\interbase\examples\database\employee.gdb
  or Linux:
      /opt/interbase/isc4.gdb
  
  To establish a connection using TCP/IP, prefix the database with "servername:" (where "servername:" resolves via the normal DNS name lookup to a machine on the network). It may be possible to use a dotted quad IP address instead of "servername", but this is dependent on the IP protocol stack being used.
  For example, to connect via TCP/IP to a server on a Windows machine:
      servername:c:\program files\borland\interbase\examples\database\employee.gdb
  or Linux:
      servername:/opt/interbase/isc4.gdb
• In the User Name, enter name of the user that will be supplied to InterBase to authenticate the connection.
• In the Password box, enter your password.
• Click OK to add this data source.

Note: It is recommended to use '3' Dialect option to ensure proper driver work.

You can test whether your settings are suitable for connecting to the server using the button Test.