Error while using sp_OAMethod

I get an error with HResult 10077 while using the sp_OAMethod to get an
'Item' from an array returned by VBScript.RegExp's Execute Method. Error
occurs after executing this for 3346 records.
I have seen article # 816937. But, didn't find much help.
My SQL Server version
===================
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)
Can someone help me on this?
Kiran
Programmer Analyst
Can you post some code to reproduce the issue?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:9913D55F-80D0-4357-A51B-470C5664E079@.microsoft.com...
> I get an error with HResult 10077 while using the sp_OAMethod to get an
> 'Item' from an array returned by VBScript.RegExp's Execute Method. Error
> occurs after executing this for 3346 records.
> I have seen article # 816937. But, didn't find much help.
> My SQL Server version
> ===================
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
> Can someone help me on this?
> --
> Kiran
> Programmer Analyst
>
|||I encountered the memory leak problem (816937) myself recently. After a
while it stopped returning results and would occasionally throw errors. We
finally had to re-boot, and then I found another tool to handle RegEx's in
SQL. Here's the link to the one I'm using currently:
http://www.codeproject.com/database/...asp#xx963223xx
"Kiran" <Kiran@.discussions.microsoft.com> wrote in message
news:9913D55F-80D0-4357-A51B-470C5664E079@.microsoft.com...
>I get an error with HResult 10077 while using the sp_OAMethod to get an
> 'Item' from an array returned by VBScript.RegExp's Execute Method. Error
> occurs after executing this for 3346 records.
> I have seen article # 816937. But, didn't find much help.
> My SQL Server version
> ===================
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT
> 5.0 (Build 2195: Service Pack 4)
> Can someone help me on this?
> --
> Kiran
> Programmer Analyst
>

Error while trying to use ReportServices 2005 WebService

I'm messing around with the SSRS 2005 WebService from a vb.net application. When calling the .ListChildren method I get the following error:

Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

Here is the code I'm using (I called the webreference ssrs)

dim rs as new ssrs.ReportingService2005()

rs.url = "http://127.0.0.1/reportserver"

rs.credentials = System.New.CredentialCache.DefaultCredentials

dim items() as ssrs.CatalogItem

items = rs.ListChildren ("/", True)

The error is coming from the Visual Studio generated proxy. The issue is that when you override the .Url property you must specify the entire URL of the Reporting Services endpoint.

Change your URL string to http://127.0.0.1/reportserver/reportservice2005.asmx and everything should work then.

All of the various designers that we ship automatically append the appropriate web service endpoint. Unfortunately we do not control the code that is generated by the proxy that VS creates. You must ensure that the URL points to the endpoint yourself if you choose to overwrite the default URL that is assigned when the proxy is generated.

|||

Check your credentials...you got a typo

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Error while trying to use ReportServices 2005 WebService

I'm messing around with the SSRS 2005 WebService from a vb.net application. When calling the .ListChildren method I get the following error:

Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

Here is the code I'm using (I called the webreference ssrs)

dim rs as new ssrs.ReportingService2005()

rs.url = "http://127.0.0.1/reportserver"

rs.credentials = System.New.CredentialCache.DefaultCredentials

dim items() as ssrs.CatalogItem

items = rs.ListChildren ("/", True)

The error is coming from the Visual Studio generated proxy. The issue is that when you override the .Url property you must specify the entire URL of the Reporting Services endpoint.

Change your URL string to http://127.0.0.1/reportserver/reportservice2005.asmx and everything should work then.

All of the various designers that we ship automatically append the appropriate web service endpoint. Unfortunately we do not control the code that is generated by the proxy that VS creates. You must ensure that the URL points to the endpoint yourself if you choose to overwrite the default URL that is assigned when the proxy is generated.

|||

Check your credentials...you got a typo

rs.Credentials = System.Net.CredentialCache.DefaultCredentials;