« Previous Next »

• 04-03-2009, 10:08 PM

  In reply to

  steve schofield Joined on 06-10-2002, 4:54 PM MI Posts 3,966	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Verify you are logged in as an admin. Also, try turning off UAC or run a elevated command prompt then run regedit.  Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget

• 04-04-2009, 4:27 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Thank you for the suggestion, but that still does not allow a change to the registry. Your assistance is appreciated Through Google I found the MSDN Forums where there are questions from other people about the same problem, but no one seems to be able to provide a solution as to how to edit the Vista registry without being given the access denied message Surely it should not be this difficult and time consuming to solve what should be a simple problem

• 04-04-2009, 5:07 AM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,423

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact You may notice that only TrustedInstaller has Full Control on such keys. You must first manually grant Administrators Full Control permissions and then test if you can make further changes. Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 04-04-2009, 5:47 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Thank you for the infomration. Where do I manually grant Administrators Full Control permissions? In the Registry with Regedit if I try to change any of the accounts full control, access is denied The only suggestion I have seen that I have not been sure that I should do is in a MSDN forum right-click the key, click security, click advanced, click owner, click other users or groups, click advanced, click find now, select your account, click ok, click ok, select your account, click ok, now you can set permissions as you wish. do this for every key you want. http://social.msdn.microsoft.com/forums/en-US/windowssecurity/thread/dc4b243f-c84a-43ec-8b75-fe2cef2656ac MSDN > Forums Home > Software Development for Windows Client > Security for Applications in Microsoft Windows >

• 04-05-2009, 4:57 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Thank you for the reply - please advise where you want me to manually grant Administrators Full Control permissions - if this is in the Regedit on the CLSID key, trying to do this creates an error message that access is denied

• 04-05-2009, 8:28 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact I found how to change the control of the key in Regedit and then followed the instructions in the PRB: ASP Error 8002801d "Library Not Registered" Help and Support Page, but having done as they instruct and added everyone to CLSID key and that the Everyone entry has Read permission But I still have Error 8002801d after following those steps as soon as the ASP reaches the code line Server.CreateObject ("ADODB.Command") As before if I use CreateObject ("ADODB.Command")  the page loads without an error. Still need to find why Server.CreateObject ("ADODB.Command")  causes an error From searching through many pages, could the problem lie with MDAC or InprocServer32 or LocalServer32 Permission settings? When I look at the permissions for MDAC they are set to Read only other than for TrustedInstaller which also has Full Control

• 04-07-2009, 7:41 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Hello I have compared and set the CLSID permissions on my VISTA computer to be the same as those on my XP computer where my LocalHost server works and there is no error message for ASP pages with dynamic content  In the article PRB: ASP Error 8002801d "Library Not Registered" it goes on to discuss the TypeLib entries There is no entry in the TypeLib for ADODB.Command\CLSID   00000507-0000-0010-8000-00AA006D2EA4 but using the entry InprocServer32  there is a value b03f5f7f11d50a3a which I can find in the TypeLib section. If I compare the permissions for this on my Vista and XP computers there is a difference There are no User Names or Groups with permissions set on my VISTA computer, while on my XP computer there are four Group or User Names With VISTA can I add the same or equivalent Group or UserNames as on my XP computer? In the TypeLib the entry where b03f5f7f11d50a3a  is found is  HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0 When you expand the TypeLib entry on the XP computer the sub entries are 2.0, 0, win32, FLAGS, and HELPDIR, while on the VISTA computer there is only one sub entry 2.0 Your advice and assistance would be appreciated

• 04-08-2009, 5:28 AM

  In reply to

  steve schofield Joined on 06-10-2002, 4:54 PM MI Posts 3,966

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact This might be from a different angle, but do you have a secondary Vista or W2k8 box that gets this error?  This problem could be related to this particular box.   Without access to the machine, I'm not sure what else advice we can offer.   We'd really like to help, but it sounds like you've done your best to troubleshoot using the normal tools, KB articles.   I'm not sure what else to offer w/o just reloading the system. Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget

• 04-08-2009, 7:45 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Thank you for the reply  The Vista computer is a new computer and has very little loaded by way of extra programs unlike my XP computer which has everything including the kitchen sink loaded in comparison The one anomaly I have found when comparing the XP and Vista registry entries is HKEY_CLASSES_ROOT\CLSID\{00000507-0000-0010-8000-00AA006D2EA4} where the main entry has an extar User name or Group which is RESTRICTED as well as the other User Names and Groups There is no entry in the TypeLib for ADODB.Command\CLSID   00000507-0000-0010-8000-00AA006D2EA4 but using the entry InprocServer32  there is a value b03f5f7f11d50a3a which I can find in the TypeLib section. If I compare the permissions for this on my Vista and XP computers there is a difference There are no User Names or Groups with permissions set on my VISTA computer, while on my XP computer there are four Group or User Names With VISTA can I add the same or equivalent Group or UserNames as on my XP computer? In the TypeLib the entry where b03f5f7f11d50a3a  is found is  HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0 When you expand the TypeLib entry on the XP computer the sub entries are 2.0, 0, win32, FLAGS, and HELPDIR, while on the VISTA computer there is only one sub entry 2.0 Your advice and assistance would be appreciated I used the Process Monitor filters to show W3wp.exe with these results Time of Day Process Name PID Operation Path Result Detail 23:18.4 w3wp.exe 3084 CreateFile C:\inetpub\wwwroot\VinylSignsDirect\html\products.asp\web.config PATH NOT FOUND Desired Access: Generic Read, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: Read, Write, AllocationSize: n/a 23:18.4 w3wp.exe 3084 RegOpenKey HKU\S-1-5-17 NAME NOT FOUND Desired Access: Maximum Allowed 23:18.4 w3wp.exe 3084 RegOpenKey HKU\S-1-5-17 NAME NOT FOUND Desired Access: Maximum Allowed 23:18.4 w3wp.exe 3084 RegOpenKey HKCR\TypeLib\{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 ACCESS DENIED Desired Access: Maximum Allowed 23:18.4 w3wp.exe 3084 RegOpenKey HKCR\TypeLib\{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 ACCESS DENIED Desired Access: Maximum Allowed 23:18.4 w3wp.exe 3084 QueryDirectory C:\inetpub\logs\FailedReqLogFiles\W3SVC1 NO MORE FILES 23:38.0 w3wp.exe 3084 QueryDirectory C:\inetpub\temp\IIS Temporary Compressed Files\DefaultAppPool NO MORE FILES 25:56.5 w3wp.exe 3084 CreateFile C:\inetpub\wwwroot\VinylSignsDirect\html\products.asp\web.config PATH NOT FOUND Desired Access: Generic Read, Disposition: Open, Options: Synchronous IO Non-Alert, Non-Directory File, Attributes: N, ShareMode: Read, Write, AllocationSize: n/a 25:56.5 w3wp.exe 3084 RegOpenKey HKU\S-1-5-17 NAME NOT FOUND Desired Access: Maximum Allowed 25:56.5 w3wp.exe 3084 RegOpenKey HKU\S-1-5-17 NAME NOT FOUND Desired Access: Maximum Allowed 25:56.5 w3wp.exe 3084 RegOpenKey HKCR\TypeLib\{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 ACCESS DENIED Desired Access: Maximum Allowed 25:56.5 w3wp.exe 3084 RegOpenKey HKCR\TypeLib\{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 ACCESS DENIED Desired Access: Maximum Allowed   In the Registry for D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8 there are no User names or Groups and no permissions are set - do I add User Names and Permissions in the registry?

• 04-15-2009, 2:05 AM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,423

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact This problem was resolved offline and I would like to share the resolution here. ============================= Lex Y. Li to David show details 14:53 (23 hours ago) Reply Hi,   I just installed a Vista virtual machine and turned on IIS 7. As a fresh OS, I open its registry and find only the 3.0 branch, and also I can see its permission settings. SYSTEM and Administrators group has full control, while Users group has read.   I don't know why your fresh Vista installation behaviors different, but guess the problem was caused by the differences.   Regards, Lex Li ============================= David Mills to me show details 15:19 (22 hours ago) Reply Hi Lex   I have eventually solved the problem and thank you for your effort to help   I had done as you suggested and registered asp.dll but that gave an error message   Using Process monitor I found an error message for the key HKEY_CLASSES_ROOT\TypeLib\{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 ACCESS DENIED   When I clicked on that in the Registry I was given an error message and could not view any names or permissions. By accident I right clicked and after a message I was able to set the permissions you give below. In Process Monitor after registering the ASP.DLL again, I was given another error messages ACCESS DENIED for a sub key or entry under the \{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0 entry which was \{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0\0 – giving that names and permissions then gave the same error for \{D97A6DA0-A85C-11CF-83AE-00A0C90C2BD8}\3.0\0\Win32   Registering ASP.Dll again and then ASP in IIS7 worked – a long hard struggle when you do not know what to do Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 04-15-2009, 2:30 AM

  In reply to

  qbernard Joined on 03-25-2003, 10:12 PM Malaysia Posts 3,238	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact Mm.. I wonder why and what screw up the permissions at the first place :) Cheers, Bernard Cheah

• 04-15-2009, 3:02 AM

  In reply to

  lextm Joined on 10-22-2008, 12:18 AM Shanghai, PRC Posts 1,423	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact It is hard to tell, as my VM is also a fresh one which does not have any problem. Lex Li Support Engineer at Microsoft --------------------------- This posting is provided "AS IS" with no warranties, and confers no rights.

• 04-15-2009, 3:53 AM

  In reply to

  davidmills02 Joined on 03-26-2009, 2:35 PM Posts 27

  Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact I think the answer is probably Visual Baisc 6 caused the problem. When I wanted to install VB6 I was given a warning that some of Visula Studio 6 had known problems on Vista. I stopped the install and went to the Visual Basic pages on Microsoft where they said that VB6 could be used on Vista so I installed it. VB6 is the only non Vista program installed, all the other programs I have are said to be Vista compatable VB6 does work but there is no Server.CreateObject code in Visual Basic, and it was only Server.CreateObject code on ASP pages that caused a problem. Removing Server and using CreateObject in ASP pages did allow dynamic content to work.

• 06-06-2009, 11:56 AM

  In reply to

  rashidbilgrami Joined on 06-06-2009, 3:53 PM Posts 1	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact check my blog i have provide the solution here http://bestvisualization.blogspot.com/2009/04/oledb-jet-40-driver-in-vista-64bit-he.html

• 06-09-2009, 9:28 AM

  In reply to

  qbernard Joined on 03-25-2003, 10:12 PM Malaysia Posts 3,238	Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP Reply Contact eerr. what does Jet db got to do with this? Microsoft updated long ago that there is no x64 Jet driver. - http://msdn.microsoft.com/en-us/library/ms810810.aspx   Cheers, Bernard Cheah