Processing
Knowledge Base 
Search the Knowledge Base for

Here you can search and view our site Knowledge Base.
To find a specific article, use KB-article number format (ex. KB-1)

Article number: Article number: kb-27
Q. How can I access to the MSSQL database from my website?

A. It depends on the programming techniques which can be used to access to the databases. Below you can find some example with different technique which can be used to access to databse.
--ASP (using ODBS DSN)

set Conn = server.createobject("adodb.Connection")
Conn.Open System_DSN
set RS = server.createobject("adodb.recordset")
SQL = "select * from table"
RS.Open SQL, Conn,1,2

while not RS.eof
......
rs.moevnext
wend
RS.close
set RS=nothing
Conn.close
set COnn=nothing
--ASP.Net 1.1</b>
In <appSettings /> section of web.config
<add key="DBConnStr" value="server" />

Code in the web page
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

bool ret=false;
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["DBConnStr"].Trim().ToString());
try
{ myConnection.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "UpdateShopCartQty";
myCommand.CommandType = CommandType.StoredProcedure;
.....

//myCommand.ExecuteNonQuery();
ret = true;
}
catch (Exception er)
{
this._lasterror = er.Message;
ret = false;
}
finally
{
if (myConnection.State == ConnectionState.Open)
myConnection.Close();
myConnection.Dispose();
}

--ASP.Net 2.0

In <configuration /> section of Web.config <connectionStrings>
<add name="ConnectionString" connectionString="server" />
</connectionStrings>

Code in the web page using System.Data;
using System.Data.SqlClient;
bool ret=false;
SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
try
{ myConnection.Open();
SqlCommand myCommand = new SqlCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "UpdateShopCartQty";
myCommand.CommandType = CommandType.StoredProcedure;
.....

//myCommand.ExecuteNonQuery();
ret = true;
}
catch (Exception er)
{
this._lasterror = er.Message;
ret = false;
}
finally
{
if (myConnection.State == ConnectionState.Open)
myConnection.Close();
myConnection.Dispose();
}
This page has been viewed 4185 times

Other questions in this category Other questions in this category
1. How can I manage my databases under Hosting Control Panel? (viewed 1903 times)
2. How can I create a new Database? (viewed 1818 times)
3. WINDOWS AUTHENTICATION and Data Base connection (viewed 1803 times)
4. How can I make backup and restore a MSSQL Database? (viewed 1792 times)
5. How can I add a new database user to my existing Database? (viewed 1704 times)
6. What's the solution of user "sys" issue and the differences between MYSQL 2000 and 2005 (viewed 1704 times)
7. I'm getting error when try to write into MS Access database. (viewed 1679 times)

Return to Search
Home |  Hosting |  Domains |  Support |  Log In |  Create Account |  Terms
Eden P Host
3500 Dufferin St Suite-310
Toronto, Ont, Canada M3K 1N2
Tel: 416-477-6011











Business Web Hosting, domain names, Cheap web design, Web site promotion (SEO), Mobile Apps development for Iphone, android, blackberry and galaxy phone and web sites and more!

EPH not only is known as a domain names registrar, Eden P Host is also a complete small business online solution: Business Web hosting, cheap web design, Mobile Apps for the web site and Iphone , Andriod phone, blackberry phone in Toronto, E-Commerce, Web site promotion, fully Managed Web hosting and more!

Trust years of domain names registration in Canada

Not only is EPH a leader in the Canadian Web hosting and domain name registration in toronto of canada today, we were among the first Canadian domain name registration service from 1996. While there are now many domain name registrars to choose from, none of them possess the domain name expertise that Eden P Host does. Put our 13 years of experience in domain name registration to work for you. Choose from multiple popular extensions, protect your personal WHOIS information with private registration, renew, transfer, and backorder domain names. Or choose from one of our online small business solutions that include a free domain name -- like Web hosting or ecommerce web sites.

Get reliable Web hosting

A free domain name address comes with every Website hosting annual package offered by Eden P Host. Unlike many Web hosting companies, Eden P Host Web hosting service is backed by award-winning customer service. Our 24/7 technical support means that if you ever run into a problem with your hosting service, a trained professional is on call to help you. No matter what size server capacity you need, we have a affordable Web hosting package that will suit your needs. We support , Joomla , Mambo, Durpal and wordpress hosting along with Mssql and Mysql hosting for various ecommerce web site. To learn more about our Economy , Deluxe, and Business Plan, please visit the Web Hosting page. When choosing your Web hosting provider, be sure to note all of the features involved before deciding which hosting plan is right for you. 

Any-size store e-commerce solutions

Need additional shopping cart software? Then we'll add the hosting for free when you use one of our user-friendly e-commerce platforms. Eden P Host knows that all online ecommerce web design endeavors are not alike. That's why we have the best and affordable shopping cart software (that come with free e-commerce Web hosting) to fit your needs. Selling anywhere from 1 to 1000 and 1000 products and want a quick and simple storefront setup? Then our E-Commerce software will be right up your alley. Or, if you need more robust software to launch your multi-faceted online store, then "Business Plan" of hosting a E-Commerce site is what you are looking for. And add security with the use of SSL certificates, managing your online store will be a breeze. Learn more about e-commerce shopping cart by sending your business needs to us. We also offer Mobile Apps for the ecommerce web site over Iphone , Andriod phone, blackberry phone in Toronto

Affordable web site design, Cheap Web design and Mobile Apps development In Toronto

Don't exhaust your small business budget on a high-priced, private Web designer. Eden P Host can give you the same caliber of Professional Web design for a fraction of the price, and with an overlooked bonus -- stability.

These days designing an affordable web design and ecommerce web site is more feasiable. With EdenPhost's CMS your web site design will be done in less than two day and store onloine ( web site with shopping cart0 will be operational in less then 1 day. ;

We also develop Mobile apps for any web site and any ecommerce web site . It will show in Andriod phone, Iphone, blackberry phone and Galaxy phone.
Our professional web designer in Toronto will make your web site design a pleasant experience and your store online web site a money maker web site

Looking to sell online and grow your business with online store

Choosing Eden P Host, a long-time leader in small business solutions, will mean you never have to worry about tracking down your Toronto Web designer or being left with a cheap website design and no support. Our Do-It-For-Me cheap Web design plan offer allotted modification time every month for you to make changes to your web design. So, don't panic when you want to change the colors, pictures, or other details on your site; with any of our CMS packages, all you need to do is give us a call or simply login and do it by your self, You dont have to know any programming. Not at all. Yes it is that easy.

Get an affordable website built for your business. Work with our experts to get a website designed for your small business, a targeted online marketing program.
Start selling your products online. Our cheap ecommerce design team will help you build an online store using advanced Joomla CMS and Mobile apps development for your store front online.

Complete Web site promotion for Small Business

With millions of websites to compete with, getting your site found online can be very difficult and time-consuming. Spend time running your business instead, and let us do the Web site promotion for you. We have an impressive array of online marketing solutions that can boost your major search engine rankings, increase your link popularity, and get your business name in the online news sources. We can even manage your pay per click advertising campaign to provide immediate results. Or, for the more hands-on approach, you can try our Search Engine Visibility package that provides you with the essential tools to be found online.

Affordable Search engine optimization consultants aren't hard to find now days, but finding one with years of experience and an impressive record of success is. It is important if your SEO consultant has any experience in small business SEO? or not? since search engine optimization for small business is not an easy task. It is a combination of art and science By hiring search engine optimization consultants from Eden Phost team as your SEO consultants would be the best investment that you might did for your SEO needs Sometimes all you need is some good, solid advice to get you going.

Eden P Host has worked for over 17 years to bring affordable solutions to small businesses everywhere. We continually work to keep that statement true and help it apply to your business too.

Virtual Private Servers (VPS) are a perfect solution for webmasters, website designers, web developers, and small business owners. Here at EdenPhost we charge a minimal amount per month, which you can then utilize for your cheap webhosting or cheap web design packages that you as web site developer or web designer might have or in any method that you desire. Eden Phost Virtual Private Servers (VPS) are designed for the client who would like to have the highest quality and reliability in server hardware, with the software and operational features of a dedicated server all at a price closer to that of Virtual web Hosting.

E.P.H Hosting Canada, offers the following services: Canada website hosting, Canada website design and development, graphic design, logo creation and search engine positioning. From our Toronto office we offer services through out Canada and the US. When it comes to full managed website hosting our server uptime and transfer speeds are invincible. We are certain that once you try our Canadian Web hosting service that you will be completely satisfied! As a Canadian website hosting company we are committed to providing you with high-quality, affordable Canadian web hosting. From our Online website builder to our custom web design in Toronto or Joomla web design and shopping cart web design you can’t go wrong with Canada’s leading Web Design and Hosting company. Offering free domains to all our clients from .com, .net, .CA Domains… and more. Even Free Canadian Domain Registration for our Canadian clients. E.P.H hosting com Canada, is here to help get your Canadian Business online. With custom ecommerce web design and affordable and cheap web design in Toronto of Canada and online website builder you can’t go wrong. Free Domains registration with any Canadian web hosting package. We will communicate your image clearly and powerfully to your intended target audience

Our cheap web design Toronto team specialize in taking your website from concept to the finish line and making the dreams you have for your website a reality. If you are ready to take your business to the next level, then take advantage of our expertise and cutting-edge web marketing technology. Fill out our free consultation form to see how we can optimize the potential of your website. We look forward to helping you drive forward your exciting goals for the web.

Above all,Eden P Host will take care of you and your business. Our reputation allows us to deliver unbeatable service to over 28,000 existing customers worldwide. We truly look forward to welcoming you to the Eden P Host Toronto Web Hosting family and hope you will continue to host with us for many years to come!

At Eden P Host, we offer a variety of business web hosting plans ( offers Mysql. MSsql , CMS, Joomla, Mambo, Wordpress and durpal) along with cheap web deisgn and affordable website design in Canada, US and Toronto to bundle with your modest or more demanding web presence project, on a variety of platforms. Your design requires a perfect match when it comes to hosting and delivery; we have it from the best ISP infrastructure in the world!