Http Errors

Feb 6, 2007

hi

i created endpoints and able to view wsdl

http://<servername>/hello_world
it's a stored procedure created in master database.
when i just try to view the output from this like

http:///<servername>/hello_world

it's giving me an error http501/http505 error.

i read in other article like, when soap is not able to process message , it'll be giving out as http errors.

my endpoint creation is as follows:


CREATE ENDPOINT hello_endpoint
STATE = STARTED
AS HTTP(
PATH = '/hello_world',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'testserver'
)
FOR SOAP (
WEBMETHOD 'GetSqlInfo' (name='master.dbo.hello_world', SCHEMA=STANDARD ),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'master',
NAMESPACE = 'http://testserver/hello_world'
);

GO



i already created a stored procedure hello world:

USE [master]
GO

CREATE PROCEDURE [dbo].[hello_world]
(@msg nvarchar(256)= "Hello Sql Server")
AS BEGIN
select @msg as 'message'
END


.I am not able to find any solution for this.Any help would be a great help for me.
i joined a new project , and this is the first task for me.

thanks for all

priyaram

View 3 Replies


ADVERTISEMENT

Change Reporting Services Default URL (From Http://server/reports To Http://CompanyReports)

Jul 31, 2007

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

View 3 Replies View Related

Http://localhost/reportserver Works Http://&&<servername&&>/reportserver Doesn't

Aug 1, 2007

Hi All,

I have setup SSRS 2000 and gotten it to work but I am having trouble with SSRS 2005. I can't access to reportserver anywhere on the network. The only way to get to reportserver is termserv into the server and hit it with http://localhost/reportserver The server is Windows 2003 server Standard Ed. running SQL 2005 SP2 and Sharepoint Portal Server 2007. Can somebody please help? Thank you.

View 11 Replies View Related

SQL Server 2008 :: How To Make Sproc Return Errors For Underlying Table Errors

Jul 1, 2015

I recently updated the datatype of a sproc parameter from bit to tinyint. When I executed the sproc with the updated parameters the sproc appeared to succeed and returned "1 row(s) affected" in the console. However, the update triggered by the sproc did not actually work.

The table column was a bit which only allows 0 or 1 and the sproc was passing a value of 2 so the table was rejecting this value. However, the sproc did not return an error and appeared to return success. So is there a way to configure the database or sproc to return an error message when this type of error occurs?

View 1 Replies View Related

Parent Package Reports Failure On Errors, But No Errors In Log

Jul 31, 2006

I have a parent package that calls child packages inside a For Each container. When I debug/run the parent package (from VS), I get the following error message: Warning: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

It appears to be failing while executing the child package. However, the logs (via the "progress" tab) for both the parent package and the child package show no errors other than the one listed above (and that shows in the parent package log). The child package appears to validate completely without error (all components are green and no error messages in the log). I turned on SSIS logging to a text file and see nothing in there either.

If I bump up the MaximumErrorCount in the parent package and in the Execute Package Task that calls the child package to 4 (to go one above the error count indicated in the message above), the whole thing executes sucessfully. I don't want to leave the Max Error Count set like this. Is there something I am missing? For example are there errors that do not get logged by default? I get some warnings, do a certain number of warnings equal an error?

Thanks,

Lee

View 5 Replies View Related

How To Solve 0 Allocation Errors And 1 Consistency Errors In

Apr 20, 2006

Starwin writes "when i execute DBCC CHECKDB, DBCC CHECKCATALOG
I reveived the following error.
how to solve it?



Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -2093955965, index ID 711, page ID (3:2530). The PageId in the page header = (34443:343146507).
. . . .
. . . .


CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1635188736)' (object ID -1635188736).
CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID -1600811521)' (object ID -1600811521).

. . . .
. . . .

Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -8748568, index ID 50307, page ID (3:2497). The PageId in the page header = (26707:762626875).
Server: Msg 8909, Level 16, State 1, Line 1 Table error: Object ID -7615284, index ID 35836, page ID (3:2534). The PageId in the page heade"

View 1 Replies View Related

HTTP 404.

Feb 28, 2008



When i am tring to open the .NET application the following error is raised
HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
I kept a start page as default.aspx, which physically exists in the application directoty but I still get the error.

Can you please help me out.

View 4 Replies View Related

HTTP Post

Jun 21, 2004

Hi,

Is it possible to write a stored procedure which can post an XML file to a server using HTTP?

Thanks!

View 6 Replies View Related

HTTP Endpoints

Jun 9, 2006

Are HTTP Endpoints able to be reached by another application that does not run on the same network?

For example, we have a partner that has a Web Application that would like to retrieve data from our database. We would like them to call a SOAP method through the Endpoint and in essence let their Web Application consume the Web Service. Is this possible?

View 1 Replies View Related

How To Execute HTTP From SQL

Jan 15, 2007

George writes "I wan to use a cursor to execute
let's say

'www.xxx.com/'+@mydata.....

from SQL 2005

Is that possible??


THanks in advance"

View 3 Replies View Related

Import Txt From Http

Jul 20, 2005

Is there a quick way to import a txt file from an http location manually...and then later automate the process? This is a do-not-call list thatconsists only of phone numbers. I appreciate any and all pointers!!!TIA - Rob

View 2 Replies View Related

Asp HTTP 500 Error

May 27, 2007

Hello there,

I have created a login page for users. The login page contain <FORM action="verifyuser.asp" method="post">. The verifyuser page verify that the user exist in the database. All the pages, home, login, memberspage, updatemember, seems to be working properly except for the verifyuser page. This is the code for the page:




<%
Dim objConn, oRSu
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;"& _
"User ID=sa;Password=test12345; Initial Catalog=members;Data Source= Kai-PC;"

dim varUsername, varPassword
varUsername = Request.Form("Username")
varPassword = Request.Form("Password")

set oRSU=server.CreateObject("adodb.recordset")
SQL = "Select * from Users where Username = '" & varUsername & "' AND
Password = '"& varPassword &"'"
oRSu.open SQL, objConn
If oRSu.EOF Then
response.redirect "Login.asp"
end if
Session("Username") = oRSu("Username")
Session("password") = oRSu("password")

Response.redirect "memberspage.asp"
oRSu.Close
set oRSu=nothing
%>

---------------------------------------------



Whenever I try to login a HTTP 500 Internal Server Error appears... I have no idea whether that caused by the codes or because I'm using Vista? Thanks

View 1 Replies View Related

HTTP ENDPPOINTS

Nov 16, 2006

I keep getting this error when trying to create one:

This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

I am running sbs2003 r2. Is this not supported on this server?

View 7 Replies View Related

Http Destination

Sep 19, 2007

I have been given a requirement to post data to a Peoplesoft Http gateway, using SSIS.

To be completely honest I havn't got a clue where to start with this, can anybody give me any pointers?
Am I going to have to use a script component?
Are there any decent examples / samples.

Sorry about the open nature of this question, but I really dont know where to start.

I think Biztalk may be a better option as in integration tool for this work.

View 1 Replies View Related

ReportViewer And HTTP 401

Mar 2, 2007

I have read a million documents on this question and I still don't get it. I would greatly appreciate any insights.

I start a new WebSite. I put these specs in web.config:

<authentication mode="Windows"/>

<identity impersonate="true" userName="AIBablh" password="blah" />
<authorization> <deny users="?"/> </authorization>

I put a ReportViewer control on my only page.

I set the URL and the ReportName and run the application which returns HTTP 401, authorization error. What else do I have to do to make this little demonstration work?

I have read entries about credentials, about delegation, about application pools, about just about everything.

Isn't this just supposed to work? This works without difficulty on a Windows form.

Much thanks.

View 2 Replies View Related

How To Use Http Endpoints?

Mar 18, 2008

hi,
I am new to sql so i created this http endpoint int sql 2005.

now how to use it?

for example i create stored procedure and i can use it by "execute procedurename"
how it works on endpoint side?

View 1 Replies View Related

SQLServer2K Http Request?

Mar 29, 2004

Is it possible for SQLServer to make a http web request in a stored procedure? I know that you can configure it to send email, but I'd rather do that on the webserver side, and that needs to be triggered by a request of some sort. I have a sp that runs nightly, and I'd like it to send out a http request when its done so that I can do further processing/send email/what have you. I haven't been able to find anything on this subject in any of the books I have, and my google-fu isn't strong enough. Thanks for any hints.

Rob

View 3 Replies View Related

Xp_sendmail Http Question

Nov 30, 2004

The @IMGRPNAME, if it is two words, the second word is not a weblink. ANy idea? @IMGRPNAME is declare as varchar(1000)

****************************

Set @IMGRPNAME = (select IMGrpname from IM where IMID = @IMID2)
Set @IMEmail = (select IMEmail from IM where IMID = @IMID2)
Set @IMID3 = (select IMID from IM where IMID = @IMID2)
SET @MsgText = ' has been without a last resort implementer for the past 24 hours. Please click here to assign a last resort implementer: http://ssx_emps.aspx?imid=' + @IMID3 + '&imgrpname=' + @IMGrpName
SET @FullText = @IMGRPName + @MsgText
EXEC master.dbo.xp_sendmail
@recipients = @IMEmail,
@Message = @FullText,
@Subject = 'SAMS Implementation Group needs attention'

View 2 Replies View Related

SQL Server Connection Thru HTTP

Mar 30, 2006

Hello SQL gurus.

I just wanted to kmow if we can connect a SQL server DB , located at some remote geographical location, via HTTP protocol.



Thanks in advance.
Ankit

View 3 Replies View Related

Help With Adding Http:// To A Table

Jun 9, 2006

Ok What I am looking to do is add http:// to all fields in a table that do not already begin with http://.
The query I have come up with so far is the following.
However it does not work and I am hopeing that somone that knows what they are doing can give a new guy a hand please.

UPDATE Company
SET Company.URL = 'http://' + CompanyURL
WHERE Company.CompanyURL
IN(SELECT Company.CompanyURL
FROM Company
GROUP BY Company.CompanyURL
HAVING (((NOT LEFT(Company.CompanyURL,7) = 'http://'))))

View 2 Replies View Related

Rep Serv, How To Deploy A Rpt Http://

Oct 22, 2007

Hi, I need help.

I created a report via Rpt services wizard.
I can execute the report via Start Debugging.
I would like to deploy the report so that i can view it via http://

I need to call the report via external app & pass parameters.
This is what i selected in wizard.
Report server: http://za001b78ad82c4/ReportServer

Can anyone please assist or have an example on how to.

Regards,

View 1 Replies View Related

Why Is My SQL HTTP Endpoint So Slow?

Oct 23, 2007

I have the need to have a client application connect to a remote database server for retrieval of large datasets (~13000 rows at time) and am trying to leverage existing technologies to build my solution.

To test the difference in retrieval times I created 2 test apps - testA and testB. I created an HTTP endpoint in SQL Server (2005) that exposes one web method corresponding to a sproc that executes one select query and configured testA to execute query and bind the results to a data grid. I exposed my SQL Server so that I could connect directly to the SQL Server using a connection string and configured testB to execute the same SQL statement in an ad-hoc fashion, binding the results to a data grid.

On average, the HTTP endpoint would take ~ 34 seconds to return the 13,000 row data set whereas the direct connection returned that same result set in 4 seconds or less.

I have a bunch of questions:
* Why would I be seeing such a dramatic difference in the retrieval times?
* How is SQL Server communicating when there is a direct connection?
* What are the immediate disadvantages to connecting directly to the remote SQL Server?
* If I were to consider allowing my client application to communicate directly with the SQL Server, is there any way to secure the communication without VPN?
* In addition, is it even possible to create a SQL login that has all of these requirements?
** select and update only
** cannot view schema (cannot connect to the SQL Server using SQL Server Management Studio)
** cannot view any system tables
** cannot retrieve any information about the schema of the database whatsoever

I guess I'm wondering if there is a way to overcome the obvious serialization overhead that comes with the HTTP endpoint to get the speed of the direct connection while being secure at the same time. Is that being greedy? :P

Anyhow, what are your opinions? I'm very interested to hear experiences and/or advice.

Thanks,

Paul

View 1 Replies View Related

Http://localhost/reportserver

Feb 10, 2008



Hi. Does anybody know why I'm getting the following error when I go to http://localhost/reportserver in a browser? is there a problem with how to setup permission or Windows Vista?


Server Error in Application "Default Web Site"


HTTP Error 404.0 - Not Found

Description: The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.

Error Code: 0x80070002

Notification: MapRequestHandler

Module: IIS Web Core

Requested URL: http://localhost:80/reportserver

Physical Path: C:inetpubwwwroot
eportserver

Logon User: Anonymous

Logon Method: Anonymous

Handler: StaticFile

Most likely causes:

The directory or file specified does not exist on the Web server.
The URL contains a typographical error.
A custom filter or module, such as URLScan, restricts access to the file.

What you can try:

Create the content on the Web server.
Review the browser URL.
Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here.

More Information... This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.


Server Version Information: Internet Information Services 7.0.

View 5 Replies View Related

How To Enable SSL For HTTP Endpoint?

May 31, 2007

Hi,

I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.

I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.



Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.

I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.



I appreciate your help and comments.

Bruce.

View 3 Replies View Related

About Web Service Or HTTP ENDPOINT

Jun 27, 2006



Hi All,

I met some problems when I walk through a example for Native Http SOAP in SQL Server 2005 for Developers. after I create the HTTP EndPoint in the Management Studio using following code:


USE AdventureWorks
GO

CREATE PROCEDURE EmployeePhoneList
AS
SELECT C.LastName, C.FirstName, C.Phone
FROM Person.Contact AS C
INNER JOIN HumanResources.Employee AS E
ON C.ContactID = E.ContactID
ORDER BY C.LastName, C.FirstName
GO

DROP ENDPOINT HRService;
GO

CREATE ENDPOINT HRService
STATE = STARTED
AS HTTP
(
PATH='/HumanResources',
AUTHENTICATION=(INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP
(
WEBMETHOD 'EmployeePhoneList'(name='AdventureWorks.dbo.EmployeePhoneList'),
DATABASE='AdventureWorks',
WSDL=DEFAULT
)

then I can see the web service is indeed created by using following cmnd,


SELECT *
FROM sys.endpoints

SELECT *
FROM sys.soap_endpoints;

SELECT *
FROM sys.endpoint_webmethods;

but when I want to use the web service in the VS2005, I can't find it and add the web reference. Any help will be greatly appreciated. and could you please tell me how to check web services in the local computer? Thanks.

Chris

View 8 Replies View Related

OPENROWSET On XML File Through HTTP

May 7, 2008

Hi everyone,


I am currently using the OPENROWSET command to read a XML file.


-- Use OPENROWSET to read an XML file from the file system

SELECT @xml = BulkColumn

FROM OPENROWSET(BULK 'c:file.xml', SINGLE_BLOB) TempXML


However, the file I wish to process is being generated externally and published through a web server. The file is constantly being updated, and I need to have the latest data frequently. Is it possible to do something along the lines of:


-- Use OPENROWSET to read an XML file from the file system
SELECT @xml = BulkColumn

FROM OPENROWSET(BULK 'http://webserver/file.xml', SINGLE_BLOB) TempXML


If it is not possible, can someone recommend the best method to copy/download the file? I have considered standalone Windows Services and utilizing SQL Server. Are there significant pros or cons to either approach? Are there other methods I am not awere of? Any feedback on this would be greatly appreciated.


Thanks,


Matt K.

View 3 Replies View Related

HTTP ERROR 401.1 - Unauthorized

Jun 2, 2005

Hi

View 10 Replies View Related

HTTP File Upload

Aug 11, 2006

I'm looking for a way with Integration Services in SQL'05 to upload a file. How could I do this? Is there any examples out there?

This partuclar HTTP Server has WEBDAV configured so if I could just point to the URL location and new FILE that would be excellent.

Thanks

View 2 Replies View Related

HTTP Endpoints On Vista

Mar 20, 2007

Hi,

I'm looking into hosting SQL Server endpoints on Vista. Unfortunately they don't work nicely because, as far as I know, they require http.sys which is part of Windows Server 2003. Hence, I can create my endpoint but i can't browse to it over http.

So, siple question (not so simple answer) how can I access SQL Server endpoints on Vista?



Thanks

Jamie

View 4 Replies View Related

Consume HTTP EndPoint

Mar 19, 2006

Hello, I have problems consuming webservice, I was following this page.



http://codebetter.com/blogs/raymond.lewallen/archive/2005/06/23/65089.aspx



but in the intelisense the method returns an array of objects[], So I have a problem with this line.



localhost.GetEmployees sd = new localhost.GetEmployees();

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

DataSet ds = (DataSet)(sd.EmployeeList());------> IT CANT CONVERT.

GridView1.DataSource = ds.Tables[0];

GridView1.DataBind();



Error 1 Cannot convert type 'object[]' to 'System.Data.DataSet' c:inetpubwwwrootatlas1Default.aspx.cs 18 22 http://localhost/atlas1/

View 10 Replies View Related

I Can't See Http://localhost/Reports/

Apr 12, 2008

Hi I have problems when I try to see http://localhost/Reports/ send the follow message:

Failed to access IIS metabase.

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.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.

The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.

I tried diferent commands

aspnet_regiis -u
aspnet_regiis -i
aspnet_regiis -ga ASPNET

that I found in the web but the problem is the same.

Someone can help me please?

Thank you.

View 1 Replies View Related

Http://localhost/reportserver

Jun 16, 2007

http://localhost/reportserver allows me to get to the reports, but there used to be another way I did it. I thought it was http://localhost/reports, which gave me a nicer looking page and put icons that says "new" on the new reports.



Am I imagining this?

View 3 Replies View Related

Get Http Request In A File

Oct 9, 2007

Dear All,

In SSIS is there any way get the content of a HTTP request and the save it as a file for lateron processing?
What can I do if I need to "POST" the parameter to the server in order to get the file?

Thanks and regards

Tony Chun Tung Siu

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved