IIS7 - Classic ASP

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

qbernard — Tue, 09 Jun 2009 13:28:55 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

rashidbilgrami — Sat, 06 Jun 2009 15:56:37 GMT

check my blog i have provide the solution here

http://bestvisualization.blogspot.com/2009/04/oledb-jet-40-driver-in-vista-64bit-he.html

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Wed, 15 Apr 2009 07:53:48 GMT

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.

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

lextm — Wed, 15 Apr 2009 07:02:15 GMT

It is hard to tell, as my VM is also a fresh one which does not have any problem.

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

qbernard — Wed, 15 Apr 2009 06:30:27 GMT

Mm.. I wonder why and what screw up the permissions at the first place :)

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

lextm — Wed, 15 Apr 2009 06:05:31 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Wed, 08 Apr 2009 11:45:56 GMT

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?

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

steve schofield — Wed, 08 Apr 2009 09:28:37 GMT

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.

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Tue, 07 Apr 2009 11:41:30 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Sun, 05 Apr 2009 12:28:50 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Sun, 05 Apr 2009 08:57:07 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Sat, 04 Apr 2009 09:47:47 GMT

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 >

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

lextm — Sat, 04 Apr 2009 09:07:23 GMT

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.

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

davidmills02 — Sat, 04 Apr 2009 08:27:03 GMT

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

Re: Why does Server.CreateObject("ADODB.Recordset") fail on Vista / IIS7 / ASP

steve schofield — Sat, 04 Apr 2009 02:08:07 GMT

Verify you are logged in as an admin.

Also, try turning off UAC or run a elevated command prompt then run regedit.