Show/Hide Toolbars

Navigation: Using ASPRunnerPro

ASPrunnerPro32x32     ASPRunnerPro manual


Connecting to the database

Scroll Prev Next More

 

 

ASPRunnerPro supports the following databases: MySQL, Oracle, Microsoft SQL Server, MS Access, PostgreSQL, spreadsheet file, Informix, DB2, SQLite, any other ODBC-enabled database.

step1

Select your datasource type and click Next>>. Depending on the selected database type you will see one of the database-specific dialog boxes shown below.

Use Recent connections to quickly connect to previously opened databases.

Connecting to MS Access, spreadsheet file, SQLite

Choose Spreadsheet File option to select Excel, FoxPro, DBase, Paradox or text database file.

Define the file path to your database/spreadsheet file, enter login name and password if required. Click Next >>.

step2-1

ASPRunnerPro will try to find what ODBC driver to use to connect to selected database file. Select Select ODBC driver manually check box if you'd like to select ODBC driver manually.
You can read more about working with MS Access connection in this topic: Connecting to MS Access database

Connecting to MySQL

Type the Host/Server Name (usually localhost), user name, password and click Connect.

step2

Select Database and click Next >>.

Connecting to PostgreSQL

Type the Host/Server Name (usually localhost), user name, password, set additional parameters if required (e.g. port=5439) and click Connect.

step2-4

Select Database and click Next >>.

Connecting to Oracle, Microsoft SQL Server, Informix, DB2

Type the Host/Server name, Database Name, username, password and click Connect.

Connecting to ODBC Data Source

If you already have an ODBC Data Source Name (DSN) associated with your database, select ODBC DSN from the list box. Enter your Login and Password if required. Press Next >> to continue.

To create new DSN, press the ODBC Admin button. In the window opened add new DSN. Then click Refresh list.

step2-2

Connecting through ODBC driver dialog

Choose this option to connect directly through ODBC driver specific dialog.

Select ODBC driver from the list of available ODBC drivers and click Next>>.

step2-3

Create new Access database

If you do not have a database yet choose this option and click Next>>. ASPRunnerPro will help you to create a new empty MS Access database.

Using Create new table window you can create new tables in your database.

step3-0

For each field type name, type, size, scale (applies to DECIMAL datatype in SQL Server, Oracle and MySQL only). Set the Primary key field. Databases created with ASPRunnerPro will be saved to the project directory (database.mdb, database1.mdb etc.).

yellowbulbNote: Don't change table settings after you've built your project and added data records. All data will be lost after table modification.

After you successfully connected to database it's time to select datasource tables.

Downloading drivers

If you use 32-bit version of ASPRunnerPro, you need to download 32-bit drivers. If you use 64-bit version of ASPRunnerPro, download 64-bit drivers.

32-bit drivers:

Oracle - Download link (requires Oracle account).

Informix - Download link (requires IBM account).

DB2  - Download link.

64-bit drivers:

Oracle - Download link (requires Oracle account).

Informix - Download link (requires IBM account).

DB2:

version 9.7 - Download link;

version 10.1 - Download link;

version 10.5 - Download link.