Working With Databases - Help Center—Knowledge Base and FAQ

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

Help Center

Frequently Asked Questions

Related Articles

Working With Databases Articles