How do I Access database from my ASP.NET application ?


Error: Your Requested widget " bcn_widget-2" is not in the widget list.
  • [do_widget_area colormag_advertisement_above_the_footer_sidebar]
    • [do_widget id="custom_html-10"]
    • [do_widget id="custom_html-11"]
    • [do_widget id="custom_html-13"]
    • [do_widget id="colormag_125x125_advertisement_widget-2"]
    • [do_widget id="text-15"]
    • [do_widget id="custom_html-9"]
    • [do_widget id="custom_html-12"]
  • [do_widget_area colormag_contact_page_sidebar]
    • [do_widget_area colormag_error_404_page_sidebar]
      • [do_widget_area colormag_footer_sidebar_four]
        • [do_widget id="custom_html-3"]
        • [do_widget id="text-7"]
      • [do_widget_area colormag_footer_sidebar_full_width]
        • [do_widget_area colormag_footer_sidebar_one]
          • [do_widget id="custom_html-6"]
          • [do_widget id="custom_html-7"]
          • [do_widget id="custom_html-8"]
          • [do_widget id="text-38"]
          • [do_widget id="text-3"]
          • [do_widget id="text-4"]
        • [do_widget_area colormag_footer_sidebar_one_upper]
          • [do_widget_area colormag_footer_sidebar_three]
            • [do_widget id="custom_html-4"]
            • [do_widget id="text-6"]
          • [do_widget_area colormag_footer_sidebar_three_upper]
            • [do_widget_area colormag_footer_sidebar_two]
              • [do_widget id="custom_html-5"]
              • [do_widget id="text-5"]
            • [do_widget_area colormag_footer_sidebar_two_upper]
              • [do_widget_area colormag_front_page_area_beside_slider]
                • [do_widget_area colormag_front_page_content_bottom_section]
                  • [do_widget_area colormag_front_page_content_middle_left_section]
                    • [do_widget_area colormag_front_page_content_middle_right_section]
                      • [do_widget_area colormag_front_page_content_top_section]
                        • [do_widget_area colormag_front_page_slider_area]
                          • [do_widget_area colormag_front_page_top_full_width_area]
                            • [do_widget id="text-17"]
                          • [do_widget_area colormag_header_sidebar]
                            • [do_widget id="custom_html-2"]
                            • [do_widget id="text-8"]
                            • [do_widget id="text-27"]
                            • [do_widget id="text-23"]
                          • [do_widget_area colormag_left_sidebar]
                            • [do_widget id="text-19"]
                          • [do_widget_area colormag_right_sidebar]
                            • [do_widget id="text-13"]
                            • [do_widget id="search-2"]
                            • [do_widget id="colormag_300x250_advertisement_widget-3"]
                          • [do_widget_area widgets_for_shortcodes]
                            • [do_widget id="breadcrumb_navigation_widget-5"]
                            • [do_widget id="text-16"]
                            • [do_widget id="text-20"]
                            • [do_widget id="text-24"]
                            • [do_widget id="text-25"]
                            • [do_widget id="bcn_widget-2"]
                            • [do_widget id="text-28"]
                            • [do_widget id="text-29"]
                            • [do_widget id="text-30"]
                            • [do_widget id="text-31"]
                            • [do_widget id="text-32"]
                            • [do_widget id="text-33"]
                            • [do_widget id="text-34"]
                            • [do_widget id="text-35"]
                            • [do_widget id="text-37"]
                          • [do_widget_area wp_inactive_widgets]
                            • [do_widget id="text-12"]
                            • [do_widget id="colormag_300x250_advertisement_widget-4"]
                            • [do_widget id="recent-posts-2"]
                            • [do_widget id="recent-comments-2"]
                            • [do_widget id="archives-2"]
                            • [do_widget id="meta-2"]
                            • [do_widget id="pages-3"]
                            • [do_widget id="text-22"]
                          Windows Web Hosting allows you to access the database from your ASP.NET application. Please refer the below details to know how to connect the ASP.NET application with your Database.


                          Share This Now: [addtoany]

                          Watch Reseller Hosting Video Tutorial



                          Procedure

                          Connection String to access the MSSQL Database :

                          Windows Reseller Hosting comes with Plesk Control Panel.  You can use the below connection string in your web.config file to access the database from your Application.

                          <add name=”sqlConStr” connectionString=”Data Source=serverIP; Initial Catalog=databasename;User ID=databaseusername;Password=password;” providerName=”System.Data.SqlClient”></add>

                          Data Source :  You can supply the IP of your Hosting server (or) You can use localhost.

                          Initial Catalog :  Your Database Name

                          User ID : Your Database Username

                          Password : Your Database Password

                           

                          Screen Shots

                          Refer Screen Shots

                          Troubleshooting FAQs

                          Mysql Database Troubleshooting FAQs

                          Mysql database option is not showing to create a database for my domain ?

                          Solution :

                          Please note that if you are not allocating MYSQL database for the service plan of the domain,then you will not able to see database icon.

                          To overcome this,you need to allocate the MYSQL database and database quota for your service plan of your domain and sync the domain with the plan.

                          To change the resource of your service plan.

                          [1] Login to your plesk control panel.
                          [2] Click on service plan.
                          [3] Click on service plan name of that domain.
                          [4] Allocate MYSQL database and database quota.
                          [5] Click on ok.

                          To sync the plan with your domain.

                          [1] Login to your plesk control panel.
                          [2] Click on the subscription name
                          [3] Click on sync.

                          Downloads

                          Related Downloads

                          Related Articles