What is SQL?
What are MySQL and MS SQL?
What database formats do you support?
What is a DSN? What is a DSN-less connection?
How do I connect to my database?
Do you provide technical support for database management?
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. Our MySQL databases (supported on the Linux platform) are hosted on a dedicated MySQL server to ensure better database processing and faster performance.
MS SQL refers to Microsoft® SQL Server™. Microsoft SQL Server is a complete database and data analysis software package (supported on the Windows platform). It is highly scalable and well-suited to complex E-commerce sites and enterprise applications.
Customers may use MySQL database in Linux, upgraded customers who changed the hosting platform from Linux to Windows may use Microsoft Access 2000/2003, Microsoft Visual Fox Pro 7.0, and MS SQL database.
What is a DSN? What is a DSN-less connection?
DSN, which stands for data source name, is a method of connecting to a database via ASP (Active Server Page) on the Windows platform. 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.
How do I connect to my database?
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 Perl DBI or the Mysql.pm module. In the near future, we will also provide phpMyAdmin to manage your MySQL database. To access your MS SQL database, please use Microsoft Enterprise Manager.
Do you provide technical support for database management?
We will help you connect to your database and assist you in troubleshooting database connection issues. We do not, however, assist you with building or managing your database.