|
ASPRunnerPro supports the following databases: MySQL, Oracle,
Microsoft SQL Server, MS Access, PostgreSQL, spreadsheet file,
Informix, DB2, SQLite, any other ODBC-enabled database.
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 this option to select SQLite, MS Access, 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 >>.
ASPRunnerPro will try to find what ODBC driver to use to connect
to selected database file. Check off Select ODBC driver manually check box
if you'd like to select ODBC driver manually.
Connecting to
MySQL, PostgreSQL
Type the Host/Server Name (usually localhost), user name,
password and click Connect.
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.
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>>.
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.
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
C:\Program
Files\ASPRunnerPro6.2 directory (database.mdb, database1.mdb
etc.)
 Note: 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.
|
