Frequently Asked Questions

Working With Databases Articles

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....

What are the limitations for MS SQL?

The most significant limitation for MS SQL that you should be aware of is that each MS...

Connecting to a Microsoft SQL Server Database Using ASP/ADO

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

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...

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...

How do I connect to SQL Server using Visual Studio?

We do not allow customers to remote connect using Visual Studio to our MS SQL servers.

What are the Limitations for MySQL?

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

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...

Connecting to a MySQL Database Using ASP/ADO

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

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....

Can I Connect to My Database Remotely?

No, we do not allow external connections to our database servers.

Importing Data From MS Access to MS SQL

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

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...

Connecting to an Access Database Using ASP/ADO

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

Connecting to MySQL Using PHP

There are two main steps to connecting to a MySQL database using PHP. First,...

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

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

What are the Methods for Backing up my MySQL Database?

There are two common methods for backing up the content in your MySQL database....

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

We allow up to 50 simultaneous connections per MySQL user.

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 a...

Which version of MySQL should I choose?

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

What is an Access Database?

An Access database is a relational database contained in a single file that you can...

Do you restrict any features in MySQL 4.1/5.0?

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

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...

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 SQL Server Database on Your Hosting Account

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

What is MARS and how do I use it?

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

Setting Up an Access Database for Your Web Site

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

Setting up a MySQL Database on Your Windows Hosting Account

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

Importing SQL Server Database Objects

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

Managing Databases

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

What Server I Should Use in My Code to Connect to My Database?

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

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...

Creating SQL Server Database Tables and Fields

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

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....

Setting up a MySQL Database for Your Web Site

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

How do I Back up a MySQL Database?

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

Can I connect to my database remotely?

No, we do not allow external connections to our database servers .

Managing Databases

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

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 MB.

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. You...

How can I install/uninstall ASP Schema from 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...

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

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

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...

Importing Data Into a SQL Server Database

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

Restoring a SQL Server Database

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

Limitations to Restoring .bak Files

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

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...

Where do I find my database restore error log?

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

Where are database back-up files saved?

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

Backing Up a SQL Server Database?

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

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...

Configuration Information for the Database Publishing Wizard

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

Where do I get the Database Publishing Wizard client?

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

What are the Database Publishing Service and Database Publishing Wizard?

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

Limitations of the Database Publishing Service in the Shared Hosting Environment

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

Publishing a Database That Includes CLR Assemblies

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

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...

What does my Database Publishing Wizard error mean?

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

What is the URL for the Database Publishing Service?

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

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 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...

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....