By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,302 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,302 IT Pros & Developers. It's quick & easy.

SQL Server and ASP.net timeout problems

P: n/a
Jim
Group,

I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly.
Now, when I copy the project to my localhost and run the application, using
the same SQL Server, I keep on receiving a SQLException Timeout expired. Any
ideas how I can remedy this?
Nov 18 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
Can you create a simpler application locally that works?

Does any of it work? Is it a connection timeout or query timeout?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
Group,

I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly.
Now, when I copy the project to my localhost and run the application, using the same SQL Server, I keep on receiving a SQLException Timeout expired. Any ideas how I can remedy this?

Nov 18 '05 #2

P: n/a
Jim
Even if I create another application trying to pull the information from the
same SQL Server I get the timeout exception when it goes to fill the DataSet
using the DataAdapter. Now, if I go and pull the information from my local
host SQL Server that has a copy of the staging SQL Server's data everything
works OK.

"Jeff Dillon" wrote:
Can you create a simpler application locally that works?

Does any of it work? Is it a connection timeout or query timeout?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
Group,

I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly.
Now, when I copy the project to my localhost and run the application,

using
the same SQL Server, I keep on receiving a SQLException Timeout expired.

Any
ideas how I can remedy this?


Nov 18 '05 #3

P: n/a
How are you logging onto SQL Server in your app?

Can you return data via Query Analyzer ok using the same login?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...
Even if I create another application trying to pull the information from the same SQL Server I get the timeout exception when it goes to fill the DataSet using the DataAdapter. Now, if I go and pull the information from my local host SQL Server that has a copy of the staging SQL Server's data everything works OK.

"Jeff Dillon" wrote:
Can you create a simpler application locally that works?

Does any of it work? Is it a connection timeout or query timeout?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
Group,

I have a Web application sitting on a staging server that is using SQL
Server 2000 as its data store, and I can run the application flawlessly. Now, when I copy the project to my localhost and run the application,

using
the same SQL Server, I keep on receiving a SQLException Timeout
expired. Any
ideas how I can remedy this?


Nov 18 '05 #4

P: n/a
Jim
I am logging in using SQL Server authentication, and I can retrieve
information using SQL Query Analyzer.

"Jeff Dillon" wrote:
How are you logging onto SQL Server in your app?

Can you return data via Query Analyzer ok using the same login?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...
Even if I create another application trying to pull the information from

the
same SQL Server I get the timeout exception when it goes to fill the

DataSet
using the DataAdapter. Now, if I go and pull the information from my

local
host SQL Server that has a copy of the staging SQL Server's data

everything
works OK.

"Jeff Dillon" wrote:
Can you create a simpler application locally that works?

Does any of it work? Is it a connection timeout or query timeout?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
> Group,
>
> I have a Web application sitting on a staging server that is using SQL
> Server 2000 as its data store, and I can run the application flawlessly. > Now, when I copy the project to my localhost and run the application,
using
> the same SQL Server, I keep on receiving a SQLException Timeout expired. Any
> ideas how I can remedy this?


Nov 18 '05 #5

P: n/a
Did you try a "select * from authors" in the Pubs database?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...
I am logging in using SQL Server authentication, and I can retrieve
information using SQL Query Analyzer.

"Jeff Dillon" wrote:
How are you logging onto SQL Server in your app?

Can you return data via Query Analyzer ok using the same login?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...
Even if I create another application trying to pull the information from
the
same SQL Server I get the timeout exception when it goes to fill the

DataSet
using the DataAdapter. Now, if I go and pull the information from my

local
host SQL Server that has a copy of the staging SQL Server's data

everything
works OK.

"Jeff Dillon" wrote:

> Can you create a simpler application locally that works?
>
> Does any of it work? Is it a connection timeout or query timeout?
>
> Jeff
> "Jim" <Ji*@discussions.microsoft.com> wrote in message
> news:B1**********************************@microsof t.com...
> > Group,
> >
> > I have a Web application sitting on a staging server that is using

SQL > > Server 2000 as its data store, and I can run the application

flawlessly.
> > Now, when I copy the project to my localhost and run the application, > using
> > the same SQL Server, I keep on receiving a SQLException Timeout

expired.
> Any
> > ideas how I can remedy this?
>
>
>


Nov 18 '05 #6

P: n/a
Jim
Yes I did, and I was able to retrieve all authors.
"Jeff Dillon" wrote:
Did you try a "select * from authors" in the Pubs database?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...
I am logging in using SQL Server authentication, and I can retrieve
information using SQL Query Analyzer.

"Jeff Dillon" wrote:
How are you logging onto SQL Server in your app?

Can you return data via Query Analyzer ok using the same login?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:A3**********************************@microsof t.com...
> Even if I create another application trying to pull the information from the
> same SQL Server I get the timeout exception when it goes to fill the
DataSet
> using the DataAdapter. Now, if I go and pull the information from my
local
> host SQL Server that has a copy of the staging SQL Server's data
everything
> works OK.
>
> "Jeff Dillon" wrote:
>
> > Can you create a simpler application locally that works?
> >
> > Does any of it work? Is it a connection timeout or query timeout?
> >
> > Jeff
> > "Jim" <Ji*@discussions.microsoft.com> wrote in message
> > news:B1**********************************@microsof t.com...
> > > Group,
> > >
> > > I have a Web application sitting on a staging server that is using SQL > > > Server 2000 as its data store, and I can run the application
flawlessly.
> > > Now, when I copy the project to my localhost and run the application, > > using
> > > the same SQL Server, I keep on receiving a SQLException Timeout
expired.
> > Any
> > > ideas how I can remedy this?
> >
> >
> >


Nov 18 '05 #7

P: n/a
Any chance there is some sort of firewall or proxy between your local
machine and the staging server?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 4 Nov 2004 16:53:02 -0800, Jim <Ji*@discussions.microsoft.com>
wrote:
Yes I did, and I was able to retrieve all authors.


Nov 18 '05 #8

P: n/a
Jim
I downloaded and installed SP2 a couple of days ago. Anyway, I opened up
port 1433 of the firewall, but I'm still running into the same problem.

"Scott Allen" wrote:
Any chance there is some sort of firewall or proxy between your local
machine and the staging server?

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Thu, 4 Nov 2004 16:53:02 -0800, Jim <Ji*@discussions.microsoft.com>
wrote:
Yes I did, and I was able to retrieve all authors.


Nov 18 '05 #9

P: n/a
So, um..what's different then? Did you do some troubleshooting at this
point after you realized that Pubs works?

What could be different? Permissions for one thing. Also, run SQL Profiler
on the SQL box to verify what SQL is being passed.

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:44**********************************@microsof t.com...
Yes I did, and I was able to retrieve all authors.
"Jeff Dillon" wrote:
Did you try a "select * from authors" in the Pubs database?

Jeff
"Jim" <Ji*@discussions.microsoft.com> wrote in message
news:13**********************************@microsof t.com...
I am logging in using SQL Server authentication, and I can retrieve
information using SQL Query Analyzer.

"Jeff Dillon" wrote:

> How are you logging onto SQL Server in your app?
>
> Can you return data via Query Analyzer ok using the same login?
>
> Jeff
> "Jim" <Ji*@discussions.microsoft.com> wrote in message
> news:A3**********************************@microsof t.com...
> > Even if I create another application trying to pull the information
from
> the
> > same SQL Server I get the timeout exception when it goes to fill
the > DataSet
> > using the DataAdapter. Now, if I go and pull the information from my > local
> > host SQL Server that has a copy of the staging SQL Server's data
> everything
> > works OK.
> >
> > "Jeff Dillon" wrote:
> >
> > > Can you create a simpler application locally that works?
> > >
> > > Does any of it work? Is it a connection timeout or query timeout? > > >
> > > Jeff
> > > "Jim" <Ji*@discussions.microsoft.com> wrote in message
> > > news:B1**********************************@microsof t.com...
> > > > Group,
> > > >
> > > > I have a Web application sitting on a staging server that is using SQL
> > > > Server 2000 as its data store, and I can run the application
> flawlessly.
> > > > Now, when I copy the project to my localhost and run the

application,
> > > using
> > > > the same SQL Server, I keep on receiving a SQLException

Timeout > expired.
> > > Any
> > > > ideas how I can remedy this?
> > >
> > >
> > >
>
>
>


Nov 18 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.