Web Hosting and Domain registration Knowledgebase
msgbartop
Gossimer’s Premier Web Hosting and Domain Registration Knowledgebase.
msgbarbottom

29 Jul 10 Deleting MS SQL Database Users

Follow the process mentioned below to delete an existing MS SQL Database user:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package.

2. In the search results view, click on the domain name. This will take you to the Order Details View.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.

5. The following page would contain a list of Databases associated with your website, with complete details for each Database such as the Database name, space utilization and the Users associated with it. Here, click on the User whom you wish to delete.

6. In the User details view that follows, click on Delete.

Tags: , , , , , , , , , , , , , , , ,

Filed in Managing MS SQL Database Users with 0 Comments

28 Jul 10 What is a DSN and how can I use a DSN or a DSN-less connection to connect to a database?

DSN is an abbreviation for Data Source Name. Data Source Name is a parameter that stores Data Source information (which includes the source of data such as relational database, and the connectivity information for accessing the data). The primary purpose of the DSN is to provide connectivity to a database through an ODBC driver.

What is ODBC?

ODBC stands for Open Data-Base Connectivity. This is a method developed for accessing databases, particularly with the intention of making it possible to access the data in them from any application. Thus, it works independent of the Database Management System (DBMS) that is used to maintain the database.

The Data Source information stored in the DSN typically consists of

  • the database name,
  • directory,
  • the database driver,
  • a UserID,
  • its password, and
  • any other essential information

DSNs are particularly useful for retrieving data from your databases to display on your website. Once you create a DSN for your database, you can use the DSN in your website to retrieve and display that information on your database.

You may connect to a database even without creating a DSN, by using a DSN-less connection. The only change is use of a Connection String in place of a rather easy to remember DSN.

Advantages of using a DSN Connection string over a DSN-less connection string

  • Provides easy to remember data source names.
  • When there are lots of data sources to use and you want a central repository to hold the collection of data sources without having to worry about the actual site and configuration of the data sources.

Sample of a DSN Connection String
 


<%
Dim con
Set con = Server.CreateObject(“ADODB.Connection”)
con.Open “DSN=mydsn”
‘ Now database is open and we are connected
con.Close
‘We are done so we’ve closed the connection above
Set con = Nothing
%>
 

 

There is only a singular advantage of using a DSN-less Connection string instead of a DSN connection string – database access becomes much faster since DSN-less connections use native OLE DB providers, while DSN connections make use of ODBC drivers.

Sample of a DSN-less Connection String

Access database  

<%
set cnn = server.createobject(“ADODB.Connection”)
cnn.open “PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=c:anydatabase.mdb”
%>

Note: In the above example, C:anydatabase needs to be replaced with the actual physical path to the database on the website.  

How to construct a DSN-less connection string for Access and SQL Server Databases?
 

Access Database  

With native OLE DB Provider (preferred)

Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:pathtodatabase.mdb

Using ODBC connection

Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:pathtodatabase.mdb 

 

Always use the connection string that uses native OLE DB provider because it is faster than the ODBC method of connecting. Data Source or DBQ are the absolute path to the database. If you have a relative path, then you can obtain the absolute path by using Server.MapPath(“/relative/path/to/database.mdb”).

Example

Dim conStr
Set conStr = “Provider=Microsoft.Jet.OLEDB.4.0; Data Source=” & _
Server.MapPath(“/dbo/database.mdb”)
 

SQL Server Database

With native OLE DB Provider (preferred)Provider=SQLOLEDB; Data Source=server_name; Initial Catalog=database_name; User Id=user_name; Password=user_password   

Using ODBC Provider

Driver={SQL Server}; Server=server_name; Database=database_name; UID=user_name; PWD=user_password

 

 

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Filed in DSN Manager with 0 Comments

28 Jul 10 MS SQL DTS (Data Transformation Service)

DTS (Data Transformation Service) or the Import / Export utility as it is widely known as, is used to transfer objects and data between 2 SQL Server databases residing on 2 different Servers. DTS is a set of graphical tools and programmable objects that let you extract, transform, and consolidate data from disparate sources into single or multiple destinations that can be bundled and saved as a package and executed.

How to use DTS?

You can use the DTS utility by referring to the process mentioned below -

  1. Open MS SQL Enterprise Manager.
     

  2. Right click the database whose contents you wish to transfer to a different database on another MS SQL server or onto which you wish import external data.
     

  3. Click All Tasks.
     

  4. Click Import or Export depending upon the type of activity you are performing (If you are trying to update the database on our Server with the copy on your local machine, then you would need to export the data from your local machine).
     

  5. Select the Data Source as Microsoft OLEDB Provider For SQL Server.
     

  6. Enter the IP Address / Name of the Server from where you are exporting the data.
     

  7. Select SQL Authentication as the Auth Mode.
     

  8. Enter the Username and Password to login to the database.
     

  9. Select the database from the drop-down list.
     

  10. Click Next & enter the destination Server IP Address.
     

  11. Enter the Username and Password for the database on the Remote Server.
     

  12. Select the database from the drop-down list and click Next.
     

  13. Select the radio button Copy Objects & Data between SQL Server Databases and click Next.
     

  14. Uncheck Copy all objects & Use default options checkboxes. You would be selecting the options & objects to be copied.
     

  15. Click Select Objects & uncheck the check box for Stored Procedures & User defined Functions.
     

  16. Click Check all and then click OK.
     

  17. Click Options and uncheck  the check box for Copy Database Users & Database Roles & Copy Object Level permissions.
     

  18. Click Next and run the package immediately or schedule it for a later run.
     

  19. Click Finish to complete the process.

    20.  

 

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

27 Jul 10 What is MS SQL?

Microsoft SQL Server (MS SQL) is a full-featured relational database management system (RDBMS), available as a database option with every Gossimer Windows Web Hosting package.

MS SQL is very robust, powerful and scalable and is capable of storing very high volumes of data. It also offers database transaction feature and a variety of administrative tools to ease the burdens of database development, maintenance and administration. It is the ideal database for web applications written in ASP, ASP.Net.

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

26 Jul 10 Viewing a list of all FTP Users

Follow the process mentioned below to get a list of all FTP users associated with your web hosting package.

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to read how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> FTP User Manger -> List FTP Users.

This would give a detailed list of all FTP users associated with your web hosting package.

Tags: , , , , , , , , , ,

Filed in Managing FTP Users with 0 Comments

26 Jul 10 Adding a MS SQL Database

Follow the process mentioned below to add a MS SQL database for your website:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>

2. In the search results view, click on the domain name. This will take you to the Order Details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> Add Database.

5. On this page, specify

  • the Database Name, i.e. the name by which your database would be referred to.
  • the amount of space you wish to allot for this database, in Megabytes (MB).

6. Additionally, you would also have to add a user to access this database. Specify the username and password for this user. You can add further users to access this database as well. Click here to know how to add users to an existing MS SQL database >>

7. Once you have specified these details, click on Submit.

IMPORTANT

  • The success message in the resulting page will display IP Address of the Database Host Server on which the database has been created. This IP Address needs to be used while connecting to the database.
     
  • In case of multiple databases, the Database Host Server may be different for each database. Hence, the specific IP Address mentioned in the success message is to be used for each database.

Tags: , , , , , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

25 Jul 10 How do I restore a MS SQL database?

Gossimer Windows Hosting Control Panel allows you to restore an existing database from a backup copy as explained below:

1. Login to your Control Panel, search for the domain name for which you have purchased the Web Hosting package and go to the Order Details view. Click here to know how >>

2. Click Manage Web Hosting Service in the lower toolbar.

3. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.

4. Click the database you wish to manage.

5. Click Restore Database. Select the Database Username from the drop-down menu next to Database Username. This user will own all tables, views and stored procedures in the restored database, if the current owner of the backup file does not exist on Gossimer SQL server.

Select the backup file from the drop-down menu next to File to be Restored. You can select the backup which was saved on the server in the sqlDatabaseBackup directory or you can upload a .bak backup file onto the sqlDatabaseBackup directory and select it from the list.

6. Click Submit to restore the database.

Reference: Uploading content to your Website using FTP >>

IMPORTANT 

Effective from 15 November 2007, all databases (MS SQL) purchased on Gossimer Windows Hosting Servers will be created on MS SQL 2005 Servers. There exists a backward compatibility issue with SQL 2005 in restoring a database to SQL 2000 (or an earlier version of MS SQL). This is on account of Microsoft not providing backward compatibility with earlier versions of MS SQL due to different internal file structures.

An alternate method would be usage of MS SQL Server Database Publishing Wizard. MS SQL Server Database Publishing Wizard enables the deployment of SQL Server databases either into 2000 or 2005 hosting environment. It generates a single SQL script file which can be used to recreate a database (both schema and data) for SQL 2000 and SQL 2005 versions. Click here to download this tool >>

There is no issue restoring SQL 2000 (or any earlier version) database to SQL 2005 version.

 

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

24 Jul 10 How do I truncate transaction logs of a MS SQL database?

MS SQL database has a facility to store transaction logs. However, old transaction logs which maybe no longer required occupy space unnecessarily. Gossimer Windows Hosting Control Panel allows you to truncate transaction logs so as to control unnecessary space utilization.

Follow the process below to truncate transaction logs:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.

5. Click on the database you wish to manage.

6. Click Truncate Transaction Log to complete the process.  

The Transaction logs are truncated to the maximum limit possible. If you wish to reduce the space allocated for logs, you should ideally truncate the logs first and then reduce the space allocated. You will be allowed to reduce the space allocated only upto the size of the actual truncated log file.

Reference: How do I set the database size and transaction log size of a MS SQL database >>

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

23 Jul 10 ASPUpload Component

ASPUpload is an Active Server component which enables an ASP application to accept, save and manipulate files uploaded with a browser. The files are uploaded via an HTML POST form with one or more <INPUT TYPE=FILE> tags. The <FORM> tag must contain the attribute ENCTYPE=”multipart/form-data”. All Gossimer Windows Hosting packages have support enabled for ASPUpload component. You can use the sample script provided below and tweak it a bit to suit your requirements.

 

Upload Script (Upload.asp)

<%
Set Upload = Server.CreateObject(“Persits.Upload”)
Count = Upload.Save(“C:WHBSitesyourdomainname.comdatafiles”)
Response.Write Count & ” file(s) uploaded to C:WHBSitesyourdomainname.comdatafiles”
%>

HTML form for uploading up to 3 files

<HTML>
<BODY BGCOLOR=”#FFFFFF”>
<FORM METHOD=”POST” ENCTYPE=”multipart/form-data” ACTION=_quot;Upload.asp_quot;_gt;
<INPUT TYPE=”FILE” NAME=”FILE1″ SIZE=”50″><BR>
<INPUT TYPE=”FILE” NAME=”FILE2″ SIZE=”50″><BR>
<INPUT TYPE=”FILE” NAME=”FILE3″ SIZE=”50″><BR>
<INPUT TYPE=”SUBMIT” VALUE=”Upload!”>
</FORM>
</BODY>
</HTML>

 

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Filed in ASP Components with 0 Comments

23 Jul 10 Modifying/Deleting a DSN

If you wish to modify any parameters for an existing DSN or delete the DSN, you need to follow the process outlined below:

1. In the Website Management interface, go to Manage Website -> DSN Manager -> List DSNs.

2. In the DSN list that follows, click on the DSN you wish to modify. Make any changes that you wish here.

3. If you wish to delete the DSN, simply select the check-box before the desired DSN in the list, and click on Delete.

Tags: , , , , , ,

Filed in DSN Manager with 0 Comments

21 Jul 10 Changing the Password for an FTP User

You should make it a habit to change your FTP User password at regular intervals. Follow this process to modify the password for an existing FTP user:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to read how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> FTP User Manger -> List FTP Users. This would give a list of all FTP users associated with your web hosting package.

5. In the user list view that follows, click on the user whose password you wish to change.

6. Enter the new password in the Password and Confirm password slots, and click on Submit.

Tags: , , , , , , , , , , , , , , , , ,

Filed in Managing FTP Users with 0 Comments

21 Jul 10 How do I shrink a MS SQL database?

Gossimer Windows Hosting Control Panel allows you to shrink a MS SQL database. The process is explained below:

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to know how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> Database Manager -> List Databases.

5. Click on the database you wish to manage.

6. Click Shrink Database to complete the process.  

Tags: , , , , , , , , , , , , , , , , ,

Filed in Databases with 0 Comments

21 Jul 10 Listing / Modifying an existing Virtual Directory

If you wish to list/modify your existing Virtual Directories, you may do so by following the below mentioned process:

  1. Login to your Control Panel, search for the Domain Name for which you have purchased this Web Hosting package and proceed to the Order details view. Click here to know how >>
     
  2. Click Manage Web Hosting Service in the lower toolbar. A Website Management interface will pop-up.
     
  3. Go to Manage Website -> Virtual Directory Manager -> List Virtual Directories. This will list all Virtual Directories you have added so far.
     
  4. Click the Virtual Directory you wish to modify.
     
  5. Here you may choose to modify the version of your .NET Application from the drop-down menu.
     
  6. You may also grant/deny write permissions to the IIS (anonymous) User on this Virtual Directory.
     
  7. Click Submit to save the changes.

    8.  

 

Tags: , , , , , , , , , , , , , , ,

Filed in Virtual Directory Manager with 0 Comments

19 Jul 10 What is the Maximum Number of Connections allowed to a single MS SQL database?

There are no restrictions set by Gossimer on the number of connections that you can establish to a particular database. However, in the event that you establish so many connections that the server’s performance gets degraded, we would have to restrict some connections to ensure service availability to our other customers as well.

Tags: , , , ,

Filed in Databases with 0 Comments

19 Jul 10 Which version of MS SQL is supported?

Gossimer currently supports MS SQL Server 2005 – 9.00.1399.06 (X64) Developer Edition (64-bit).

Tags: , , ,

Filed in Databases with 0 Comments

17 Jul 10 How do I Upgrade my MS SQL 2000 database to MS SQL 2005?

Follow the below mentioned instructions to upgrade your existing MS SQL 2000 database to MS SQL 2005:

  1. Take a backup of the current database. Click here to know how to make a backup copy of your db >>
     

  2. Delete the database that you have just backed-up from your Gossimer Control Panel. Click here to know how to Delete your database >>
     
  3. Add the MS SQL 2005 database from your Gossimer Control Panel. Click here to know how to Add a database >>
     

  4. Restore your MS SQL 2000 database backup. Click here to know how to Restore your database >>
     

Tags: , , , , , , ,

Filed in Databases with 0 Comments

16 Jul 10 Adding an FTP User

Follow this process and add FTP users to upload content for your website.

1. Login to your Control Panel and search for the domain name for which you have purchased this hosting package. Click here to read how >>

2. In the search results view, click on the domain name. This will take you to the order details view.

3. Click on Manage Web Hosting Service in the lower toolbar.

4. In the Website Management interface pop-up that follows, go to Manage Website -> FTP User Manger -> Add FTP User.

5. The form on this page has the following details, specify these for the new FTP user:

  • Username: A standard username for the new FTP user.
  • Password: A password which the new FTP user would provide on login.
  • Home directory: The user will automatically be directed to this directory; his access will be restricted to this directory and all its sub-directories. This user will not be able to access any files in a parent directory. The “Home Directory” has to exist at the time of adding the user; by default, it is set to root.
  • Access Permissions: Read, Write and Execute permissions for the FTP user.

6. Once you have provided all details necessary, click on Submit.

Tags: , , , , , , , , , , ,

Filed in Managing FTP Users with 0 Comments

14 Jul 10 Deleting an existing Virtual Directory

If for some reason, you wish to delete your existing Virtual Directory, you may do so by following the below mentioned process:   

  1. Login to your Control Panel, search for the Domain Name for which you have purchased this Web Hosting package and proceed to the Order details view. Click here to know how >>
     
  2. Click Manage Web Hosting Service in the lower toolbar. A Website Management interface will pop-up.
     
  3. Go to Manage Website -> Virtual Directory Manager -> List Virtual Directories.
     
  4. Select the checkbox adjacent to the Virtual Directory you wish to delete and click the Delete button above to delete the Virtual Directory.
     
  5. Click OK in the confirmation pop-up window to complete the deletion process.

    6.  

IMPORTANT    

A Virtual Directory with .NET Framework version 1.1 and no write permissions for the IIS (anonymous) User is created for the web folder by default. You cannot delete this Virtual Directory. You may however -

Tags: , , , , , , , , , , , , , , , , , , ,

Filed in Virtual Directory Manager with 0 Comments
« Previous Posts
sidebartop

Recent Posts

sidebarbottom
sidebartop

Some good Links

sidebarbottom
sidebartop

Favorite Gossimer Links

sidebarbottom
sidebartop

Categories

sidebarbottom
sidebartop

Tags

Admin Control Panel Amp Api Biz Contact Details Control Control Panel Customer Control Panel Database Manager Database Name Details View DNS Domain Name Domain Names Email Address European Union Gossimer Gt 2 HTML http Invoice Linux Lt Management Interface Manage Web Hosting Service Microsoft Windows Parameters Payment Gateway Php Power Tool Registrar Reseller Control Panel Resellers Search Domain Servers Service Button Supersite View 3 Web Hosting Web Hosting package Web Hosting Service Web Server Web Service Website Builder Website Management
sidebarbottom
sidebartop

RSS Gossimer in the News

  • Gossimer Puts Indian Domain Extensions Up for Sale February 21, 2010
    Gossimer, the fastest growing domain name registration and web hosting company has announced a sale on Indian domain extensions. During the promotion period, domains ending with .in will be offered at discounted price. [PR.com] […]
  • Gossimer Unveils a New & Improved Payment System February 14, 2010
    The Melbourne-based (Florida) web hosting and domain name registration company Gossimer has announced the inclusion of three more payment options in its system. From today the customers and the web hosting resellers can use AlertPay, WebMoney, and Liberty Reserve to pay for the domain registration as well as web hosting services. Gossimer already offered Pay […]
  • Gossimer Has Opened Its Treasure Chest for Webhost Resellers January 16, 2010
    Gossimer, the fast growing domain name registration and web hosting company has yet again opened its door of their reseller program. This program offers a comprehensive web hosting product portfolio for resellers and resellers of Gossimer’s resellers. [PR.com] […]
  • Gossimer Invites Customers to Try Digital Certificates for Free January 2, 2010
    Gossimer, the fastest growing domain name registration and web hosting company is offering 21 days free trial on digital certificates. This trail will allow webmasters to understand the role Https plays in building visitors’ confidence in their website. [PR.com] […]
  • Gossimer Announces Special Domain Name Registration Deals December 25, 2009
    Gossimer, the fastest growing domain name registration and web hosting company has announced a special deal on 12 top domain extensions and that includes some CTLDs as well. This promotion is available on the registration of new domain names, and you can register as many domains as you want. [PR.com] […]
  • Gossimer Announced a Transfer-in Domain Promotion to Allow Customers to Consolidate Their Domains Into One Account November 7, 2009
    Save money on domain name transfer to Gossimer. Gossimer is currently running an attractive promotion on domain transfer-in that will save a lot of money for the domain portfolio builder. You can transfer as many domains as you wish under this promotion. [PR.com] […]
  • Gossimer Became Reseller of the Month for October October 17, 2009
    October brings another piece of good news for Gossimer. The fastest growing web hosting and domain name registration company has been chosen as the Reseller of the month for October by ResellerClub. [PR.com] […]
  • Gossimer Offers One Year Free Extension on Domain Transfer October 3, 2009
    Gossimer, the fastest growing domain name registration company, is offering one year free extension with every domain name transferred to its system. This service when coupled with other services puts Gossimer in the position of price leadership. The company offers the most economic rate for domain name registration and webhosting services. [PR.com] […]
  • New Deals Make Gossimer Bigger, Better and Smarter October 2, 2009
    October is going to be hot with offers, extended support, and enhanced serviceability, as Gossimer has acquired HiTek Networks, and launched new and improved Support desk. The web hosting world is abuzz by the two important developments in Gossimer. [PR.com] […]
  • Gossimer Offers Unlimited E-mails for $1 September 28, 2009
    Gossimer, the fastest growing domain name and webhosting company, has announced a no-upgrade “The Ultimate Email Plan” that will give the buyer an access to unlimited email accounts for just $1/month. [PR.com] […]
sidebarbottom
sidebartop

RSS Gossimer Promotions and Announcements

  • TechSupport Notifications February 28, 2010
    Technical support information and notifications […]
  • PHP4 Discontinuation - 18th September September 7, 2009
    As announced earlier, PHP4 will not be supported on our Linux Hosting Servers from the 18th of September, 2009. Please pass on this information to your Customers and Resellers to ensure that they can update their websites to work with PHP5. […]
  • .CN Launch - Coming Soon August 16, 2009
    We are glad to announce the launch of .CN - the most popular and fastest growing ccTLD worldwide. The .CN domain extension has seen an exemplary growth since its launch throughout the world. Earlier this year, .CN crossed over 13 million registrations to become the second most registered domain extension after .COM. Moreover, with China now representing the […]
  • Live Chat Product Discontinuation - Moved to 18th August August 16, 2009
    Based on feedback that we received from several Resellers, we have decided to postpone the Live Chat discontinuation to the August of 18th, 2009 at 12:30 UTC. From the 18th of August, it will not be possible to purchase new Live Chat packages but exisiting packages will continue to function normally. […]
sidebarbottom
© Web Hosting and Domain registration Knowledgebase