Frequently Asked Questions

Help Center Search

Working With Databases Articles

What is a File DSN?

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

Are stored procedures supported in MySQL?

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

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

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

Do you restrict any features in MSSQL 2005?

MSSQL 2005 provides many features which are powerful in an enterprise database...

Setting up a SQL Server Database on Your Hosting Account                

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

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

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

Importing Data From MS Access to MS SQL

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

How do I connect to SQL Server using Visual Studio?

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

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

Managing Databases                

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

Importing Data Into a SQL Server Database                

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

Creating SQL Server Database Tables and Fields                

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

Importing SQL Server Database Objects                

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

How do I export a MySQL Database?                

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

Restoring a SQL Server Database                

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

Publishing a Database That Includes CLR Assemblies                

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

What is the URL for the Database Publishing Service?                

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

Where do I find my database restore error log?                

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

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

Backing Up a SQL Server Database                

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

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

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

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

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

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

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

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

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 change the description of my MS SQL 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...

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

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

Do you restrict any features in MySQL 4.1/5.0?

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

Which version of MSSQL do you support?

All new databases created are in MSSQL 2005 format. MSSQL 2005 is backward compatible...

What are the new features available in MSSQL 2005?

MSSQL 2005 offers many new features, including: Native XML Support - Native XML...

What is MARS and how do I use it?

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

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.

Managing Databases

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

Do you support FrontPage extensions?

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

Limitations to Restoring .bak Files

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

Which version of MySQL should I choose?

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

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

Connecting to a Microsoft SQL Server Database Using ASP/ADO

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

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

What is an Access Database?

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

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

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

Can I connect to my database remotely?

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

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

We allow up to 50 simultaneous connections per MySQL user.

What are the Limitations for MySQL?

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

What are the limitations for MS SQL?

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

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

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

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

Connecting to an Access Database Using ASP/ADO

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