Questions tagged [pass-through]

Pass-through is a method of database processing where one DBMS (or similar) connects to a different DBMS, and submits code to the second DBMS for processing, rather than retrieving most or all rows and filtering or processing on the first server.

Pass-through is a method of database processing where one DBMS (or similar) connects to a different DBMS, and submits code to the second DBMS for processing, rather than retrieving most or all rows and filtering or processing on the first server.

190 questions
10
votes
4 answers

Letting the mouse pass through Windows C++

I am working on an Win32 C++ application where I want to ignore the mouse events and let is pass through to the window beneath my window. Basically the window below mine will handle the mouse event. I would prefer not to send the mouse message using…
JoderCoder
  • 111
  • 1
  • 5
10
votes
3 answers

Is there a simple way to pass specific *named* PowerShell parameters through directly to a called function?

I am sure I read somewhere that there is an easy way to pass named parameters from a calling function to a called function without explicitly naming and specifying each parameter. This is more than just reusing the position; I'm interested in the…
John Weldon
  • 39,849
  • 11
  • 94
  • 127
7
votes
4 answers

How to make a passthrough / passthru query editable?

In the Microsoft Access 2007 with an SQL Server Backend, we usually take a linked table from the SQL Server as Form.RecordSource of an editable form for a single table data modification. A local query is used for cross tables editions that combines…
jacouh
  • 8,473
  • 5
  • 32
  • 43
6
votes
2 answers

SAS Pass-through SQL - Multiple DBs

I want to retrieve from DB2 the list of records that matches the identifiers in a DB1 table, like a regular SAS subquery. How can I perform that with SAS pass-through SQL? Performing the (long and complex) SQL on db1 is too slow using a regular SAS…
user1839897
  • 425
  • 1
  • 10
  • 14
5
votes
3 answers

Execute SQL Server Pass-Through Query From Access VBA

I have an UPDATE pass through query saved in Access 2007. When I double-click on the pass through query it runs successfully. How can I get this query to run from VBA? I'd like it to run when my "splash screen" loads. I'm currently using the…
mntyguy
  • 197
  • 2
  • 4
  • 18
5
votes
2 answers

Pass-through authentication not working. IIS 7

On IIS 7 I set up an application called "XYZ", and an application pool for it. I set the identity of this application pool to a custom user, let's call it "Mario". Mario has NTFS access to the folder/files in which XYZ points to (remote share). In…
Naner
  • 1,292
  • 6
  • 25
  • 43
4
votes
0 answers

swiftUI modally (sheet) presented list doesn't work the second time

I am using beta 4 Xcode and simply have a list of string items that is modally presented from a main view. var body: some View { NavigationView { List { Section() { Button(action: { …
Congruent Tech. UG
  • 1,408
  • 2
  • 12
  • 21
4
votes
3 answers

Access VBA Parameter in passthrough query to SQL Server

I have several queries in an MS Access database. Some of these use parameters. I use the following code in VBA to provide the query with these parameters: VBA Dim startDate As Date Dim endDate As Date Dim dbs As DAO.Database Dim qdf As…
TheNiers
  • 237
  • 2
  • 4
  • 15
4
votes
3 answers

vfio_dma_map error when passthrough GPU using libvirt

here is the qemu log 2016-08-28T02:52:05.699498Z qemu-system-x86_64: -device vfio-pci,host=01:00.0,bus=root.1,addr=00.0,multifunction=on,x-vga=on: vfio_dma_map(0x7f67ea3b3e10, 0x100000, 0xbff00000, 0x7f6651d00000) = -12 (Cannot allocate…
SirTeddy
  • 61
  • 2
  • 4
4
votes
3 answers

Implement Pass-Through Authentication in C#

I am developing a TcpClient/TcpListener based client-server application. Now I have come to the point where I need to authenticate the user. I could use the PrincipalContext-Class on the server side and request username/password/domain from the…
nikeee
  • 10,248
  • 7
  • 40
  • 66
3
votes
1 answer

reverse proxy with nginx ssl passthrough

I have several ISS Webservers hosting multiple web applications on each IIS server. The do have a public certificate on each system. Every IIS has an unique IP. All IIS Server are placed in the same DMZ I have setup an nginx System in another…
3
votes
2 answers

Return values from a pass-through query via VBA

I have VBA code to run a query in SQL-Server 2008. It runs fine and displays the table that I need. The code that does this is here: Set db = CurrentDb Set qdf = db.QueryDefs("MyStoredProcedure") qdf.SQL = "exec [WCNS_Ops].[dbo].MyStoredProcedure…
MSpeed
  • 8,153
  • 7
  • 49
  • 61
3
votes
4 answers

MS Access pass through dependent on form value

How do I assign a pass-through query to Row Source that is dependent on another value in the form? Essentially I want to do this: SELECT x.companyid, x.companyname, x.productid FROM x WHERE (((x.CompanyID) =…
3
votes
4 answers

SAS explicit pass-through with --comments converts to single line

It appears that when performing an explicit pass-through with SAS, the text is not delivered to the server in the same manner that it is laid out within the editor or .sas file itself. SAS appears to be delivering the text all on a single line. This…
Joshua Schlichting
  • 3,110
  • 6
  • 28
  • 54
3
votes
1 answer

Changing connection params when using pass-through query

I have an Access 2003 application that I would like to create reports for using stored procedures via pass-through queries. Everything works fine with one exception. When I specify the stored procedure to use for the pass-through query I have to…
webworm
  • 10,587
  • 33
  • 120
  • 217
1
2 3
12 13