Database Setup

If you are not at the Database tab yet, click the - icon in the toolbar to go to Database tab. DB AppMaker can connect to Microsoft Access, Microsoft SQL Server, MySQL, Oracle and other databases that support ODBC.

Note Database client is required for each database type, make sure you have installed it first or you'll encounter error during generation. See System Requirements for details.

 

Microsoft Access

  • Select Microsoft Access as database type,
  • Select the database file by clicking the - button,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.

-

 

Microsoft SQL Server

Notes

  1. If you have installed SQL Server 2012 Native Client on your computer, then Microsoft SQL Server database type will be available for selection. You can use this database type for connection to SQL Server 2000, 2005 or newer. You can download SQL Server 2012 Native Client from the Microsoft website, see System Requirements. (Do NOT use ODBC with SQL Server.)
  2. DB AppMaker connects to the SQL Server by TCP/IP (NOT Windows authentication), make sure TCP/IP protocols is enabled for your SQL server, you can use SQL Server Configuration Manager to check and configure.
  3. If the SQL Server is a remote server (not on the same machine as DB AppMaker), make sure your SQL Server allows remote connection, you can use SQL Server Management Studio to check and configure.
  4. If you have firewall enabled on the server, make sure it allows inbound traffic on port 1433 for TCP/IP. If the SQL Server uses another port number, make sure you have set up the firewall rules accordingly. 
  • Select Microsoft SQL Server as database type,
  • Enter the name or IP of the SQL server,
  • Enter the Username and Password,
  • Select the database you want or just enter the name of your database,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.
Note If Microsoft SQL Server 2005 or newer, make sure the server name includes the instance name if necessary, e.g. localhost\SQLEXPRESS.

-

 

MySQL

  • Select MySQL as database type,
  • Enter your database host/server name (or IP address), username, password and port number (default is 3306 for MySQL),
  • Select your database,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.

 

Oracle

Note If you have already installed Oracle client on your computer, this database type will be available for selection.
  • Select Oracle as database type,
  • Enter the Oracle TNS name,
  • Enter the Username and Password,
  • Select the Schema you want or just enter the Schema name,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.

-

 

ODBC

  • Select ODBC as database type,
  • Select a System DSN from the dropdown list. You can create or modify a System DSN by clicking the - button,
  • Enter the User ID and Password,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.

-

 

Connection String

  • Select Connection String as database type,
  • Enter your connection string or click the [...] button to build the connection string using the Microsoft Data Link Properties form. Remember to check "Save password" or your password will not be included in the connection string,
  • Check Load tables dynamically (unless you want to load all tables),
  • Click the Connect button to load the database information.

-

 

On completion, the tables and fields information will be loaded and displayed on the left hand side. (The database pane is dockable. If you prefer to display the database pane on the right hand side, simply drag it to the right side.)

-

 

Dynamic Table Loading

If this option is enabled, a table will only be loaded when you select it in the database pane. If you just use a few tables out of a large database, this feature enables you to work much faster. To enable this feature, simply check Load tables dynamically BEFORE pressing the Connect button.

 

 ©2017 e.World Technology Ltd. All rights reserved.