AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
Questions & Answers
Tips & Tricks
 connection to sql database when the database in other system (in asp.net 2005)
Posted by smitashree dash on  1/28/2008 1:25:24 AM Category: Asp.Net 2.0
Add to my favorites
Email to friend
it showing the error while i am connecting to other system but when i connect to the local server the the application is connected

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Post Your Reply Post New Question

 Viewer's Reply
Make sure the ConnectionString is correct
Answered By Moderator1 on 1/28/2008 7:27:22 PM
Hi,

to connect sql server 2000 either in local or in remote server is
Server=[ServerName/IP Address];database=[DatabaseName];Uid=[UserId];Pwd=[Password]

to connect in sql express 2005 use the below one

Server=.\SQLExpress;AttachDbFilename=|DataDirectory|yourdbname.mdf; Database=yourdbname;Trusted_Connection=Yes;
 
Post Your Reply If you still have problem, post it again under this reply for better response.

 
Sponsored by
The Art & Science of JavaScript - Free 100 Page Preview!
Speech Technology Magazine
The Beginner's Guide to Joomla