Frequently asked questions

Databases FAQ

Back to FAQ Menu

Definition

• What are MySQL and MS SQL?
  
• What is a DSN?
  
• What is SQL?
  

General

• What databases does UKFast support?
  

Support

• Does UKFast provide support for databases?
  

---

What are MySQL and MS SQL?

MySQL is an open source relational database management system that utilises 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.

back to top

---

What is a DSN?

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.

back to top

---

What is SQL?

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 utilise the SQL language.

back to top

---

What databases does UKFast support?

UKFast's Windows platforms support Microsoft Access 2000/2002 and Microsoft SQL Server 2000.

UKFast's Linux platforms support MySQL. On Linux platforms.
For detailed information regarding availability, pricing and licenses call our Account Managers on 0800 458 4545.

back to top

---

Does UKFast provide support for databases?

With all database systems we provide technical support and nightly backup to give you peace of mind. Out technical department can be contacted on 0800 230 0032.

back to top

---