473,700 Members | 2,648 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ASP to SQL Server - Intermittent connection problems

Dan
We have a fairly large set of ASP.NET applications running on Windows 2003 SP1 server. The entire suite of software was originally written in ASP and ran on a Win 2k server. For about the last year, we have been working toward converting everything to .NET and we are close to have it all done. In the mean time, we still have a few portions of the software running in classic ASP.

Here is the problem. The ASP pages have been pretty reliable up until about two months ago. We upgraded our production servers from Win 2k to Win 2k3 (now SP1) and started getting intermittent errors when loading an ASP page.

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/2003/PageName.asp, line #.

This generally happens on pages with larger sets of data and AFTER some of the data has loaded. All data on the page is retreived using te same connection so I do know that the connection string is ok. This happens at different points in the page and only happens once in a while. It looks like it may be dependant on the load on the servers.

I have googled this problem and found other postings concerning this same type of behaviour, but no solutions have been posted. If anyone has an idea or has seen this same problem and seen it fixed, PLEASE let me know what you have found.

Thanks in advance!
Dan

From http://developmentnow.com/g/62_0_0_0...sp-general.htm

Posted via DevelopmentNow. com Groups
http://www.developmentnow.com
Jul 22 '05 #1
10 5281
Dan wrote:
We have a fairly large set of ASP.NET applications running on Windows
2003 SP1 server. The entire suite of software was originally written
in ASP and ran on a Win 2k server. For about the last year, we have
been working toward converting everything to .NET and we are close to
have it all done. In the mean time, we still have a few portions of
the software running in classic ASP.

Here is the problem. The ASP pages have been pretty reliable up
until about two months ago. We upgraded our production servers from
Win 2k to Win 2k3 (now SP1) and started getting intermittent errors
when loading an ASP page.

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. /2003/PageName.asp, line #.


Could it be this?
http://support.microsoft.com/?kbid=328476

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 22 '05 #2
Dan


Thanks for the fast reply. I don't believe that this is the problem
though because we do have connection pooling enabled.

*** Sent via Developersdex http://www.developersdex.com ***
Jul 22 '05 #3
You can try to augment the timeout time for the connection. By default, it
is 15 seconds but if the server is really busy...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Dan" <dn***********@ yahoo.com> wrote in message
news:OV******** *****@TK2MSFTNG P12.phx.gbl...


Thanks for the fast reply. I don't believe that this is the problem
though because we do have connection pooling enabled.

*** Sent via Developersdex http://www.developersdex.com ***

Jul 22 '05 #4
Dan wrote:
We upgraded our production servers from Win 2k to Win 2k3
(now SP1) and started getting intermittent errors when
loading an ASP page.

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB]...

^^^^^^^^

Are you explicitly requiring TCP/IP? Make sure this is in your connection
string (or use the client network utility to configure TCP/IP only):

Network Library=DBMSSOC N;

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.
Jul 22 '05 #5
Dan
I have tried the suggestions from all of you here and hopefully this
will clear things up. There is another discussion on this same subject
at

http://www.codecomments.com/showthre...04be376f8527ff
29ae1&threadid= 289607&perpage= 40&pagenumber= 1

Thanks for all the help and please let me know if anyone finds anything
else.
D

*** Sent via Developersdex http://www.developersdex.com ***
Jul 22 '05 #6
Dan wrote:
Thanks for the fast reply. I don't believe that this is the problem
though because we do have connection pooling enabled.


You DO realize that poor coding practices can disable connection pooling ...
here is one way to inadvertantly disable pooling:
http://support.microsoft.com/?kbid=271128

Other ways include using connection strings instead of explicit connection
objects when opening recordsets or using Command objects. More info here:
http://support.microsoft.com/default...b;en-us;191572

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #7
Dan
Thanks for the reply Bob. I was aware of some of the information that
you provided but not all of it. Much of the code that is still in ASP
was written several years ago and I have learned much since then ;) so
as we convert over to ASP.NET, our performance should increase.

The part of this that I do not understand is, we NEVER had this problem
until we upgraded our servers to 2k3. If the problem is related to
pooling and running out of available connections, why did we not run
into this on the other server. And for that matter, why not when our
entire code base was ASP?

I have seen many reports of people running into this same problem and it
always goes back to "It worked before we upgraded the server".

Thanks again to everyone...
Dan

*** Sent via Developersdex http://www.developersdex.com ***
Jul 22 '05 #8
Dan wrote:
Thanks for the reply Bob. I was aware of some of the information that
you provided but not all of it. Much of the code that is still in ASP
was written several years ago and I have learned much since then ;) so
as we convert over to ASP.NET, our performance should increase.

The part of this that I do not understand is, we NEVER had this
problem until we upgraded our servers to 2k3. If the problem is
related to pooling and running out of available connections, why did
we not run into this on the other server. And for that matter, why
not when our entire code base was ASP?


All I can do is speculate. Sorry.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Jul 22 '05 #9

What was the resolution here?
I'm having the very same problem and have, it seems, tried all the
available information.

thanks!

--
critical
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Apr 13 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2440
by: DK | last post by:
I have a SP that I use to insert records in a table. This SP is called hundreds of times per minute. Most inserts complete very fast. And the profiler data is as follows: CPU: 0 Reads: 10 Writes: 1 Duration: varies from 1 to 30
1
3054
by: Mansoor Azam | last post by:
We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then the some XP client machines (192.168.0.1 and 192.168.0.3) started giving problems. All TCP/IP connections go thru the WIN 2000 multihomed machine (192.168.0.2 where its connecting fine). The error when creating ODBC DSN is Connection failed: SQLState: '01000' SQL Server Error: 10054...
2
5253
by: Tim V. | last post by:
Here's the layout: AIX v5.2, DB2 v8 fp8 running in 64bit I've got a Multi-partitioned db running on lpar4 and I want to connect it to 2 instances running on lpar13. We'll deal with just 1 instance on lpar13 for now. lpar4 -> db name dwdb lpar13 -> db name IBMEDGE On lpar13, I have a userid that has DBADMIN authority.
9
17026
by: mcbill20 | last post by:
Hello all. I just installed Oracle 10g developer tools on a machine running XP Pro and Office XP. Before this I had just the Oracle 9 client installed. I the previous configuration, I was able to access any of the Oracle tables on another machine but now I am having problems. Unfortunately, I don't remember the correct syntax for the ODBC connect string and I am hoping that is my whole problem. I am trying to connect to an Oracle 9...
4
1247
by: Roy Gourgi | last post by:
Hi, I just install MSDE 2000 on my computer and I am trying to make a connection with the server but it does not seem to be working. What am I doing wrong in the code below? When I open my Server Explorer I see Data Connections and Servers. Do I have to make a physical connection of some sort first? In the Servers section, I see that it automatically created a SQL server by the name REBORN where I created a database called royDB. Am I...
6
1247
by: Andrew | last post by:
Hell-hohoho to all... Just begun working with asp.net linking to sqlServer 2000, had some problems with the (null) user, but previous posts have got me past that by storing an identity in the web.config file. However, I want to dyamically set the login info, from a prompted box. I'm aware of the security issues here, but I'll ignore that for now. The kb article I saw set the following info in the connection string of the sql...
3
1120
by: EgoSum | last post by:
I can't connect app to SQLEXPRESS via the local network. It works on same PC. In SQL Server Configuration Manager > SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS > TCP/IP and Named Pipes - set to Enabled. In Server Properties > Security > SQL Server and Windows Authentication mode is set. Firewall and antivirus are stopped during tests. What else can be cause of this trouble?
0
3220
by: Homer | last post by:
Hi, I got "InnerException: Unable to connect to remote server"..."No connection could be made because the target machine actively refused it" when I attempted to send an email through my Intranet app that is written in asp.net 2.0. The smtp server is a local server and it uses Port 25. The Authentication is set to Anonymous Access. Here's my code: <system.net>
0
2645
by: ryaneoghan | last post by:
hi, I was just wondering if anyone could help, i am trying to create a client and server socket connection in perl, i want to ask for name and then do a check on the name and ask for a secret word if it does not match, i have this much done but dont know where to go from here and cant find anything to help on net, if you could help using the code i have done i would be grateful, thanks! here is the 2 files #!/usr/bin/perl -w #...
0
8725
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9214
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8970
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7807
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6560
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5902
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3088
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2392
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2027
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.