Support - Databases

What types of databases does Adhost support?

Adhost supports MS-SQL 2005 and MySQL databases.

How do I connect to my MS-SQL database?

You can connect using various applications like Microsoft SQL Server 2005 Managment Studio or Microsoft SQL Server 2005 Managment Express. The Express edition can be downloaded from the Microsoft website for free. SQL Server 2008 versions of these tools will also work to manage a SQL2005 database. Please note that in order to install these programs additional components may need to be installed on your computer.

There are also third party applications that can be used to connect to and manage your SQL2005 database. For example EMS SQL Manager 2008 Lite for SQL Server.

IMPORTANT: In addition to having the correct software Adhost must allow your IP address from your remote connection through our SQL firewall or your connection will fail. To have your IP allowed and for more information see our Administering MS-SQL page.

How do I connect to my MySQL database?

You will need to telnet using SSH2 (if available) to connect to your MySQL Database or use MySQL GUI tools like MySQL Query Browser and MySQL Administrator. In addition your connection must be allowed through our MySQL firewall. For more information on MySQL and how to connect and manage your MySQL database, go to Administering MySQL. Of you can connect to an instance of phpMyAdmin appropriate to your server. Please contact Adhost Support for the address specific to your server.

How do I connect to my MS Access database?

MS Access is limited to support for only Adhost legacy customers. You cannot connect to an MS Access db remotely.

How do I connect to my database from my Web site?

For ColdFusion customers use a Data Source Name (DSN) and for all other programming languages use a DSN-less connection in your code.