Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [web-service]

16 questions
9
votes
4 answers

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 parts of the procedure. In the first part I calculate…
Bogdan Bogdanov
  • 1,163
  • 2
  • 18
  • 38
5
votes
1 answer

System.Web in SQL Server CLR Function

I have done some light research into this topic and I would like to know what are all the pro's and con's or enabling/registering this particular .dll within SQL Server? Back information - we are integrating with a third party application (not my…
Doug Coats
  • 349
  • 2
  • 10
4
votes
1 answer

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 directly into SQL Server. (Rows and columns, header…
William M Low
  • 41
  • 1
  • 2
3
votes
2 answers

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 expected. However, when the function calls the…
MauMen
  • 151
  • 4
3
votes
1 answer

How to store search keyword or browsing history in database

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 dont know how to do it. Is there any query or…
Shumail ansari
  • 31
  • 2
2
votes
1 answer

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 to keep the auditing code together with the CLR…
Jim P
  • 127
  • 1
  • 7
1
vote
0 answers

PostgreSQL: data retrieval from a private (authentication-based) RESTful web API using a foreign data wrapper

In some cases, one want to feed or populate some PostgreSQL database tables using data fetched from the web, e.g. through a RESTful API (serving JSON features). I've recently discovered foreign data wrappers and I'm not yet 100% used to them, but…
s.k
  • 414
  • 1
  • 9
  • 26
1
vote
1 answer

Is it good idea to invoke Web Service from the database function or trigger?

I am using PostgreSQL in my Web API project. I have created Web APIs using .net core. Now I have a situation, where I want to process the inserted or updated data and store the processed data in some other table. I was thinking to create a trigger…
Sunny
  • 145
  • 1
  • 9
1
vote
0 answers

How not to "naturalize" surrogate keys?

Don't naturalize surrogate keys. As soon as you display the value of a surrogate key to your end users, or worse yet allow them to work with the value (perhaps to search), you have effectively given the key business meaning. This in effect…
Paul Draper
  • 800
  • 7
  • 20
1
vote
1 answer

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 from VM1 to create a login on VM2. My thoughts were…
avidgamer
  • 33
  • 1
  • 6
1
vote
1 answer

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 procedure, 2. create an endpoint 3. create a web…
JohnG
  • 1,093
  • 2
  • 12
  • 27
0
votes
1 answer

Is it really possible to use SQL injection to change a database, or is this a scam?

A guy I know at college is claiming he can change his grades by gaining access to the database through an SQL inject, and can also gain access to all admin account privileges and records. The portal is accessed through outlook account and he did a…
Per
  • 11
0
votes
1 answer

Oracle 11gR2 - Dynamic Registration

Database version: Oracle 11gR2 We want to use DYNAMIC_REGISTRATION_LISTENER parameter with off option. Our listener.ora file like this: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =…
jrdba123
  • 29
  • 2
  • 12
0
votes
1 answer

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 situation of a web app that can no longer run on as a…
Jonesome Reinstate Monica
  • 3,489
  • 10
  • 40
  • 57
0
votes
1 answer

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

EXEC @hResult = sp_OAMethod @objectID, 'send', null, @requestBody IF @hResult <> 0 BEGIN EXEC sp_OAGetErrorInfo @objectID, @source OUT, @desc OUT SELECT hResult = convert(varbinary(4), @hResult), …
Alfaiz Ahmed
  • 136
  • 1
  • 4
1
2