Connecting to database Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using ASPRunner.NET
Working with projects
Connecting to the database
Datasource tables, list fields, searchable fields
Choose pages
Login page
User login settings
Avanced Security Settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
Formatting options
Validation types
Lookup wizard
Events
Output directory settings
After you done
FTP upload
FrontPage Publishing
Advanced topics
ODBC
Master-details relationship
Troubleshooting "Operation must use an updateable query" errors
Connecting to database
Connecting to MS Access database
Connecting to MS SQL Server database
Connecting to MySQL database
Connecting to Oracle database
Publishing ASP.NET application to the remote Web server
Using FTP client to publish ASP.NET pages to the remote Web server
Using FrontPage to publish ASP.NET pages to the remote Web server
Events
More about events
Predefined actions
Send simple email
Send email with new data
Save new data in another table
Insert a record into another table
Check if specific record exist
Display a message on the WEB page
Redirect to another page
Custom code
Sample code
Show list of customer orders
Before deleting a record check if related record exist
Check if start date is earlier then end date
Speed up data entry using events
Frequently Asked Questions
Error: Could not load type ...
Error: Login failed for user '(null)'
Error: Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'
Error: Operation must use an updateable query
Error: Syntax error in UPDATE statement
Error: Syntax error in INSERT INTO statement
Error: Could not find MySQL ODBC 3.51 driver
Error: Client does not support authentication protocol
Error: Could not access CDO.Message object
How can I add new ODBC Datasource
I cannot find ODBC Administrator applet on Windows 2000 machine
I cannot connect to my Excel (Access) database
Order ASPRunner.NET online

 
  ASPRunner.NET manual


Connecting to database

 

ASPRunner.NET supports the following databases:

  • MySQL

  • Oracle

  • Microsoft SQL Server

  • MS Access

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

 

Connecting to MySQL - type the Host/Server Name (usually localhost), user name, password and click Connect.

Select Database and click Next >>.

Click the Recent database button to see a list of recently opened databases. You can use this button to quickly connect to previously opened databases.

Select ODBC DSN from listbox. Enter your Login and Password if required. Press Next>> to continue.

 

Connecting to Oracle, Microsoft SQL Server - type the Database Name, username, password and click Connect.

Connecting to MS Access (ODBC Data Source) - browse for database file. Press Open when done.

Check Create a databse copy in App_Data folder if you want relative path to be used in database connection string. Please also specify the path name if the database is located at a subfolder from the root. Use this option if you plan to transfer files to the remote Web server. In this case ASPRunner.NET creates a copy of database in the Output folder. ASP.NET pages will work with this database file copy which means you won't see changes in original database file.

Press Next>> when done.

 

After you successfully connected to database, it is time to select datasource tables.

 

The CHM file was converted to HTML by chm2web software.