RE: Unable to connect to SQL remotely through SqlConnection???
- From: Todd Jaspers <ToddJaspers@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Aug 2007 08:36:04 -0700
Thanks Peter, I appreciate this. I'll try this now.
"Peter Bromberg [C# MVP]" wrote:
Todd, "No error" is kind of a blanket statment. Have you tried something like.
this?
SqlConnection sqlConn2 = null;
try
{
sqlConn2 = new SqlConnection("Data Source=database_name;
connection timeout=30");
}
catch(SqlException sqlex)
{
System.Diagnostics.Debug.WriteLine(ex.Message +);
}
finally
{
sqlConn2.Close();
}
I bet you will see something in the output window in debug mode. Get in the
habit of wiring up your code with exception handling; it will save you a lot
of time.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"Todd Jaspers" wrote:
Hey guys,
I've written a web application that I'm simply trying to use to
access a database. When I run the application locally (or as an NT Service)
it can easily access the remote SQL database. However, when I host the item
as a web application, it can ONLY access local SQL databases on that server,
and NOT remote SQL databases (even if it's on our network). Like I said, I
can access those same databases when I run the program in localhost, but NOT
when it's hosted.
What could the problem possibly be? I don't get any errors, it just doesn't
pull up any data.
This are the connection strings that I've tried, neither of which work. I've
created a local ODBC connection to the database, and the ODBC connection has
no problem connecting to the server with the SQL database on it, but it just
doesn't work when I'm accessing it remotely. I don't get any errors, there
just isn't any data.
For obvious reasons, I've changed the info below.
Any help you guys can give me, I'd really appreciate it!!!
THanks!!!
// SqlConnection sqlConn2 = new SqlConnection("user id=XXXXXX" +
// "password=XXXXXX;server=SERVERNAME;" +
// "Trusted_Connection=yes;" +
// "database=database_name; " +
// "connection timeout=30");
SqlConnection sqlConn2 = new SqlConnection("Data Source=database_name;
connection timeout=30");
- References:
- RE: Unable to connect to SQL remotely through SqlConnection???
- From: Peter Bromberg [C# MVP]
- RE: Unable to connect to SQL remotely through SqlConnection???
- Prev by Date: Re: Passing Items into a sub
- Next by Date: Re: Books for beginners
- Previous by thread: RE: Unable to connect to SQL remotely through SqlConnection???
- Next by thread: How to create a network share?
- Index(es):
Relevant Pages
|
