Databases

There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres. In this example we will look at how to move an … Continue reading →

There is an occasional requirement to manually move your database from one server to another. Typically this is required as the result of an account migration between data centres. In this example we will look at how to move a … Continue reading →

When transferring MySQL databases between hosts or servers there are various methods available from the web based phpMyAdmin to remote GUI clients such as Toad. One of our favourites is the classic mysqldump and mysql-client due to their simplicity, portability … Continue reading →

8 years on and Pipe Ten still offer some of the best deals for MS SQL Server hosting. Take our Windows Venture package for example, it is still just £5 per month and comes with a 100 MB MS SQL … Continue reading →

If you receive an email from support@pipeten.co.uk or .com with the title “Warning (Approaching resource limit)” it means that you are approaching or exceeding some of the inclusive resources on your hosting package. Explanations of what these resources are and … Continue reading →

When you reach approach or exceed the default size of your hosting packages inclusive database quota/storage you will receive an email from support@pipeten.co.uk or .com to the primary account contact with the subject “Warning (Approaching resource limit)”. This post provides … Continue reading →

Closed.

When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect … Continue reading →

Support for the old MS SQL Manager that used to be available via the online control panel has been removed.  This was because of the lack of functionality, security risks and general poor performance that the third party package was … Continue reading →

Pipe Ten are please to announce a beta release of MyLittleAdmin, the web based administration tool for SQL servers.

Due to popular request Pipe Ten have now launched their exciting new SQL Server 2005 backup facility using MyLlttleBackup. All customers that have databases on Pipe Ten’s MSSQL server can now log in to the new online backup facility to … Continue reading →

Since our last Dublin update we’ve had a few users having issues with their old OSCommerce installs. Below you’ll find the most common problem and fix. The problem: Error Message – 1054 – Unknown column ‘p.products_id’ in ‘on clause’ The … Continue reading →

This FAQ assumes SQL Server 2005 Express is running on your development server. If not already installed you will need the Microsoft SQL Server 2005 Express Edition Toolkit: http://go.microsoft.com/fwlink/?LinkId=65111 The DTS Wizard can be downloaded (SQLServer2005_DTS.msi) from here: http://www.microsoft.com/downloads/details.aspx Here … Continue reading →

An easy way to publish your database to Pipe Tens database server is to use the Database Publishing Wizard.

You can obtain Enterprise Manager by downloading MSDE (Microsoft Data Engine) from Microsoft

There are a range of clients available for managing your MS SQL 2005 database and they all should work with Pipe Ten’s servers without a problem. Each client offers slightly different functionality and licensing. Below are two of the more … Continue reading →

Yes we support MS Access on our servers although Microsoft do not recomend it to be  used for online applications. Most of our Windows packages come with an MSSQL database included which is a more suitable technolgy for websites.

No, for security and efficiency reasons our web servers can only access Pipe Ten’s MS SQL servers.

Yes, you can connect to your database using a client such as MySql Front or Aqua Data Studio. We only enforce standard authentication for remote MySql connections, you just require your database username, password and server address.

Yes, you can connect to your database using a client such as MySql Front or Aqua Data Studio. We only enforce standard authentication for remote MySql connections, you just require your database username, password and server address.