Choose the database type from the "Database Type" drop down.

screenshot

  • Database Type: The database driver that use to connect your datatabase
  • Name: The name to identify this connection, used only in DbFace
  • Host: Your database host domain/IP. If you are not using the default port, should use host:port as your hostname
  • Username: The database username.
  • Password: The database password.
  • Database Name: The database that you want to connect

For SQL Server, make sure the PHP PDO SQLSRV extension loaded, check php.ini

extension=php_pdo_sqlsrv_54_ts.dll

please enter the SQL Server address in the host field, it should be like:

JSDING-WIN8\MSSQLSERVER2014

Ensure that all information is correct, click "Submit" button, DbFace will use the provided information to try to connect the database, and create the connection if successfully.

Congratulations! You have successfully built your first database connection.

Recommend

If you just creating query applications which only access the databases, please create readonly database users for the databases.

Be careful

Please update your server's firewall to allow DbFace to connect to your database server. If you've got any issues, please contact us to get free support.