Solved

connestring in asp.net

Posted on 2009-04-06
9
418 Views
Last Modified: 2013-11-30
i just get web space on host
i want to know which connestring i use to get data base in asp.net
0
Comment
Question by:chandresh43
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 27

Expert Comment

by:nmarun
ID: 24078957
That depends on what database you want to use. Have a look at: http://www.connectionstrings.com.
0
 
LVL 5

Author Comment

by:chandresh43
ID: 24079230

but witch string i use for host site database
0
 
LVL 27

Expert Comment

by:nmarun
ID: 24079243
What database application are you using? Is it SQL Server, Oracle, MS Access, MySQL.. etc?
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 5

Author Comment

by:chandresh43
ID: 24079264
sql server 2008
host ip is
https://74.86.34.98:8443/
database is shiv

 
0
 
LVL 27

Expert Comment

by:nmarun
ID: 24079558
Then your connection string should look something like:

Data Source=74.86.34.98,8443;Network Library=DBMSSOCN;Initial Catalog=shiv;User ID=myUsername;Password=myPassword;

Change the User ID and Password values.
0
 
LVL 5

Author Comment

by:chandresh43
ID: 24083446
it give me error
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
0
 
LVL 27

Accepted Solution

by:
nmarun earned 500 total points
ID: 24083954
Try this:

<add key="DBConnection" value="Data Source=74.86.34.98,8443;Network Library=DBMSSOCN;Initial Catalog=shiv;User ID=myUsername;Password=myPassword;Connect Timeout=200;"/>

This sets the timeout to 200 seconds.
0
 
LVL 5

Author Comment

by:chandresh43
ID: 24084733
where i use this in web.config
or else
0
 
LVL 27

Expert Comment

by:nmarun
ID: 24087397
Yes, you add this to the web.config file. See the article below:
http://www.odetocode.com/Articles/345.aspx
0

Featured Post

ATEN's HDBaseT Presentation at InfoComm 2017

Hear ATEN Product Manager YT Liang review HDBaseT technology, highlighting ATEN’s latest solutions as they relate to real-world applications during her presentation at the HDBaseT booth at InfoComm 2017.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a collection of issues that people face from time to time and possible solutions to those issues. I hope you enjoy reading it.
This article explains the fundamentals of industrial networking which ultimately is the backbone network which is providing communications for process devices like robots and other not so interesting stuff.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Suggested Courses
Course of the Month4 days, 5 hours left to enroll

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question