how to connect to database of hosted server

Question

1.00/5 (1 vote)

See more:

Dear frens,

I have this serious issue...

I need to host the site which is in asp.net c#. I somehow did uploaded the asp.net code files to the server but the database is not connected. When i ask the server providers, they informed that i can do that using localhost and they have provided me with username and password and the database name but how can i connect to that server where the database exist.

I seriously need some quick help !!!please reply asap

Posted 4-Aug-13 23:11pm

karkiB123

Add a Solution

Comments

Joezer BH 5-Aug-13 5:29am

Sorry mate, try to be more calm and provide the details explicitly.
i.e. try to explain in more details about the server, the SQL Server, it's location etc

Hemant Singh Rautela 5-Aug-13 5:38am

So simple use below connection string with accurate parameter...
<add name="Connect" connectionstring="Data Source=serverip;Initial Catalog=databasename;user id=user; pwd=password" providername="System.Data.SqlClient"> </add>

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-08-04T23:39:00

Use the connection details they provides to form your connection string. It'll be somethign along the lines of:

@"Data Source=localhost\SQLEXPRESS;Initial Catalog=MyDB;User Id=xxxx;Password=xxxx;"

Or

@"Data Source=localhost\SQLSERVER;Initial Catalog=MyDB;User Id=xxxx;Password=xxxx;"

Put it in your web.config file, so you don't have you recompile each time if it's wrong...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-08-04T23:50:00

Solution 2

You need to change your ConnectionString in Web config if you have any.

Then from code connect to the Database using the ConnectionString.

To know how to connect to Database - [MSDN] Connecting to Databases in ASP.NET[^].
To know more about ConnectionStrings - www.connectionstrings.com[^].

You will also find videos on Google on the same topic.

Posted 4-Aug-13 23:50pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

karkiB123 5-Aug-13 12:09pm

Do I need to have the ip address of the database server where i am hosting my website and database??? I have been provided the databasename, username and password but will it be sufficient to know where my database is located ????