Solved

connestring in asp.net

Posted on 2009-04-06
9
416 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
Don't miss ATEN at NAB Show April 24-27!

Visit ATEN at NAB Show to learn how our "Seamlessly Entertaining" solutions deliver fast, precise video streaming without delays for the broadcasting and media environment. ATEN will showcase its 16x16 Modular Matrix Switch (VM1600) and KVM Over IP Solution (KE6900 series).

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

713 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