• Product Information
  • About
  • News
  • Screenshots
• Support Information
  • Documentation
  • Resources
  • FAQ
  • Support
  • Upgrade policy
• Download
• Purchase

Download Buy

MS SQL Database Converter online Help

Firebird

MS SQL Database Converter  allows you to connect to Firebird servers directly or via Secure SHell (SSH) tunnel.

Direct connection is the most preferable connection mode.

If your Firebird server does not allow direct connections from remote workstations, you can establish connection to intermediate SSH server and forward all Firebird commands through the Secure SHell (SSH) tunnel. To establish connection to intermediate SSH server and forward all Firebird commands through the secure tunnel, you need to:

Host name

Specify the host name or IP of your site. Note, that Firebird host name always should be set relatively to the SSH server. For example, if both of Firebirdand SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.

Port number

Enter the port number for the SSH server.
 

4. Enter valid User name for the remote server and select the Authentication method and set corresponding credentials.

Password-based

Set the password corresponding to the specified user.

Key-based

Specify the path to the Private key file with the corresponding Passphrase to log in to the remote server. MS SQL Database Converter accepts keys in ssh.com or OpenSSH formats. To convert a private key from PuTTY's format to one of the formats supported by our software, use the PuTTYgen utility that can be freely downloaded from the PuTTY website.

Keyboard interactive

Keyboard authentication is the advanced form of password authentication, aimed specifically at the human operator as a client. During keyboard authentication zero or more prompts (questions) is presented to the user. The user should give the answer to each prompt (question). The number and contents of the questions are virtually not limited, so certain types of automated logins are also possible.

Irrespectively of a connection mode you should specify common credentials as follows:

Protocol (Standard server, Embedded server)

The software supports only TCP/IP protocol, you need to select only the type of server you are connecting to.

Host

The name of machine the Firebird server and database file resides on. It is usually possible to specify TCP/IP address instead of name (like 192.168.12.34), however this functionality is not built into Firebird, instead, it is provided by underlying network layer (e.g. WinSock2), and for some implementations/configurations it can be much slower than using name. In case the server is not localhost, specify the TCP/IP port as Port number.

Login information

Since version 2.1, Windows authentication has been used for configuring the server authentication mode along with the traditional login info, requiring users to log in using a user name and password defined in the security database. To use Windows authentication, check the corresponding box. Under the right conditions, this may be the most secure way to authenticate on Windows. Otherwise, set the following server security options:

Database name

This is either name of database file (as seen from the server), or alias defined in aliases.conf file. It is better (but not required) to use fully qualified filename, e.g. "d:\databases\db.fdb" (avoid using partially specified filenames like "d:databases\db.fdb").