Questions tagged [web-service]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
10 views

Connecting a SOAP web service (XML) with a Solr Database

I've stood up a Solr Database in Cloud mode in our Cloudera stack using Cloudera manager and ZooKeeper. I know how to ingest data via pysolr and also through the local browser GUI, but that's usually ...
1
vote
1answer
1k views

Running queries on a mirrored database

I have a Web forms asp.net site running with a database on a VM (VM1). I also have a MVC 5 Web app that has its own membership database on another VM (VM2). I want to retrieve customer information ...
1
vote
1answer
201 views

SQL Server Web Service in a web environment architecture

I am new at SQL Server web Service and not too knowledgeable in setting up a secure web environment... From what I've read until now regarding SQL Web Service, I would need to: 1. create a stored ...
2
votes
1answer
173 views

How to store search keyword or browsing history in database [closed]

I'm making my final year project. Which is a website. Things I can't do: Store the browsing history of users between their login and logout session on the site. Or Store the search keywords. But I ...
0
votes
1answer
108 views

SQL Server: Mixed mode security: Can a non AD user (a local user, remote client) have a trusted connection to SQL?

I have used SQL Server trusted connections for years. It works well when the client app is a domain user. Imagine this three server config: dbserver webserver domain controller I now have a ...
0
votes
1answer
2k views

Calling a web service from T-SQL (Stored Procedure) using MSXML [closed]

EXEC @hResult = sp_OAMethod @objectID, 'send', null, @requestBody IF @hResult <> 0 BEGIN EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT SELECT ...
2
votes
1answer
161 views

Audit use of CLR Table-valued function

I have written some CLR table-valued functions that invoke a web service and I would like to audit their use. Does anyone know of any way this can be achieved in the CLR code itself? I would be nice ...
4
votes
1answer
2k views

Bringing web service data into SQL server

I need to retrieve a data set daily from a hosted Web service. I can retrieve the XML "column names" in an SSIS package. But I need to retrieve all the data in the data set in csv format or bring ...
8
votes
4answers
2k views

How to get response from stored procedure before it finishes?

I need to return partial result (as simple select) from a Stored procedure before it is finished. Is it possible to do that? If yes, how to do that? If not, any workaround? EDIT: I have several ...
3
votes
2answers
908 views

SQLCLR TVF that calls web service is getting error 401: Unauthorized

I am calling a web service from a SQLCLR TVF in SQL Server 2008 R2. On the IIS server this service has open permissions. When tested using GET or POST requests on a browser the web service works as ...