Database Overview


A database is an organized collection of information usually arranged in tables. The information collected could be customer names, the products you sell or any other type of information that can be included in a table. A database allows you to store, retrieve and modify data easily and efficiently.  

Databases have become an essential part of web site development. Web sites such as Amazon.com and Monster.com use databases to help you sort through and retrieve information about different products and jobs respectively.

We support four different types of databases on both Linux and Windows platforms.

Linux Platform

MySQL

Windows Platform

Microsoft Access 2000/2003

MS SQL

Microsoft Visual Fox Pro 7.0

With Linux, there are no ODBC/DSN connections to connect to a database. Windows, however, uses DSN and DSN-less connections to connect to a database.

The Linux Hosting Platform Database section consists of the following sections:

Activate MySQL

Connect to the Database

The Windows Hosting Platform Database section consists of the following sections:

Types of Windows Databases

Enable Windows Databases

Constructing Databases-Coldfusion

DSN Connections

DSN-less Connections

Upload the Database

Troubleshoot Database Errors