ResourcePool is not supported

[David]

Hello
When I try to open a connection to a sql server database
from my aspnet app I get the following exception
message: 'ResourcePool' is not supported on the current
platform. I can connect OK using the exact same code to
the same database from a win forms app. I haven't
recently re installed the framework to try and solve
another issue,which has now been solved. As a result of
this and reading posts relating to this issue i have ran
regsvr32 for comsvcs.dll and oledb32.dll.

My O/s is Win 2000 sp3 and I am connecting to a Sql Server
2000 database also with sp3

Has any got any suggestions as to what my next move should
be.

Thanks

David

[B]

Hi Yanhong!

Do you have any other suggestions regarding this issue?

I get the same error message trying to run a project originally written on
VS.NET and FW1.0 now working on VS.NET 2003 and FW1.1.

The stack trace is as follows:

Exception Details: System.Platform NotSupportedExc eption: 'ResourcePool' is
not supported on the current platform.

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[PlatformNotSupp ortedException: 'ResourcePool' is not supported on the
current platform.]
System.Enterpri seServices.Plat form.Assert(Boo lean fSuccess, String
function) +69
System.Enterpri seServices.Plat form.Assert(Ver sion platform, String
function) +71
System.Enterpri seServices.Reso urcePool..ctor( TransactionEndD elegate cb)
+38
System.Data.Sql Client.Connecti onPool..ctor(De faultPoolContro l ctrl) +797
System.Data.Sql Client.PoolMana ger.FindOrCreat ePool(DefaultPo olControl
ctrl, IntPtr SID) +260

System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne c
tionString options, Boolean& isInTransaction ) +358
System.Data.Sql Client.SqlConne ction.Open() +384

Microsoft.Appli cationBlocks.Da ta.SqlHelperPar ameterCache.Dis coverSpParamete r
Set(SqlConnecti on connection, String spName, Boolean
includeReturnVa lueParameter) in c:\documents and settings\bjarne l. gram\my
documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 429

Microsoft.Appli cationBlocks.Da ta.SqlHelperPar ameterCache.Get SpParameterSetI n
ternal(SqlConne ction connection, String spName, Boolean
includeReturnVa lueParameter) in c:\documents and settings\bjarne l. gram\my
documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 602

Microsoft.Appli cationBlocks.Da ta.SqlHelperPar ameterCache.Get SpParameterSet( S
tring connectionStrin g, String spName, Boolean includeReturnVa lueParameter)
in c:\documents and settings\bjarne l. gram\my documents\my
projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 546

Microsoft.Appli cationBlocks.Da ta.SqlHelperPar ameterCache.Get SpParameterSet( S
tring connectionStrin g, String spName) in c:\documents and settings\bjarne
l. gram\my documents\my
projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 526
Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
connectionStrin g, String spName, Object[] parameterValues ) in c:\documents
and settings\bjarne l. gram\my documents\my
projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:9 09
....
Best regards

Bjarne L. Gram
Seniorconsultan t - MCP
Ementor Norge AS
Microsoft Gold Certified Partner
bj*********@NOS PAMementor.no

"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
news:GW******** ******@cpmsftng xa06.phx.gbl...

Hello David,

I am glad that the problem is resovled. Generally speaking, when the web applicaiton is set to used anonymous and windows authentication in IIS. Then a client will try to access it using anonymous. If it successes, then it will use anonymoust to set up the connections. If it failed(when some page denies access to anonymous user), it will try windows authentication. You could check it in IIS logs.

Thanks very much for participating the community.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
!Content-Class: urn:content-classes:message
!From: "David" <ce************ ****@nospam.com >
!Sender: "David" <ce************ ****@nospam.com >
!References: <0c************ *************** *@phx.gbl>
!Subject: ResourcePool is not supported
!Date: Wed, 6 Aug 2003 02:08:48 -0700
!Lines: 13
!Message-ID: <98************ *************** *@phx.gbl>
!MIME-Version: 1.0
!Content-Type: text/plain;
! charset="iso-8859-1"
!Content-Transfer-Encoding: 7bit
!X-Newsreader: Microsoft CDO for Windows 2000
!X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!Thread-Index: AcNb+lh3Rk5TNBs 6Qg2Fb3z+GtNeTg ==
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!Path: cpmsftngxa06.ph x.gbl
!Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1652 87 !NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!
!Morning
!
!Came in today and sorted it in 5 minutes, annoying when
!that happens. I'd recreated my web project from
!sourcesafe yesterday and when it created the projected it
!had annoymous autentication switched on in IIS. All I had
!to do was switch this off. The Project was already set to
!use Windows Authentication in the Web.config but the
!AnnoymousAuthe ntication option in IIS seemed to overide it.
!
!Everything is now hunky doory
!
!David
!

[Yan-Hong Huang[MSFT]]

Hello Bjarne,

This problem is some times caused by incorrect version of comadmin.dll on your system. You can check the following:
1) check in the registry for the existence of the key:

HKEY_CLASSES_RO OT \ CLSID \ {6EB22881-8A19-11D0-81B6-00A0C9231C29}

the InprocServer32 value should have a default which points to a dll somewhere in the windows directory (system32\com
\comadmin.dll)

2) confirm that comadmin.dll does exist in the location pointed to by the registry.

3) to make sure COM+ is working, you might want to open up the Component Services Explorer (under Administrative Tools),
and try clicking down on "My Computer" to get a list of COM+ Applications...

Hope it helps.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!From: "B@rney" <ba**********@h otmail.com>
!References: <0c************ *************** *@phx.gbl> <98************ *************** *@phx.gbl>
<GW************ **@cpmsftngxa06 .phx.gbl>
!Subject: Re: ResourcePool is not supported
!Date: Tue, 12 Aug 2003 11:45:50 +0200
!Lines: 133
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!Message-ID: <#s************ **@TK2MSFTNGP09 .phx.gbl>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!NNTP-Posting-Host: gate.ementor.no 62.148.39.70
!Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
!Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1670 19
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!
!Hi Yanhong!
!
!Do you have any other suggestions regarding this issue?
!
!I get the same error message trying to run a project originally written on
!VS.NET and FW1.0 now working on VS.NET 2003 and FW1.1.
!
!The stack trace is as follows:
!
!Exception Details: System.Platform NotSupportedExc eption: 'ResourcePool' is
!not supported on the current platform.
!
!Source Error:
!
! An unhandled exception was generated during the execution of the
!current web request. Information regarding the origin and location of the
!exception can be identified using the exception stack trace below.
!
!Stack Trace:
!
![PlatformNotSupp ortedException: 'ResourcePool' is not supported on the
!current platform.]
! System.Enterpri seServices.Plat form.Assert(Boo lean fSuccess, String
!function) +69
! System.Enterpri seServices.Plat form.Assert(Ver sion platform, String
!function) +71
! System.Enterpri seServices.Reso urcePool..ctor( TransactionEndD elegate cb)
!+38
! System.Data.Sql Client.Connecti onPool..ctor(De faultPoolContro l ctrl) +797
! System.Data.Sql Client.PoolMana ger.FindOrCreat ePool(DefaultPo olControl
!ctrl, IntPtr SID) +260
!
!System.Data.Sq lClient.SqlConn ectionPoolManag er.GetPooledCon nection(SqlConn ec
!tionString options, Boolean& isInTransaction ) +358
! System.Data.Sql Client.SqlConne ction.Open() +384
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Di scoverSpParamet er
!Set(SqlConnect ion connection, String spName, Boolean
!includeReturnV alueParameter) in c:\documents and settings\bjarne l. gram\my
!documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 429
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet In
!ternal(SqlConn ection connection, String spName, Boolean
!includeReturnV alueParameter) in c:\documents and settings\bjarne l. gram\my
!documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 602
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet (S
!tring connectionStrin g, String spName, Boolean includeReturnVa lueParameter)
!in c:\documents and settings\bjarne l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2546
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet (S
!tring connectionStrin g, String spName) in c:\documents and settings\bjarne
!l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2526
! Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
!connectionStri ng, String spName, Object[] parameterValues ) in c:\documents
!and settings\bjarne l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 909
!...
!
!
!Best regards
!
!Bjarne L. Gram
!Seniorconsulta nt - MCP
!Ementor Norge AS
!Microsoft Gold Certified Partner
!b**********@NO SPAMementor.no
!
!"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
!news:GW******* *******@cpmsftn gxa06.phx.gbl.. .
!> Hello David,
!>
!> I am glad that the problem is resovled. Generally speaking, when the web
!applicaiton is set to used anonymous and
!> windows authentication in IIS. Then a client will try to access it using
!anonymous. If it successes, then it will use anonymoust
!> to set up the connections. If it failed(when some page denies access to
!anonymous user), it will try windows authentication.
!> You could check it in IIS logs.
!>
!> Thanks very much for participating the community.
!>
!> Best regards,
!> Yanhong Huang
!> Microsoft Online Partner Support
!>
!> Get Secure! - www.microsoft.com/security
!> This posting is provided "AS IS" with no warranties, and confers no
!rights.
!>
!> --------------------
!> !Content-Class: urn:content-classes:message
!> !From: "David" <ce************ ****@nospam.com >
!> !Sender: "David" <ce************ ****@nospam.com >
!> !References: <0c************ *************** *@phx.gbl>
!> !Subject: ResourcePool is not supported
!> !Date: Wed, 6 Aug 2003 02:08:48 -0700
!> !Lines: 13
!> !Message-ID: <98************ *************** *@phx.gbl>
!> !MIME-Version: 1.0
!> !Content-Type: text/plain;
!> ! charset="iso-8859-1"
!> !Content-Transfer-Encoding: 7bit
!> !X-Newsreader: Microsoft CDO for Windows 2000
!> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!> !Thread-Index: AcNb+lh3Rk5TNBs 6Qg2Fb3z+GtNeTg ==
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !Path: cpmsftngxa06.ph x.gbl
!> !Xref: cpmsftngxa06.ph x.gbl
!microsoft.publ ic.dotnet.frame work.aspnet:165 287
!> !NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!> !
!> !Morning
!> !
!> !Came in today and sorted it in 5 minutes, annoying when
!> !that happens. I'd recreated my web project from
!> !sourcesafe yesterday and when it created the projected it
!> !had annoymous autentication switched on in IIS. All I had
!> !to do was switch this off. The Project was already set to
!> !use Windows Authentication in the Web.config but the
!> !AnnoymousAuthe ntication option in IIS seemed to overide it.
!> !
!> !Everything is now hunky doory
!> !
!> !David
!> !
!>
!>
!
!
!

[B]

Hi Yan-Huang!

Thanks for the rapid response!

I had the key, and the file, and COM+ was running, *but* ASPNET had no
rights for the key, neither had it rights for:
HKLM\SOFTWARE\M icrosoft\MSSQLS erver\Client\Su perSocketNetLib \LastConnect

I started regmon and checked for errors and foung ACCESS DENIED on both
these keys. I've now given ASPNET Full Control on comadmin.dll CLSID key and
everything works fine.

*But*, is this correct?

Should ASPNET have access rights for the MSSQLServer key as well?

I'd like to know what is good enough so I can adjust these rights back...


"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
news:q$******** ******@cpmsftng xa06.phx.gbl...

Hello Bjarne,

This problem is some times caused by incorrect version of comadmin.dll on your system. You can check the following: 1) check in the registry for the existence of the key:

HKEY_CLASSES_RO OT \ CLSID \ {6EB22881-8A19-11D0-81B6-00A0C9231C29}

the InprocServer32 value should have a default which points to a dll somewhere in the windows directory (system32\com \comadmin.dll)

2) confirm that comadmin.dll does exist in the location pointed to by the registry.
3) to make sure COM+ is working, you might want to open up the Component Services Explorer (under Administrative Tools), and try clicking down on "My Computer" to get a list of COM+ Applications...
Hope it helps.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
!From: "B@rney" <ba**********@h otmail.com>
!References: <0c************ *************** *@phx.gbl> <98************ *************** *@phx.gbl> <GW************ **@cpmsftngxa06 .phx.gbl>
!Subject: Re: ResourcePool is not supported
!Date: Tue, 12 Aug 2003 11:45:50 +0200
!Lines: 133
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!Message-ID: <#s************ **@TK2MSFTNGP09 .phx.gbl>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!NNTP-Posting-Host: gate.ementor.no 62.148.39.70
!Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
!Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1670 19 !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!
!Hi Yanhong!
!
!Do you have any other suggestions regarding this issue?
!
!I get the same error message trying to run a project originally written on !VS.NET and FW1.0 now working on VS.NET 2003 and FW1.1.
!
!The stack trace is as follows:
!
!Exception Details: System.Platform NotSupportedExc eption: 'ResourcePool' is !not supported on the current platform.
!
!Source Error:
!
! An unhandled exception was generated during the execution of the
!current web request. Information regarding the origin and location of the
!exception can be identified using the exception stack trace below.
!
!Stack Trace:
!
![PlatformNotSupp ortedException: 'ResourcePool' is not supported on the
!current platform.]
! System.Enterpri seServices.Plat form.Assert(Boo lean fSuccess, String
!function) +69
! System.Enterpri seServices.Plat form.Assert(Ver sion platform, String
!function) +71
! System.Enterpri seServices.Reso urcePool..ctor( TransactionEndD elegate cb) !+38
! System.Data.Sql Client.Connecti onPool..ctor(De faultPoolContro l ctrl) +797 ! System.Data.Sql Client.PoolMana ger.FindOrCreat ePool(DefaultPo olControl
!ctrl, IntPtr SID) +260
!
!System.Data.Sq lClient.SqlConn ectionPoolManag er.GetPooledCon nection(SqlConn e
c !tionString options, Boolean& isInTransaction ) +358
! System.Data.Sql Client.SqlConne ction.Open() +384
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Di scoverSpParamet e
r !Set(SqlConnect ion connection, String spName, Boolean
!includeReturnV alueParameter) in c:\documents and settings\bjarne l. gram\my !documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 429 !
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet I
n !ternal(SqlConn ection connection, String spName, Boolean
!includeReturnV alueParameter) in c:\documents and settings\bjarne l. gram\my !documents\my projects\rdg\mi crosoft.applica tionblocks.data \sqlhelper.cs:2 602 !
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet (
S !tring connectionStrin g, String spName, Boolean includeReturnVa lueParameter) !in c:\documents and settings\bjarne l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2546
!
!Microsoft.Appl icationBlocks.D ata.SqlHelperPa rameterCache.Ge tSpParameterSet (
S !tring connectionStrin g, String spName) in c:\documents and settings\bjarne !l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2526
! Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
!connectionStri ng, String spName, Object[] parameterValues ) in c:\documents !and settings\bjarne l. gram\my documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 909
!...
!
!
!Best regards
!
!Bjarne L. Gram
!Seniorconsulta nt - MCP
!Ementor Norge AS
!Microsoft Gold Certified Partner
!b**********@NO SPAMementor.no
!
!"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
!news:GW******* *******@cpmsftn gxa06.phx.gbl.. .
!> Hello David,
!>
!> I am glad that the problem is resovled. Generally speaking, when the web !applicaiton is set to used anonymous and
!> windows authentication in IIS. Then a client will try to access it using !anonymous. If it successes, then it will use anonymoust
!> to set up the connections. If it failed(when some page denies access to
!anonymous user), it will try windows authentication.
!> You could check it in IIS logs.
!>
!> Thanks very much for participating the community.
!>
!> Best regards,
!> Yanhong Huang
!> Microsoft Online Partner Support
!>
!> Get Secure! - www.microsoft.com/security
!> This posting is provided "AS IS" with no warranties, and confers no
!rights.
!>
!> --------------------
!> !Content-Class: urn:content-classes:message
!> !From: "David" <ce************ ****@nospam.com >
!> !Sender: "David" <ce************ ****@nospam.com >
!> !References: <0c************ *************** *@phx.gbl>
!> !Subject: ResourcePool is not supported
!> !Date: Wed, 6 Aug 2003 02:08:48 -0700
!> !Lines: 13
!> !Message-ID: <98************ *************** *@phx.gbl>
!> !MIME-Version: 1.0
!> !Content-Type: text/plain;
!> ! charset="iso-8859-1"
!> !Content-Transfer-Encoding: 7bit
!> !X-Newsreader: Microsoft CDO for Windows 2000
!> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!> !Thread-Index: AcNb+lh3Rk5TNBs 6Qg2Fb3z+GtNeTg ==
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !Path: cpmsftngxa06.ph x.gbl
!> !Xref: cpmsftngxa06.ph x.gbl
!microsoft.publ ic.dotnet.frame work.aspnet:165 287
!> !NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!> !
!> !Morning
!> !
!> !Came in today and sorted it in 5 minutes, annoying when
!> !that happens. I'd recreated my web project from
!> !sourcesafe yesterday and when it created the projected it
!> !had annoymous autentication switched on in IIS. All I had
!> !to do was switch this off. The Project was already set to
!> !use Windows Authentication in the Web.config but the
!> !AnnoymousAuthe ntication option in IIS seemed to overide it.
!> !
!> !Everything is now hunky doory
!> !
!> !David
!> !
!>
!>
!
!
!

[Yan-Hong Huang[MSFT]]

Hi,

I think you need to impersonate some account in asp.net web applcation to
access that key. Thanks.

Best regards,
Yanhong Huang
Microsoft Online Partner Support

Get Secure! ¨C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
!From: "B@rney" <ba**********@h otmail.com>
!References: <0c************ *************** *@phx.gbl>
<98************ *************** *@phx.gbl>
<GW************ **@cpmsftngxa06 .phx.gbl>
<#s************ **@TK2MSFTNGP09 .phx.gbl>
<q$************ **@cpmsftngxa06 .phx.gbl>
!Subject: Re: ResourcePool is not supported
!Date: Wed, 13 Aug 2003 18:31:14 +0200
!Lines: 234
!X-Priority: 3
!X-MSMail-Priority: Normal
!X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!Message-ID: <ON************ **@TK2MSFTNGP09 .phx.gbl>
!Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!NNTP-Posting-Host: 062016178247.cu stomer.alfanett .no 62.16.178.247
!Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
!Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.framew ork.aspnet:1675 49
!X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!
!Hi Yan-Huang!
!
!Thanks for the rapid response!
!
!I had the key, and the file, and COM+ was running, *but* ASPNET had no
!rights for the key, neither had it rights for:
!HKLM\SOFTWARE\ Microsoft\MSSQL Server\Client\S uperSocketNetLi b\LastConnect
!
!I started regmon and checked for errors and foung ACCESS DENIED on both
!these keys. I've now given ASPNET Full Control on comadmin.dll CLSID key
and
!everything works fine.
!
!*But*, is this correct?
!
!Should ASPNET have access rights for the MSSQLServer key as well?
!
!I'd like to know what is good enough so I can adjust these rights back...
!
!
!
!
!"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
!news:q$******* *******@cpmsftn gxa06.phx.gbl.. .
!> Hello Bjarne,
!>
!> This problem is some times caused by incorrect version of comadmin.dll on
!your system. You can check the following:
!> 1) check in the registry for the existence of the key:
!>
!> HKEY_CLASSES_RO OT \ CLSID \ {6EB22881-8A19-11D0-81B6-00A0C9231C29}
!>
!> the InprocServer32 value should have a default which points to a dll
!somewhere in the windows directory (system32\com
!> \comadmin.dll)
!>
!> 2) confirm that comadmin.dll does exist in the location pointed to by the
!registry.
!>
!> 3) to make sure COM+ is working, you might want to open up the Component
!Services Explorer (under Administrative Tools),
!> and try clicking down on "My Computer" to get a list of COM+
!Applications.. .
!>
!> Hope it helps.
!>
!> Best regards,
!> Yanhong Huang
!> Microsoft Online Partner Support
!>
!> Get Secure! - www.microsoft.com/security
!> This posting is provided "AS IS" with no warranties, and confers no
!rights.
!>
!> --------------------
!> !From: "B@rney" <ba**********@h otmail.com>
!> !References: <0c************ *************** *@phx.gbl>
!<98*********** *************** **@phx.gbl>
!> <GW************ **@cpmsftngxa06 .phx.gbl>
!> !Subject: Re: ResourcePool is not supported
!> !Date: Tue, 12 Aug 2003 11:45:50 +0200
!> !Lines: 133
!> !X-Priority: 3
!> !X-MSMail-Priority: Normal
!> !X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
!> !X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
!> !Message-ID: <#s************ **@TK2MSFTNGP09 .phx.gbl>
!> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !NNTP-Posting-Host: gate.ementor.no 62.148.39.70
!> !Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP09.phx.g bl
!> !Xref: cpmsftngxa06.ph x.gbl
!microsoft.publ ic.dotnet.frame work.aspnet:167 019
!> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!> !
!> !Hi Yanhong!
!> !
!> !Do you have any other suggestions regarding this issue?
!> !
!> !I get the same error message trying to run a project originally written
!on
!> !VS.NET and FW1.0 now working on VS.NET 2003 and FW1.1.
!> !
!> !The stack trace is as follows:
!> !
!> !Exception Details: System.Platform NotSupportedExc eption: 'ResourcePool'
!is
!> !not supported on the current platform.
!> !
!> !Source Error:
!> !
!> ! An unhandled exception was generated during the execution of the
!> !current web request. Information regarding the origin and location of
the
!> !exception can be identified using the exception stack trace below.
!> !
!> !Stack Trace:
!> !
!> ![PlatformNotSupp ortedException: 'ResourcePool' is not supported on the
!> !current platform.]
!> ! System.Enterpri seServices.Plat form.Assert(Boo lean fSuccess, String
!> !function) +69
!> ! System.Enterpri seServices.Plat form.Assert(Ver sion platform, String
!> !function) +71
!> ! System.Enterpri seServices.Reso urcePool..ctor( TransactionEndD elegate
!cb)
!> !+38
!> ! System.Data.Sql Client.Connecti onPool..ctor(De faultPoolContro l ctrl)
!+797
!> ! System.Data.Sql Client.PoolMana ger.FindOrCreat ePool(DefaultPo olControl
!> !ctrl, IntPtr SID) +260
!> !
!>
!!System.Data.S qlClient.SqlCon nectionPoolMana ger.GetPooledCo nnection(SqlCon n
e
!c
!> !tionString options, Boolean& isInTransaction ) +358
!> ! System.Data.Sql Client.SqlConne ction.Open() +384
!> !
!>
!!Microsoft.App licationBlocks. Data.SqlHelperP arameterCache.D iscoverSpParame t
e
!r
!> !Set(SqlConnect ion connection, String spName, Boolean
!> !includeReturnV alueParameter) in c:\documents and settings\bjarne l.
!gram\my
!> !documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2429
!> !
!>
!!Microsoft.App licationBlocks. Data.SqlHelperP arameterCache.G etSpParameterSe t
I
!n
!> !ternal(SqlConn ection connection, String spName, Boolean
!> !includeReturnV alueParameter) in c:\documents and settings\bjarne l.
!gram\my
!> !documents\my
!projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2602
!> !
!>
!!Microsoft.App licationBlocks. Data.SqlHelperP arameterCache.G etSpParameterSe t
(
!S
!> !tring connectionStrin g, String spName, Boolean
!includeReturnV alueParameter)
!> !in c:\documents and settings\bjarne l. gram\my documents\my
!> !projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2546
!> !
!>
!!Microsoft.App licationBlocks. Data.SqlHelperP arameterCache.G etSpParameterSe t
(
!S
!> !tring connectionStrin g, String spName) in c:\documents and
!settings\bjarn e
!> !l. gram\my documents\my
!> !projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 2526
!> ! Microsoft.Appli cationBlocks.Da ta.SqlHelper.Ex ecuteReader(Str ing
!> !connectionStri ng, String spName, Object[] parameterValues ) in
!c:\documents
!> !and settings\bjarne l. gram\my documents\my
!> !projects\rdg\m icrosoft.applic ationblocks.dat a\sqlhelper.cs: 909
!> !...
!> !
!> !
!> !Best regards
!> !
!> !Bjarne L. Gram
!> !Seniorconsulta nt - MCP
!> !Ementor Norge AS
!> !Microsoft Gold Certified Partner
!> !b**********@NO SPAMementor.no
!> !
!> !"Yan-Hong Huang[MSFT]" <yh*****@online .microsoft.com> wrote in message
!> !news:GW******* *******@cpmsftn gxa06.phx.gbl.. .
!> !> Hello David,
!> !>
!> !> I am glad that the problem is resovled. Generally speaking, when the
!web
!> !applicaiton is set to used anonymous and
!> !> windows authentication in IIS. Then a client will try to access it
!using
!> !anonymous. If it successes, then it will use anonymoust
!> !> to set up the connections. If it failed(when some page denies access
to
!> !anonymous user), it will try windows authentication.
!> !> You could check it in IIS logs.
!> !>
!> !> Thanks very much for participating the community.
!> !>
!> !> Best regards,
!> !> Yanhong Huang
!> !> Microsoft Online Partner Support
!> !>
!> !> Get Secure! - www.microsoft.com/security
!> !> This posting is provided "AS IS" with no warranties, and confers no
!> !rights.
!> !>
!> !> --------------------
!> !> !Content-Class: urn:content-classes:message
!> !> !From: "David" <ce************ ****@nospam.com >
!> !> !Sender: "David" <ce************ ****@nospam.com >
!> !> !References: <0c************ *************** *@phx.gbl>
!> !> !Subject: ResourcePool is not supported
!> !> !Date: Wed, 6 Aug 2003 02:08:48 -0700
!> !> !Lines: 13
!> !> !Message-ID: <98************ *************** *@phx.gbl>
!> !> !MIME-Version: 1.0
!> !> !Content-Type: text/plain;
!> !> ! charset="iso-8859-1"
!> !> !Content-Transfer-Encoding: 7bit
!> !> !X-Newsreader: Microsoft CDO for Windows 2000
!> !> !X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
!> !> !Thread-Index: AcNb+lh3Rk5TNBs 6Qg2Fb3z+GtNeTg ==
!> !> !Newsgroups: microsoft.publi c.dotnet.framew ork.aspnet
!> !> !Path: cpmsftngxa06.ph x.gbl
!> !> !Xref: cpmsftngxa06.ph x.gbl
!> !microsoft.publ ic.dotnet.frame work.aspnet:165 287
!> !> !NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
!> !> !X-Tomcat-NG: microsoft.publi c.dotnet.framew ork.aspnet
!> !> !
!> !> !Morning
!> !> !
!> !> !Came in today and sorted it in 5 minutes, annoying when
!> !> !that happens. I'd recreated my web project from
!> !> !sourcesafe yesterday and when it created the projected it
!> !> !had annoymous autentication switched on in IIS. All I had
!> !> !to do was switch this off. The Project was already set to
!> !> !use Windows Authentication in the Web.config but the
!> !> !AnnoymousAuthe ntication option in IIS seemed to overide it.
!> !> !
!> !> !Everything is now hunky doory
!> !> !
!> !> !David
!> !> !
!> !>
!> !>
!> !
!> !
!> !
!>
!>
!
!
!