Todd Jaspers

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");
> >

Peter Bromberg [C# MVP]

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");
>