Open Database Connectivity (ODBC) 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


Open Database Connectivity (ODBC)

 

Open Data Base Connectivity is a system provided in Windows to allow a range of different database applications to exchange data. Click on My Computer - Control Panel where you should find an icon named ODBC.

ASPRunner.NET allows you to extract data from an ODBC Data Source Name (DSN). A DSN is simply a convenient way of storing all of the datasource connect information (file name, path, user I.D, connect password, database type etc) under a simple name.

ASPRunner.NET comes with instant support of Oracle, SQL server database, and a number of file-based databases such as Microsoft Access, Microsoft Excel, FoxPro, Paradox, and Text files. If you want to use ASPRunner.NET with database like MySQL or Informix, you have to install and configure appropriate ODBC drivers for your database. See topic Where can I download latest ODBC drivers? to find appropriate ODBC driver for your database.

If you want to know more about ODBC, visit Microsoft site to find more ODBC info
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/dasdkodbcoverview.asp

Related topics:

How can I add new ODBC Datasource (DSN)?

 

The CHM file was converted to HTML by chm2web software.