ASP to SQL Server - Intermittent connection problems - Page 2

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

Subscribe Reply

5280

Bob Barrows [MVP]

critical wrote:

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

It seems the posts to which you are replying are no longer available so I
have no idea what problem you are having. Could it be this?
http://support.microsoft.com/default...b;en-us;328476
--
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"

Apr 13 '07 #11

Similar topics

2440

intermittent performance problems while insertig records

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

Microsoft SQL Server

3054

Connection Problems to SQL 6.5

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...

Microsoft SQL Server

5253

DB2 Federated connection problems

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.

DB2 Database

17024

Oracle connection problems; Odbc call failed

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...

Microsoft Access / VBA

1247

Connection problems

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...

C# / C Sharp

1247

asp.net to sql server 2000 access problems

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...

ASP.NET

1120

SQL Server Express connection problems

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?

.NET Framework

3219

smtp error: unable to connect to remote server...No connection could be made because the target machine actively refused it

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>

ASP.NET

2644

how to create a client/server socket connection (ask for user name and secretword)

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 #...

Perl

8685

What is ONU?

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...

General

9171

Problem With Comparison Operator <=> in G++

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...

C / C++

6532

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

5869

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4373

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4625

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3053

transfer the data from one system to another through ip address

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

C# / C Sharp

2342

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2008

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General