SQL (Structured Query Language) is the most popular database language in use today. SQL is used to create database queries that take the form of commands. SQL queries enable you to select, insert, update and determine the location of data, among other tasks. MySQL and Microsoft® SQL Server™ utilize the SQL language.

MySQL is an open source relational database management system that utilizes the SQL database language. It is a multi-user, multi-threaded database server that provides speed, robustness and ease of use.

MS SQL refers to Microsoft® SQL Server™. Microsoft SQL Server is a complete database and data analysis software package. It is highly scalable and well-suited to complex ecommerce sites and enterprise applications.

Witness Today’s Windows platforms support Microsoft Access 2000/2002 and Microsoft Visual Fox Pro 7.0. Microsoft SQL Server 2000 is available upon request. MySQL is also available upon request.

DSN, which stands for data source name, is a method of connecting to a database via ASP (Active Server Page). DSN connections require ODBC, an open standard for API for accessing databases. ODBC handles SQL requests and converts them into requests that the individual database systems understand.

A DSN-less connection is a method of connecting to a database without specifying a named data source. DSN-less connections don’t require the creation of an ODBC DSN. Instead of relying on information stored in a file or in the system registry (as DSN connections do), DSN-less connections specify the driver name and all driver-specific information in the connection string.

When you request your database, you will specify the database name and password. You will then be given your database server name and the user name you should use to connect to the database. To access your MySQL database, you can use an ODBC DSN.

Witness Today will help you connect to your database and assist you in troubleshooting database issues. We do not, however, assist you with building your databases.