Frequently Asked Questions

Help Center Search

Working with Databases Articles

Backing up a SQL Server Database

Using the Hosting Control Center, you can backup and restore SQL Server databases as...

How do I change the password for my MS SQL database?

During the database setup process you chose a password for that database. You will...

How do I change the description of my MS SQL database?

During the database setup process you entered a description for that database. This...

How do I connect to SQL Server using Visual Studio?

For security reasons, we do not allow customers to remote connect to our MS SQL...

What is a File DSN?

The purpose of the Windows file DSN (data source name) is to centrally store your...

Do you support FrontPage extensions?

Our hosting accounts support FrontPage extensions for the 2000 and 2002 versions....

What do I use for a host name when creating a MySQL database?

Do not use "localhost" as the hostname for your database-driven Web sites. Once you...

How Many Access Databases Can I Have On My Shared Hosting Account?

You can have as many MS Access databases as you can upload. Caution: Large and...

How do I export a MySQL Database?

You have two options when exporting your MySQL database. You can either export the...

Importing SQL Server Database Objects

When importing a SQL Server database from an existing hosting account to your...

Creating SQL Server Database Tables and Fields

You can create tables and fields only after you set up a SQL Server database. For...

Managing Databases

Once you have set up a database with your hosting account, you can log in to your...

What server should I use in my code to connect to my database?

Do not use "localhost" as the hostname (or database server) for your database-driven...

How can I install/uninstall ASP Schema from my MSSQL database?

To take full advantage of ASP .NET's architecture and performance capabilities, you...

How do I install/uninstall DSN in my MSSQL Database?

During the database setup process you entered a description for that database. This...

Where can I find database connection strings for my MS SQL database?

Connection strings can be found in the Hosting Control Center. Log in to your...

Where do I find my database restore error log?

When attempting to perform a database restore, there are a variety of errors that...

What is the URL for the Database Publishing Service?

The URL for the Database Publishing Service (DPS) is located in the Database...

Publishing a Database That Includes CLR Assemblies

For security reasons, you cannot directly publish assemblies. However, it is possible...

What are the Methods for Backing up my MS SQL Database?

There are several methods for backing up a MS SQL database. Dump A copy of the...

Importing Data into a SQL Server Database

You can import data from a delimited file into your shared hosting account's SQL...

How do I install/uninstall DSN in my MySQL Database?

During the database setup process you entered a description for that database. This...

What are the Limitations for MySQL?

We allow up to 200 simultaneous connections per MySQL user. There is also a limit...

What is the Number of Maximum Connections Allowed to a Single MySQL Database?

We allow up to 200 simultaneous connections per MySQL user.

How do I Export a SQL Server database?

You can export your SQL server database to an XML or a CSV file from the SQL Server...

Which version of MySQL should I choose?

Normally, if you are beginning to use MySQL for the first time, or have no other...

Restoring a SQL Server Database

Using the Hosting Control Center, you can back up and restore SQL Server databases...

Why do I get a MySQL "error: 1016 Can't open file: ..."?

Errors such as: ..."Got error: 1016: Can't open file: 'YOUR_TABLE_NAME.MYI'....

Is There a Size Limit on MySQL Databases?

Yes, MySQL databases are limited to 200 MB each. The number of databases your site can...

Can I connect to my database remotely?

Yes, you can connect to your database remotely with paid hosting accounts. To...

Why is my site displaying a "503 Service Temporarily Unavailableā€ error?

This is most likely caused by your site having met its maximum concurrent connection...

What are the limitations for MS SQL?

We allow up to 100 simultaneous connections per MS SQL user. MS SQL Server...

What are the new features available in MySQL 4.1?

Some of the new features in MySql 4.1 32 bit password hashing This will offer...

Are stored procedures supported in MySQL?

Stored procedures are supported in MySQL 5.0. A stored procedure is a set of SQL...

Setting up a MySQL Database for Your Web Site

MySQL is a database server that you can use in conjunction with PHP and other...

Setting up a SQL Server Database on Your Hosting Account

SQL Server is a relational database server from Microsoft that you can use in...

Why Connect Remotely to Shared Hosting Databases

Here's the lowdown: We provide database management tools with our shared hosting...

Setting up a MySQL Database on Your Windows Hosting Account

MySQL is a database server that you can use in conjunction with PHP and other...

Connecting Remotely to Shared Hosting Databases

To use Direct Database Access to connect remotely to your shared hosting database,...

Connecting to a MySQL Database Using File DSN and ASP/ADO

This example describes using File DSN and ASP /ADO to connect to a MySQL Database....

Connecting to a Microsoft SQL Server Database Using ASP/ADO

This example describes using ASP /ADO to connect to a Microsoft SQL Server Database....

Where are database back-up files saved?

Your back-up file is placed in the _db_backups folder on the root level of your...

What version of SQL Server is supported by the Database Publishing Service and Database Publishing Wizard?

The Database Publishing Wizard (DPW) client works with all local versions of SQL...

Where do I get the Database Publishing Wizard client?

The latest version of the Database Publishing Wizard (DPW) client is available from...

Limitations of the Database Publishing Service in the Shared Hosting Environment

Using your login credentials, you can perform all database actions through the...

Configuration Information for the Database Publishing Wizard

To set up the Database Publishing Wizard, you will need the following information:...

What does my Database Publishing Wizard error mean?

The Database Publishing Wizard (DPW) provides detailed errors when you may be able...

Where can I get more information on the Database Publishing Wizard client?

The Database Publishing Wizard (DPW) project home page is located in the CodePlex SQL...

What are the Database Publishing Service and Database Publishing Wizard?

The Database Publishing Service (DPS) and Database Publishing Wizard (DPW) are a set...

Limitations to Restoring .bak Files

When restoring a SQL Server database back-up file, you are limited to using .bak files...

Is there a size limit on MS SQL databases?

Yes, MS SQL databases on our Windows Shared Hosting plans have a size limit of 200...

What is MARS and how do I use it?

What is MARS? Using Multiple Active Result Sets (MARS), you can maintain multiple...

Connecting to a MySQL Database Using ASP/ADO

This example describes using ASP /ADO to connect to a MySQL Database. <% Dim...

What MySQL Server Features are Disabled on my Shared Hosting Account?

Some MySQL database features are not enabled on our shared hosting servers. Below is...

What are the major differences between MySQL 4.0 and 4.1/5.0?

For a complete list of the changes from MySQL 4.0 to version 4.1, see the Official...

Do you restrict any features in MySQL 4.1/5.0?

Yes. In order to protect our shared servers we restrict the following features:...

Publishing Objects Using the Database Publishing Wizard

The Database Publishing Wizard (DPW) runs under your hosting account credentials....

Publishing a Full Text Catalog

It is not possible to publish a full text catalog to one of our hosted SQL databases....

What should I be aware of when using the Database Publishing Service in the hosted environment?

The Database Publishing Service (DPS) may alter the contents and structure of your...

How do I Recompile the MySQL Library to Run Under the Medium Trust Environment?

We have configured the .NET 2.0 environment to run in a customized medium trust...

What Do I Do When I Receive an Updateable Query Error?

Error Message: Operation must use an updateable query. /file.asp 12 Cause: The...

What is collation and can I change it on my MS SQL database?

Collation controls the way string values are sorted. The default collation sorts...

What is the difference between a system backup and a user backup?

There are two types of backup: System Backup and User Backup. Here is a list of...

What are the Methods for Backing up my MySQL Database?

The standard method for backing up a MySQL database is via the dump method. This...

Connecting to an Access Database Using File DSN and ASP/ADO

This example describes using File DSN and ASP /ADO to connect to an Access Database....

Importing Data from MS Access to MS SQL

Currently, this procedure is not supported. However, there are methods to migrate...

Which databases do you support on your Windows hosting accounts?

You can set up a MySQL, MS SQL, or Access database using our various Windows hosting...

Publishing a Web Site Based on an ASP.NET Starter Kit

ASP .NET starter kits can be downloaded from the ASP.NET Web site . The following...

Connecting to an Access Database Using ASP/ADO

This example describes using ASP /ADO to connect to an Access Database. <% Dim...

Setting up an Access Database for Your Web Site

Our Windows hosting accounts allow you to set up Access database support . Using...