WH4L

To export your SQL database to a .bak file you can use Microsoft SQL Server Management Studio Express. This is found in the start menu in: Programs > Microsoft SQL Server 2005 > SQL Server Management Studio Express OR Programs > Microsoft SQL Server 2008 > SQL Server Management Studio Express If you don’t already have mssms installed then you can get it from here: http://www.microsoft.com/express/sql/download/ Follow t...
Read the rest of this article

You may have the question "What is the app_data realy for?" if you just entered into the web developement world as a newbie. Below if a brief introduction of  app_data folder. Please keep on reading and  you’ll get the answer. App_Data allows you to use a file-based database.That includes not only SQL Server 2005 express and Access, but also XML files and Excel worksheets, among others, i.e., *any* file...
Read the rest of this article

Webhost4life supports ms access DB. Sometimes when you use ms access DB with webhost4life you may get error saying "…must be updateable query…" This usually happens when your .MDB file does not have WRITE permission.  To fix the problem,please login your hosting account at webhost4life and then go to File Permission under Security to modify file permission on the ms access DB file.  You will need to grant the u...
Read the rest of this article

Webhost4life sql servers are using sql authentication instead of windows authentication so you will need to pay attentication in your DB connection string about this. See difference of windows authentication and sql authentication here Here is  one sample DB connection string: "Data Source=sql-server-IP;Initial Catalog=DB-name;User Id=DB-user;Password=DB-password;Integrated Security=True" It will not work with webhost4life becau...
Read the rest of this article

If you are new to the Microsoft SQL Server environment, you probably encountered the possibility to choose between Windows Authentication and SQL Authentication. SQL Authentication is the typical authentication used for various database systems, composed of a username and a password. Obviously, an instance of SQL Server can have multiple such user accounts (using SQL authentication) with different usernames and passwords. In shared servers whe...
Read the rest of this article

If you are  hosting your website with webhost4life you’ll not be able to run aspnet_regsql.exe on their DB server because it requires system administrator’s permission to do that. But don’t worry about that because you can still do that on your own computer. Here are the instructions on how to do that. First, the following requirements need to be configured on your computer: Your home computer must have .net 2.0 install...
Read the rest of this article

How to connect MySQL DB with MySQL .NET connector at webhost4life? Here are the instructions you can follow up to do that: There is no installation required on server,  you only need to upload the Mysql.Data.dll to the site "bin" folder. You can download the MySQL .NET connector at ‘http://dev.mysql.com/downloads/connector/net/6.0.html’. The MySQL.Data.dll locates on the "Installation path\Assemblies". Defa...
Read the rest of this article

Webhost4life supports several types of databases such as MSSQL, MySQL, Excel, Excel 2007 and Access in asp.net application. If you are creating an asp.net application but having no idea how to connect your database to your web application then please have a look at the DB connection samples below: MSSQL ASP.net connection "Server=DB Server;Database=DB NAME;uid=DB ID;pwd=DB Password;" providerName="System.Data.SqlClient" OLE DB connection strin...
Read the rest of this article