Show/Hide Toolbars

Navigation: Using ASPRunner.NET

asprunnernet32x32     ASPRunner.NET manual


Connecting to the database

Scroll Prev Next More

 

 

ASPRunner.NET supports the following databases: MySQL, Oracle, Microsoft SQL Server, MS Access, PostgreSQL, 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, SQLite

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

step2-1

ASPRunner.NET 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

Before connecting to MySQL database make sure you have MySQL ODBC driver installed. This driver is available on the Web here. We recommend to install MySQL Connector/ODBC 3.51.

Type the Host/Server Name (usually localhost), user name, password and click Connect. Then select database and click Next >>.

step2

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 Host/Server name, User name and Password. Click Connect. Then choose required database name. Click Next >>.

connecting_mssql_options

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>>. ASPRunner.NET 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 ASPRunner.NET 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 ASPRunner.NET, you need to download 32-bit drivers. If you use 64-bit version of ASPRunner.NET, 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.