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 create, download and restore full backup’s of their databases directly through their web browser at http://mylittlebackup.pipeten.co.uk
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 fix: Download the instructions helpfully provided by ozstar.
|
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: The DTS Wizard can be downloaded (SQLServer2005_DTS.msi) from here: Here is an example of how to Export using your own development MS SQL server: 1] Create your MS SQL database and login using your web hosting control panel. 2] Start the wizard on your local machine: 3] Input settings for your local MS SQL server Select Data Source ‘Microsoft OLE DB Provider for SQL Server’ 4] Input settings for our MS SQL server Select Data Source ‘Microsoft OLE DB Provider for SQL Server’ 5] Select ‘Copy objects and data between SQL Server databases’ 6] Select all the tables you want to import, typically this will be all, to do this Click ‘Select All’ for tables 7] Select ‘Run immediately’ 8] Click ‘Finish’ To export (backup) your database follow the instructions and simply reverse steps 3 and 4. |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
An easy way to publish your database to Pipe Tens database server is to use the Database Publishing Wizard.
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 popular applications used that are free to download:
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.