Online Documentation for Data Import for InterBase/Firebird

EMS Data Import FAQ


Please read this page attentively if you have questions about Data Import for Interbase/Firebird.

 

Table of contents

 

 

Question/answer list

 

Q: What is EMS Data Import for Interbase/Firebird?

A: EMS Data Import for Interbase/Firebird is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, TXT, CSV, XML, MS Excel 2007, MS Word 2007, HTML, ODF files to Interbase/Firebird tables. It provides adjustable import parameters, including source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. Data Import includes a wizard which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

 

 

Q: What do I need to start working with EMS Data Import for Interbase/Firebird?

A: First of all, you must have a possibility to connect to some local or remote Interbase/Firebird server to work with Data Import. You can download Interbase/Firebird database server from https://www.embarcadero.com/products/interbase (the latest commercial version of InterBase server) or Firebird client and server from https://www.firebirdsql.org. Besides, you need your workstation to satisfy the system requirements for Data Import for Interbase/Firebird.

 

 

Q: What is the difference between the Import feature of SQL Manager for Interbase/Firebird and the Data Import for Interbase/Firebird utility?

A: First of all, Data Import for Interbase/Firebird works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:

  • import data to several tables simultaneously;
  • import data to tables selected from different databases;
  • the command-line version of the utility to import data using the configuration (template) file with all import settings;
  • automatically creates table structure.

 

 

Q: Are there any limitations implied in the trial version as compared with the full one?

A: Actually the trial version of the utility only allows you to import 20% of records into each table. With this limitation, you can test all the features implemented in Data Import for Interbase/Firebird within the 30-day trial period.

 

 Note: There is a 100 records (instead of 20%) limitation when importing from CSV, TXT or MS Access files.

 

 

Q: What is the easiest way to configure the template files for the Data Import console application?

A: You can configure the template files for each table visually using the Data Import Wizard application. Set the required options and select the Tools | Save Template menu item. All the options will be saved to the template file which can be used by the console application.

 

 

Q: I work behind a firewall (router). Can EMS Data Import connect to a remote Interbase/Firebird server?

A: If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your PostgreSQL server directly through TCP/IP (for example a firewall prevents this), you can use SSH or HTTP tunneling feature of SQL Manager to fulfill your task.

 

 

Q: Why cannot I connect to the local InterBase/Firebird server?

A: There are several reasons why you cannot connect to the local database. If during connection you get the error "Connection failed. Server is stopped or unproper client library is used to establish connection to the server. SQLCode: -904 IB Error Number: 335544375", then you should check if the port or service used for server connection is set correctly and if a local server is running. To check if the service is launched, open Control Panel->Administrative Tools->Services and find service InterBase Guardian (if you use InterBase) or Firebird Guardian (if you use Firebird). In case you find it, run it with the Start button or use Start item in the context menu. If you cannot launch this service, then probably your server is installed incorrectly and you need to reinstall it. Another possible reason for this error is that the client library version does not coincide with the server version. If you get the error like “Your user name and password are not defined. Ask your database administrator to set up a Firebird login. SQL Code: -902 IB Error Number: 335544472" then the reason for this is that the registration data you enter are absent in your server security database. You should register the user with the proper login and password on your server.

 

 

Q: Why cannot I connect to a remote InterBase/Firebird server?

A: There could be several possible reasons that prevent you from successful connection to remote database. If the error message says "Connection failed. Server is stopped or unproper client library is used to establish connection to the server. SQLCode: -904 IB Error Number: 335544375" then probably you should check the correctness of port and host name you've entered and also if the remote server is run. It often happens that the port through which the connection is set with InterBase/Firebird server (normally, it's 3050) is closed for the security reasons by local firewall, corporate firewall or remote server firewall. Please check this with your system administrator or ISP. In order to avoid this limitation you can use SSH tunnel (50, 55).

 

 If the error message says "Your user name and password are not defined. Ask your database administrator to set up a Firebird login. SQL Code: -902 IB Error Number: 335544472", then the reason is that the user doesn't have permission to access the database. You should register the user with the proper login and password on your server.

 

Scroll to top

 

If you still have any questions, contact us at Support Center.