Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

connestring in asp.net

Posted on 2009-04-06
9
Medium Priority
?
421 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
  • 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Make the most of your online learning experience.
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

885 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