| Sub-Categories |
MS SQL 2005 (10) | |
MS SQL 2008 (11) | MS SQL 2008 R2 (11) |
MS SQL 2012 (12) | MS SQL 2014 (6) |
MySQL (8) | SQL CE (1) |
Category Articles 
How To Solve Problem with Connection String on EF (Entity Framework) 4 or above
Viewed 31246 times since Mon, Apr 1, 2013
This article applies to anyone who uses Entity Framework (EF) type-of-codes on our shared server environment. Please be advised that when you host your database on our server, you will have to use the connection string on your web.config. The "usual"... Read More
How can I restore my MS SQL database?
Viewed 6852 times since Tue, May 1, 2012
If you like to restore your MSSQL database, you need to raise a ticket to our Support Team. Please kindly make sure you make a FULL backup of your database into .bak file format and please kindly upload/send this file to us via FTP to your folder If... Read More
How can I backup my MS SQL database?
Viewed 4530 times since Tue, May 1, 2012
To back up your MS SQL database, you need to raise a ticket to our Support Team. Please kindly make sure you make advise us the database name that you want to backup and we will send it to your FTP folder. Read More
What is my MS SQL Connection String on my SQL Management Studio tool?
Viewed 46454 times since Tue, May 1, 2012
The connection string of your MS SQL database will always depend on the MS SQL version that you create via our Control Panel. You can find the connection string details by logging into our Control Panel -> Database. When you connect from your... Read More
What is my MS SQL Connection String on the web.config?
Viewed 43792 times since Tue, May 1, 2012
The connection string of your MS SQL database will always depend on the MS SQL version that you create via our Control Panel. You can find the connection string details by logging into our Control Panel -> Database. When you connect from your... Read More
How do I query MySQL database in ASP.NET?
Viewed 12135 times since Tue, May 1, 2012
In order to query your mySQL Database with ASP.NET script, you need to organize an ODBC connection with us first. The following the snippet of the code: <%@ Page Language="VB" %> <%@ import Namespace="System.Data.Odbc" %> <script runat... Read More
Can I have more than one MySQL database on my hosting account?
Viewed 8125 times since Tue, May 1, 2012
Yes. You can orderunlimited MySQL database add-ons per account. You can order your mySQL database add-ons via our Help Desk System -> Purchase Addon -> MySQL Addon. Alternatively, you can choose to upgrade your hosting service to a higher plan.... Read More
I cannot login to my MS SQL database remotely. What did I do wrong?
Viewed 6042 times since Mon, May 7, 2012
If you cannot login to your MS SQL database remotely via SQL Management Studio Express tool, there are few things you need to check: 1. Please make sure you use the correct SQL Server details. Since this is a remote SQL connection, it is recommended... Read More
Can you grant SELECT PRIVILEGE to the system table mysql.proc
Viewed 5766 times since Mon, Jun 18, 2012
Unfortunately, we cannot grant such privilege as it will expose our mySQL database to higher security risk. Please refer to http://forums.mysql.com/read.php?98,41655,230799#msg-230799 for more information Read More
Do you support MS SQL WebAdmin access?
Viewed 5158 times since Tue, May 1, 2012
We, unfortunately, has disabled the support of MS SQL WebAdmin. This is simply because of the fact that MS SQL WebAdmin can degrade the performance of your site, database and the overall server. As a replacement, you can consider using a FREE... Read More
How often do you backup my website?
Viewed 4376 times since Tue, May 1, 2012
We do nightly backup of all your website files, databases, emails and DNS information. We send the backup into a separate, remote tape drive. With this mechanism, you can be rest assured that your data remains safe and secure with us. We do, however... Read More
I receive this error message: "Unknown file type (binary data)" when trying to deploy my SQL CE database. What did I do wrong?
Viewed 3968 times since Thu, May 3, 2012
If you receive this error message, please try adding the following line to your web.config file: <identity impersonate="true" userName="XXXXXXXXX" password="XXXXXX" /> This line should be added inside the tag <system.web> </system.web>.... Read More
Do you support SQL Reporting Service (SSRS)?
Viewed 3719 times since Tue, May 1, 2012
Yes, support SQL Reporting Service (SSRS). This service is provided as an extra addon to your current base hosting service. You can purchase this addon via our Help Desk System -> Purchase Addon -> SSRS Addon Once the SQL Reporting Service (SSRS) is... Read More
What is the connection string for my MySQL database?
Viewed 3657 times since Mon, May 7, 2012
If you want to connect from your site to your mySQL database, you need to use localhost as the mySQL server details, together with the correct mySQL username and password that you create via our Control Panel Read More
Do you support Remote MSSQL connection?
Viewed 3491 times since Mon, Apr 30, 2012
Yes. We do allow remote MSSQL connection. This means that we allow a remote SQL connection from your PC to our database server via the free SQL Management Studio Express tool. At a certain period of time, Microsoft usually releases a new version of... Read More
Can I have more than one MS SQL database on my hosting account?
Viewed 3354 times since Tue, May 1, 2012
Yes. You can orderunlimited MS SQL database add-ons per account. You can order your SQL database add-ons via our Help Desk System -> Purchase Addon -> MSSQL Addon. Alternatively, you can choose to upgrade your hosting service to a higher plan. For... Read More
How can I change my SQL Server collation name?
Viewed 3061 times since Mon, May 21, 2012
In order to change the SQL Server collation name, first of all, you need to know the name of the collation you want to set. Since you do not have a direct permission to execute the command line: "ALTER DATABASE [database_name] COLLATE ... Read More
Do you support SQL 2014?
Viewed 3047 times since Tue, Feb 3, 2015
Starting from 1st Nov 2014, we have officially launched the new SQL Server 2012 on our new server. For those customers who registered before this date are still able to use SQL 2014 database. However, an account migration to a server that supports... Read More
Do you support SQL 2012?
Viewed 3027 times since Fri, May 4, 2012
Starting from 1st May 2012, we have officially launched the new SQL 2012 on our new server. For those customers who registered before this date are still able to use SQL 2012 database. However, an account migration to a server that supports SQL 2012... Read More
Do you support Remote mySQL connection?
Viewed 2961 times since Mon, Apr 30, 2012
Yes. We do allow remote MySQL connection. This means that we allow a remote mySQL connection from your PC to our database server via the free mySQL client tool. Read More
Can I have one database user associated to more than 1 MS SQL database?
Viewed 2935 times since Tue, May 1, 2012
Yes, we can certainly arrange it for you. Please be advised that our Control Panel only supports 1-to-1 association and this means that 1 database user can only be associated to 1 MS SQL database only. If you want 1 database user to be associated to... Read More
Do you support MS SQL Profiler?
Viewed 2920 times since Wed, May 23, 2012
Please be advised that in order to run SQL Profiler, we need to grant you a sysadmin role. Since this is a shared database server,this is not something we can grant you. We can grant you this role only if you are our dedicated server client. If... Read More
Do you support MySQL WebAdmin Access?
Viewed 2856 times since Tue, May 1, 2012
Yes, we do support mySQL WebAdmin access and you can access this tool by logging to our Control Panel -> Database -> click your mySQL -> WebAdmin. Read More
Can I set up additional logins for my MS SQL database?
Viewed 2689 times since Mon, Apr 30, 2012
Yes, you can setup additional database users login via our Control Panel -> click on your domain -> Database -> Add New Database User Read More
Can i login to my MySQL database via my own mySQL tool?
Viewed 2666 times since Mon, May 7, 2012
Unfortunately, if you want to administer your mySQL database remotely, you need to use our mySQL WebAdmin tool that is available from our Control Panel -> Database -> click your mySQL database -> WebAdmin. Read More
Can I set up additional logins for my MySQL database?
Viewed 2580 times since Mon, Apr 30, 2012
Yes, you can setup additional database users login via your Control Panel -> click on your domain -> Database -> Add New Database User Read More
Do you support SQL Server Integration Service?
Viewed 2534 times since Tue, May 1, 2012
No, we do not support SQL Server Integration Service (SSIS). We apologize for any inconvenience caused. Read More