Google Answers Logo
View Question
 
Q: ASP/ADO Connection Issues in Windows 2000 Professional ( No Answer,   2 Comments )
Question  
Subject: ASP/ADO Connection Issues in Windows 2000 Professional
Category: Computers > Programming
Asked by: aolifson-ga
List Price: $10.00
Posted: 31 Aug 2004 17:15 PDT
Expires: 02 Sep 2004 13:36 PDT
Question ID: 395353
When I attempt to connect my SQL database using the line:
 "Set objConn = Server.CreateObject ("ADODB.Connection")"
I get the error:
"Error Type:
Server object, ASP 0177 (0x8007007F)
8007007f"

This code used to work fine. I have dual-boot machine which also runs
Windows XP and the only thing I can think that's changed from when
this code used to work and now is that I downloaded the lates XP
Service Pack (SP 2).

Steps already taken:

1)I tried following the instructions in the Microsoft Knowledge Base
for a similar error (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q175/8/04.ASP&NoWebContent=1)
which involved setting permissions for the IUSER_machinename user on
specified folders.  However, I do not seem to have the
"System32\Inetsrv\Asp" folder specified in the solution.

2) Also per the above knowledge base article, I tried adding
IUSER_[machinename] to the admininistrator group to see if the issue
was a permission problem, but that didn't seem to fix the problem
either.

3)I unistnalled and re-installed the Window Components: IIS,
Networking Services and Other Network File and Print Services

Could the XP SP2 have screwed up my permissions?  

Please help.
Answer  
There is no answer at this time.

Comments  
Subject: Re: ASP/ADO Connection Issues in Windows 2000 Professional
From: luxx-ga on 31 Aug 2004 17:29 PDT
 
No, the SP2 is not the culprit. You may want to have a look at your
RAM (believe it or not). Ive seen this problem before, and your
creating a stack dump with your =Server.CreateObject. You need to set
permissions because when you put SP2 in, it changed your permissions.
Try that.
~VH~
Subject: Re: ASP/ADO Connection Issues in Windows 2000 Professional
From: aolifson-ga on 31 Aug 2004 23:44 PDT
 
Thanks, but I'm a bit confused.  You say SP2 isn't the culprit, but
that SP2 did change my permissions.  So do you think setting my
permissions could fix the RAM issue, as well?  Or are those seprate
possibilities?

Thanks for taking the time to comment.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy