OLE DB provider for SQL Server, Connection Failure

Posted on 2008-11-14
Last Modified: 2012-05-05
Good morning expert,

Classic ASP written in VB6 connects to SQL Server 2000 database. We use this environ for test
but next week will be used for VIP presentation so must get it to work. When we go to a page that hits the database we get:
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed. ....
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Connection failure
/wtemsc/EnterDetail.asp, line 36
The really wierd thing about it is if we click the refresh button on the browser the page
comes up normal.
I know the ASP error message are notorious for being red herrings but they are consistent
The page EnterDetail fails at line 36 which is
vntDetails = objEmployee.RetrieveEmployeeDetails(Session("intDB"),Session ("strEmployeeNumber"),1)
The page SelectCompany fails at line 56 which is
vntList = objTimeEntry.RetrieveCompanies (Session("intDB"),Session ("lngLoginID"))
The page ViewSelectEmployee fails at line 74 which is
vntList = objTimeEntry.RetrieveCostCenterTimeCards (Session("intDB"),Session ("lngLoginID"), Session ("strPlantNumber"), Session ("EndDate"), Session ("strCompany"))

I have tried everything I can think of and can't figure what causes this. The question  is two fold
1. Is the obvious, what causes this. If there is no idea about the cause
2. Any ideas on how to troublshoot.


Allen in Dallas
Question by:9apit
    LVL 31

    Accepted Solution

    have you read it has help me many times with this problem

    Author Closing Comment

    Not much of a solution but no else answered so I guess I am stuck with it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now