[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

OLE DB provider for SQL Server, Connection Failure

Posted on 2008-11-14
2
Medium Priority
?
905 Views
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.

Thanks

Allen in Dallas
0
Comment
Question by:Allen Pitts
2 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 1500 total points
ID: 22960443
have you read http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html it has help me many times with this problem
0
 

Author Closing Comment

by:Allen Pitts
ID: 31516798
Not much of a solution but no else answered so I guess I am stuck with it.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

834 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