Showing posts with label msdn. Show all posts
Showing posts with label msdn. Show all posts

Wednesday, March 21, 2012

Error on Forms Authentication Security Extension on MSDN

I made changes and setup all config files as per article and also give
permssion to folder.
I'm able to register new user but when I try to logon i get following error:
----
Server Error in '/Reports' Application.
----
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'. The request failed with the error message: -- <html>
<head> <title> Microsoft Reporting Services </title><meta name="Generator"
content="Microsoft SQL Server Reporting Services 8.00.878.00" /> <meta
name="HTTP Status" content="500" /> <meta name="ProductLocaleID" content="9"
/> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
content=" at
Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName() at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
{FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
<li>This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
color="silver" /><span class="ProductInfo">Microsoft Reporting
Services</span> </body> </html> --.
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.InvalidOperationException: Client found response
content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
request failed with the error message: -- <html> <head> <title> Microsoft
Reporting Services </title><meta name="Generator" content="Microsoft SQL
Server Reporting Services 8.00.878.00" /> <meta name="HTTP Status"
content="500" /> <meta name="ProductLocaleID" content="9" /> <meta
name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName() at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal;
FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover {FONT-SIZE:
8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline} A:visited
{FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
Reporting Services Error<hr width="100%" size="1" color="silver" /> </h1><ul>
<li>This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
color="silver" /><span class="ProductInfo">Microsoft Reporting
Services</span> </body> </html> --.
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:
[InvalidOperationException: Client found response content type of
'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
Microsoft Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting
Services 8.00.878.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>This operation is not supported in this edition of Reporting Services
(rsOperationNotSupported) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">Microsoft Reporting Services</span>
</body>
</html>
--.]
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
+1488
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) +218
Microsoft.SqlServer.ReportingServices.ReportingService.LogonUser(String
userName, String password, String authority) in c:\program files\microsoft
sql server\mssql\reporting
services\samples\extensions\formsauthenticationsample\reportingservice.cs:2301
Microsoft.Samples.ReportingServices.CustomSecurity.UILogon.BtnLogon_Click(Object
sender, EventArgs e) in c:\program files\microsoft sql server\mssql\reporting
services\samples\extensions\formsauthenticationsample\uilogon.aspx.cs:116
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Thanks,Did you restart IIS on the server? I had the same problem until is did the
IISRESET on the Reporting Server.
Greg Quinn, MCP
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:5C92F4F4-9C6A-4E97-A683-6B7358C4827F@.microsoft.com...
>I made changes and setup all config files as per article and also give
> permssion to folder.
> I'm able to register new user but when I try to logon i get following
> error:
> ----
> Server Error in '/Reports' Application.
> ----
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'. The request failed with the error message: -- <html>
> <head> <title> Microsoft Reporting Services </title><meta name="Generator"
> content="Microsoft SQL Server Reporting Services 8.00.878.00" /> <meta
> name="HTTP Status" content="500" /> <meta name="ProductLocaleID"
> content="9"
> /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> content=" at
> Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover
> {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
> A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
> color="silver" /><span class="ProductInfo">Microsoft Reporting
> Services</span> </body> </html> --.
> 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.InvalidOperationException: Client found response
> content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
> request failed with the error message: -- <html> <head> <title> Microsoft
> Reporting Services </title><meta name="Generator" content="Microsoft SQL
> Server Reporting Services 8.00.878.00" /> <meta name="HTTP Status"
> content="500" /> <meta name="ProductLocaleID" content="9" /> <meta
> name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content="
> at
> Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana;
> FONT-WEIGHT:normal;
> FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover
> {FONT-SIZE:
> 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
> A:visited
> {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
> color="silver" /><span class="ProductInfo">Microsoft Reporting
> Services</span> </body> </html> --.
> 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:
>
> [InvalidOperationException: Client found response content type of
> 'text/html; charset=utf-8', but expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> Microsoft Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server Reporting
> Services 8.00.878.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>This operation is not supported in this edition of Reporting Services
> (rsOperationNotSupported) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">Microsoft Reporting Services</span>
> </body>
> </html>
> --.]
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> +1488
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) +218
> Microsoft.SqlServer.ReportingServices.ReportingService.LogonUser(String
> userName, String password, String authority) in c:\program files\microsoft
> sql server\mssql\reporting
> services\samples\extensions\formsauthenticationsample\reportingservice.cs:2301
> Microsoft.Samples.ReportingServices.CustomSecurity.UILogon.BtnLogon_Click(Object
> sender, EventArgs e) in c:\program files\microsoft sql
> server\mssql\reporting
> services\samples\extensions\formsauthenticationsample\uilogon.aspx.cs:116
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +57
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
> String eventArgument) +18
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
> System.Web.UI.Page.ProcessRequestMain() +1277
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> ASP.NET
> Version:1.1.4322.573
>
> Thanks,
>|||Thanks for your comment.
I already tired with it but facing same problem.
"Gregory C. Quinn, Jr." wrote:
> Did you restart IIS on the server? I had the same problem until is did the
> IISRESET on the Reporting Server.
> Greg Quinn, MCP
> "Kam" <Kam@.discussions.microsoft.com> wrote in message
> news:5C92F4F4-9C6A-4E97-A683-6B7358C4827F@.microsoft.com...
> >I made changes and setup all config files as per article and also give
> > permssion to folder.
> >
> > I'm able to register new user but when I try to logon i get following
> > error:
> >
> > ----
> >
> > Server Error in '/Reports' Application.
> > ----
> >
> > Client found response content type of 'text/html; charset=utf-8', but
> > expected 'text/xml'. The request failed with the error message: -- <html>
> > <head> <title> Microsoft Reporting Services </title><meta name="Generator"
> > content="Microsoft SQL Server Reporting Services 8.00.878.00" /> <meta
> > name="HTTP Status" content="500" /> <meta name="ProductLocaleID"
> > content="9"
> > /> <meta name="CountryLocaleID" content="1033" /> <meta name="StackTrace"
> > content=" at
> > Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> > at
> > Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> > at
> > Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> > at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> > at
> > Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
> > Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> > sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal;
> > FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> > FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover
> > {FONT-SIZE:
> > 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
> > A:visited
> > {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" />
> > </h1><ul>
> > <li>This operation is not supported in this edition of Reporting Services
> > (rsOperationNotSupported) <a
> > href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> > target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
> > color="silver" /><span class="ProductInfo">Microsoft Reporting
> > Services</span> </body> </html> --.
> > 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.InvalidOperationException: Client found response
> > content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
> > request failed with the error message: -- <html> <head> <title> Microsoft
> > Reporting Services </title><meta name="Generator" content="Microsoft SQL
> > Server Reporting Services 8.00.878.00" /> <meta name="HTTP Status"
> > content="500" /> <meta name="ProductLocaleID" content="9" /> <meta
> > name="CountryLocaleID" content="1033" /> <meta name="StackTrace" content="
> > at
> > Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> > at
> > Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> > at
> > Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> > at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> > at
> > Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos() at
> > Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> > sender, EventArgs e)" /> <style> BODY {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black} H1 {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:700; FONT-SIZE:15pt} LI {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:normal;
> > FONT-SIZE:8pt; DISPLAY:inline} .ProductInfo {FONT-FAMILY:Verdana;
> > FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray} A:link {FONT-SIZE: 8pt;
> > FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none} A:hover
> > {FONT-SIZE:
> > 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
> > A:visited
> > {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline} </style> </head><body bgcolor="white"> <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" />
> > </h1><ul>
> > <li>This operation is not supported in this edition of Reporting Services
> > (rsOperationNotSupported) <a
> > href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> > target="_blank">Get Online Help</a></li> </ul><hr width="100%" size="1"
> > color="silver" /><span class="ProductInfo">Microsoft Reporting
> > Services</span> </body> </html> --.
> >
> > 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:
> >
> >
> > [InvalidOperationException: Client found response content type of
> > 'text/html; charset=utf-8', but expected 'text/xml'.
> > The request failed with the error message:
> > --
> > <html>
> > <head>
> > <title>
> > Microsoft Reporting Services
> > </title><meta name="Generator" content="Microsoft SQL Server Reporting
> > Services 8.00.878.00" />
> > <meta name="HTTP Status" content="500" />
> > <meta name="ProductLocaleID" content="9" />
> > <meta name="CountryLocaleID" content="1033" />
> > <meta name="StackTrace" content=" at
> > Microsoft.ReportingServices.Diagnostics.Globals.ThrowUnsupportedOnStandardOperation()
> > at
> > Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> > at
> > Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> > at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> > at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> > at
> > Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> > sender, EventArgs e)" />
> > <style>
> > BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> > COLOR:black}
> > H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> > LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> > DISPLAY:inline}
> > .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> > COLOR:gray}
> > A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> > TEXT-DECORATION:none}
> > A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> > TEXT-DECORATION:underline}
> > A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> > TEXT-DECORATION:none}
> > A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> > TEXT-DECORATION:underline}
> >
> > </style>
> > </head><body bgcolor="white">
> > <h1>
> > Reporting Services Error<hr width="100%" size="1" color="silver" />
> > </h1><ul>
> > <li>This operation is not supported in this edition of Reporting Services
> > (rsOperationNotSupported) <a
> > href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsOperationNotSupported&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00"
> > target="_blank">Get Online Help</a></li>
> > </ul><hr width="100%" size="1" color="silver" /><span
> > class="ProductInfo">Microsoft Reporting Services</span>
> > </body>
> > </html>
> > --.]
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > +1488
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) +218
> > Microsoft.SqlServer.ReportingServices.ReportingService.LogonUser(String
> > userName, String password, String authority) in c:\program files\microsoft
> > sql server\mssql\reporting
> > services\samples\extensions\formsauthenticationsample\reportingservice.cs:2301
> > Microsoft.Samples.ReportingServices.CustomSecurity.UILogon.BtnLogon_Click(Object
> > sender, EventArgs e) in c:\program files\microsoft sql
> > server\mssql\reporting
> > services\samples\extensions\formsauthenticationsample\uilogon.aspx.cs:116
> > System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
> > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> > eventArgument) +57
> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl,
> > String eventArgument) +18
> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
> > System.Web.UI.Page.ProcessRequestMain() +1277
> >
> >
> >
> >
> > ----
> > Version Information: Microsoft .NET Framework Version:1.1.4322.573;
> > ASP.NET
> > Version:1.1.4322.573
> >
> >
> > Thanks,
> >
>
>
Posted by arithm at 2:16 AM 0 comments
Labels: , , , , , , , , , , , , , , , , , , ,

Sunday, February 19, 2012

error message in view to a linked server

arno,
Here is someone about a year ago getting a very similar error:
https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1245831&SiteID=1
It seems that datatype mapping is at the root of the problem, so perhaps
this article (and its references) will help.
http://msdn2.microsoft.com/en-us/library/ms175970.aspx
But I have never seen this error myself.
RLF
"arno" <nospam@.invalid> wrote in message
news:ey2LLfeUIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I have a firebird 1.5 application. In my sql-server 2000 I created a
> linked server to firebird using the firebird odbc driver. I cannot query
> one table because I get the following error:
> " [Non-interface error: Column 'ERHALTENABSCHLAG' (compile-time ordinal
> 35) of object 'LVVERW' was reported to have a DBTYPE of 5 at compile time
> and 131 at run time]. (Source: Microsoft OLE DB Provider for SQL Server)
> (SQL State: 01000) (NativeError: 7300)Error -2147217900 "
> How can I solve tis problem?
> I cannot find any corrupt data in that column. I can query the table w/o
> problems from an Access Database with odbc-links to the table. I can
> Import the table into an sql-server database using the odbc-driver w/o a
> problem, it is just impossible to run a query on the table of the linked
> server.
> regards
> arno
>
arno,
I don't want to post the whole thread, but these are some of the comments.
#1 - IgorB
I found that the problem is usually in the data type of the columns defined
in the Oracle view: for example SQL 2005 doesn't like a oracle INTEGER, but
if you convert the integer columns in a NUMBER the error will disappear. The
same with the Oracle VARCHAR2.
#2 - Hans G
It occured with Oracle >= 9.2.6 (w. Sql2000 and Sql2005).It only occurs on
Querys in the format of "select * from ORASRV..USER.TABLE"; and thereby
only; if the oracle-table has fields of type "number". When I alter the
oracle-number-fields to a more precise type of e.g. number(10), the problem
is solved.
#3 - Kev dock
It appears, from reading forums, that a field defined as "TEST NUMBER" is
typeless whereas a field defined as TEST NUMBER(10,2) is not - hence ODBC or
OLEDB drivers get confused as they dont know what to convert these things
to.
RLF
"arno" <nospam@.invalid> wrote in message
news:uiVC3iCVIHA.5208@.TK2MSFTNGP04.phx.gbl...
> Hello Russel,
>
> I cannot follow the link, and cannot google the postID. Can cut/paste the
> thread?
>
> I think it does not say what to do in a case of error.
> arno
>
Posted by arithm at 4:30 AM 0 comments
Labels: , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)