SQL Server Connection Problem

  • Thread starter Thread starter Craig Mellon
  • Start date Start date
C

Craig Mellon

Hi All,

I am new to ASP.net and am having a problem connecting to
SQL. Everytime i try to open the connection i get the
following error:

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 68: Dim oConn As New SqlConnection
Line 69: oConn.ConnectionString
= "Server=CraigDev\Development01;Database=DDAContact;User
Id=**;Password=***"
Line 70: oConn.Open()
Line 71:
Line 72: Try

The above connection string is what i use in my vb6
projects and works ok in vb 6. The above call falls over
on line 70 every time and i haven't got a clue what it is.

Thanks in advance

Craig
 
Below is dump of the actual error message

Server Error in '/DDAContact' Application.
----------------------------------------------------------
----------------------

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 70: "Initial
Catalog=ddaContact;" & _
Line 71: "User
Id=******;Password=*******"
Line 72: oConn.Open()
Line 73: Try
Line 74: Dim oCMD As New SqlCommand
("spAgent_Fetch", oConn)


Source File: c:\inetpub\wwwroot\DDAContact\cAgent.vb
Line: 72

Stack Trace:


[PlatformNotSupportedException: 'ResourcePool' is not
supported on the current platform.]
System.EnterpriseServices.Platform.Assert(Boolean
fSuccess, String function)
System.EnterpriseServices.Platform.Assert(Version
platform, String function)
System.EnterpriseServices.ResourcePool..ctor
(TransactionEndDelegate cb)
System.Data.SqlClient.ConnectionPool.CreateResourcePool
()
System.Data.SqlClient.ConnectionPool..ctor
(DefaultPoolControl ctrl)
System.Data.SqlClient.PoolManager.FindOrCreatePool
(DefaultPoolControl ctrl)

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
DDAContact.cAgent.Populate(Int32 iAgentId, String
sAgentRef) in c:\inetpub\wwwroot\DDAContact\cAgent.vb:72
DDAContact.WebForm1.cmdLogin_Click(Object sender,
EventArgs e) in
c:\inetpub\wwwroot\DDAContact\Login.aspx.vb:42
System.Web.UI.WebControls.Button.OnClick(EventArgs e)

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEv
entHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
 
Check following link .....

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dndotnet/html/framewkwinsupp.asp

It is about .NET Framework Support on Windows Operating
Systems.

Thanks,

Tapasvi
-----Original Message-----
Below is dump of the actual error message

Server Error in '/DDAContact' Application.
----------------------------------------------------------
----------------------

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 70: "Initial
Catalog=ddaContact;" & _
Line 71: "User
Id=******;Password=*******"
Line 72: oConn.Open()
Line 73: Try
Line 74: Dim oCMD As New SqlCommand
("spAgent_Fetch", oConn)


Source File: c:\inetpub\wwwroot\DDAContact\cAgent.vb
Line: 72

Stack Trace:


[PlatformNotSupportedException: 'ResourcePool' is not
supported on the current platform.]
System.EnterpriseServices.Platform.Assert(Boolean
fSuccess, String function)
System.EnterpriseServices.Platform.Assert(Version
platform, String function)
System.EnterpriseServices.ResourcePool..ctor
(TransactionEndDelegate cb)
System.Data.SqlClient.ConnectionPool.CreateResourcePool
()
System.Data.SqlClient.ConnectionPool..ctor
(DefaultPoolControl ctrl)
System.Data.SqlClient.PoolManager.FindOrCreatePool
(DefaultPoolControl ctrl)

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
DDAContact.cAgent.Populate(Int32 iAgentId, String
sAgentRef) in c:\inetpub\wwwroot\DDAContact\cAgent.vb:72
DDAContact.WebForm1.cmdLogin_Click(Object sender,
EventArgs e) in
c:\inetpub\wwwroot\DDAContact\Login.aspx.vb:42
System.Web.UI.WebControls.Button.OnClick(EventArgs e)

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEv
entHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()




----------------------------------------------------------
----------------------
Version Information: Microsoft .NET Framework
Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
-----Original Message-----
Hi All,

I am new to ASP.net and am having a problem connecting to
SQL. Everytime i try to open the connection i get the
following error:

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 68: Dim oConn As New SqlConnection
Line 69: oConn.ConnectionString
= "Server=CraigDev\Development01;Database=DDAContact;User
Click to expand...
Id=**;Password=***"
Line 70: oConn.Open()
Line 71:
Line 72: Try

The above connection string is what i use in my vb6
projects and works ok in vb 6. The above call falls over
on line 70 every time and i haven't got a clue what it is.

Thanks in advance

Craig
.
Click to expand...
.
Click to expand...
 
You might have to connection pooling off by adding

;Pooling=false

to your connection string.

David


Craig Mellon said:
Below is dump of the actual error message

Server Error in '/DDAContact' Application.
----------------------------------------------------------
----------------------

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 70: "Initial
Catalog=ddaContact;" & _
Line 71: "User
Id=******;Password=*******"
Line 72: oConn.Open()
Line 73: Try
Line 74: Dim oCMD As New SqlCommand
("spAgent_Fetch", oConn)


Source File: c:\inetpub\wwwroot\DDAContact\cAgent.vb
Line: 72

Stack Trace:


[PlatformNotSupportedException: 'ResourcePool' is not
supported on the current platform.]
System.EnterpriseServices.Platform.Assert(Boolean
fSuccess, String function)
System.EnterpriseServices.Platform.Assert(Version
platform, String function)
System.EnterpriseServices.ResourcePool..ctor
(TransactionEndDelegate cb)
System.Data.SqlClient.ConnectionPool.CreateResourcePool
()
System.Data.SqlClient.ConnectionPool..ctor
(DefaultPoolControl ctrl)
System.Data.SqlClient.PoolManager.FindOrCreatePool
(DefaultPoolControl ctrl)

System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCo
nnection(SqlConnectionString options, Boolean&
isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
DDAContact.cAgent.Populate(Int32 iAgentId, String
sAgentRef) in c:\inetpub\wwwroot\DDAContact\cAgent.vb:72
DDAContact.WebForm1.cmdLogin_Click(Object sender,
EventArgs e) in
c:\inetpub\wwwroot\DDAContact\Login.aspx.vb:42
System.Web.UI.WebControls.Button.OnClick(EventArgs e)

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEv
entHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(IPostBackEventHandler sourceControl, String
eventArgument)
System.Web.UI.Page.RaisePostBackEvent
(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()




----------------------------------------------------------
----------------------
Version Information: Microsoft .NET Framework
Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
-----Original Message-----
Hi All,

I am new to ASP.net and am having a problem connecting to
SQL. Everytime i try to open the connection i get the
following error:

'ResourcePool' is not supported on the current platform.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and
where it originated in the code.

Exception Details:
System.PlatformNotSupportedException: 'ResourcePool' is
not supported on the current platform.

Source Error:


Line 68: Dim oConn As New SqlConnection
Line 69: oConn.ConnectionString
= "Server=CraigDev\Development01;Database=DDAContact;User
Click to expand...
Id=**;Password=***"
Line 70: oConn.Open()
Line 71:
Line 72: Try

The above connection string is what i use in my vb6
projects and works ok in vb 6. The above call falls over
on line 70 every time and i haven't got a clue what it is.

Thanks in advance

Craig
.
Click to expand...
Click to expand...
 
Back
Top