Home - Help & Support - Contact Us
    
Web Hosting Web Design Website Templates Web Directory Website Marketing Webmaster Tools Make Money

Connecting To A SQL Server Database Using ASP.NET 2.0

Before you upload your ASP.NET 2.0 application onto your hosting server, you need to modify the connection strings section of your web.config file.

NOTE: You may want to back up the web.config file on your local computer or simply comment out your current connection strings before you make any changes. This way, you can easily return to developing your application on you local computer.

This is an example of the connection strings section that will connect an ASP.NET 2.0 application to one of our SQL Servers:

<connectionStrings>

<add name="Personal" connectionString="
Server=whsql-v04.prod.mesa1.secureserver.net;
Database=DB_675;
User ID=user_id;
Password=password;
Trusted_Connection=False" providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="
Server=whsql-v04.prod.mesa1.secureserver.net;
Database=DB_675;
User ID=user_id;
Password=password;
Trusted_Connection=False" providerName="System.Data.SqlClient" />

</connectionStrings>

NOTE: You can find your server name, database name, user ID, and password in the SQL Server section of your Hosting Manager. These connection string values map to host name, database name, user name, and password, respectively. The user name and password values are those specified during SQL database (not hosting account) creation.

Rated:NR/0 Votes
147 Views
More Articles From Databases
More Articles From Databases
Print Article
Print
Share |
Comments, Questions & Reviews

Comments is currently disabled for this article!
Related Articles and Readings
Changing Your User Name
To Change Your User Name Click Settings. Go to the Account Settings tab. Click the Edit hyperlink for your user name. ...
Activating ASP.NET 2.0 Personal Web Site User Account
ASP.NET 2.0 user accounts must be manually activated through the Hosting Manager after creation. For more information about the ASP.NET 2.0 ...
What is the absolute path for my Linux hosting account?
This is the absolute path for your Linux hosting account: /home/content/1/2/3/username/html/ Where "/1/2/3/" are the first three letters of your user ...
What are ColdFusion custom tags and how do I use them?
Custom tags are a way of encapsulating your code so that you can use it on other ColdFusion pages just ...
Setting up Your Hosting Account
Thank you for your hosting purchase. After you purchase a hosting plan, you need to log in to your Account ...
The information provided in this article is for general information and/or the comments is the sole responsibility of their respective authors and does not necessarily reflect the opinion of zeronese.net does not endorse any article and/or comments published by our web users unless otherwise noted. 

Categories