Stack Overflow
Stack Overflow

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
3
votes
0 answers

ESB with DSS feature, how to use boxcarring?

I've installed the DSS 3.2.2 feature on ESB 4.8.1, and I can't use boxcarring, the session cookie cannot created after send begin_boxcar. I tried to change passthrough transport to nhttp, but no success. Is possible to use DSS feature with ESB…
Kleber Rocha
  • 85
  • 8
3
votes
1 answer

KVM - DMA with a passthrough device

I have several assumptions in mind please correct me if I'm wrong: Without a real IOMMU a DMA-Transfer would be a security risk, because a guest could transfer garbage in Host Memory. A valid DMA-Transfer between guest memory and passthrough device…
Max Mustermann
  • 351
  • 2
  • 12
3
votes
2 answers

access-SQL pass-through query (creating SP) error

I am trying to create a stored procedure using pass-through query in SQL Server 2012, using MS Access 2010. IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'SCHtest') EXECUTE sp_executesql N'create schema SCHtest' GO CREATE PROCEDURE…
edgarasb
  • 45
  • 6
2
votes
1 answer

MS Access Expressions in Pass-Through Query to Oracle DB

I am trying to create a Pass-through SQL statement from my MS Access 2003 (Yeah, I know it's oldschool but my hands are tied :/) to an Oracle DB on a Server. Long story short, the server-table contains freezer models, where each model exists 1 to 5…
ViggoV
  • 2,133
  • 2
  • 20
  • 22
2
votes
2 answers

Maximum Length of a SQL Query in Microsoft Access 2010?

Attempting to copy/paste a 159KB TSQL query into Microsoft Access 2010 passthrough query editor (to a Microsoft SQL Server 2008 backend). This produces pop-up error, "The text is too long to be edited". What is the maximum length of a query in…
iokevins
  • 1,427
  • 2
  • 19
  • 29
2
votes
1 answer

Why does an ms-access sql Pass Through not work in VBA

I am currently trying to write a select pass through query using VBA in Access 2016. If I use the manual option via the button Pass-Through and assign manually the dsn the following statement works. SELECT top 1 dat_Kunden.Kunden_Status FROM…
timo_vdw
  • 23
  • 4
2
votes
1 answer

Nodejs PassThrough Stream

I want to transmit an fs.Readstream over a net.Socket (TCP) stream. For this I use a .pipe. When the fs.Readstream is finished, I don't want to end the net.Socket stream. That's why I use readStream.pipe(socket, { end: false }) Unfortunately I…
Interface
  • 312
  • 3
  • 16
2
votes
1 answer

Virtualization with xHCI-IOV

I need some documents about it (must be detailed) and,is KVM support it???? If yes, how to enable it and use it? My goal is to virtualize intel usb controller(onboard 0000:00:14.0) and distribute it to 2 guests. Passthrough can only be used by 1…
SirTeddy
  • 61
  • 2
  • 4
2
votes
1 answer

Exec an SQL-Server 2008 stored-procedure from Access, passing a TABLE variable

I need to pass a table from Access to SQL-server and execute a stored-procedure. I'm using pass-through queries in Access to do this. My pass-through query: DECLARE @MyVar TABLE { ..... } INSERT INTO @MyVar SELECT * FROM…
MSpeed
  • 8,153
  • 7
  • 49
  • 61
2
votes
1 answer

Setting RowSource in Access with Pass through query

I have a list box name animal and the row source is set to the following code, in which the query "animal" is a pass through query. However, the list box does not populate with any animals. Note: if I run the query "animal" as a stand alone pass…
AlmostThere
  • 557
  • 1
  • 11
  • 26
2
votes
1 answer

How to execute SET IDENTITY_INSERT ON/OFF with a pass-through query from Access VBA?

I have an Access db which has several tables linked. Now I'ld like to execute SET IDENTITY_INSERT ON/OFF on those tables. I googled and found things like this Private mDb As Database Public Sub SetIdentityInsert(strTableName As String, strOnorOff As…
marc40000
  • 3,167
  • 9
  • 41
  • 63
2
votes
2 answers

SQL pass-through SAS/ SAS EG - return a table

Case: I want to run a SQL pass-through from SAS and I want an output in my work libary. Problem: The log tells me everything is fine but there is no dataset output? I am a big rookie on this area - please help. Proc sql; connect to odbc as mydb …
Jannick Mikkelsen
  • 121
  • 2
  • 15
2
votes
1 answer

Use function call in passthrough query?

I have a passthrough query in an Access 2010 application, which I'm using to call a stored procedure on a SQL Server backend. The stored procedure takes a parameter that I need to make dynamic. The problem is this: Execute spMyProc 'userName' works…
nwhaught
  • 1,562
  • 1
  • 15
  • 36
2
votes
1 answer

JSF Pass-Through Elements Causes Stray End Tags

In my JSF project, I am trying to use a JSF pass-through, to utilize HTML5-compatible markup, rather than a PrimeFaces component. But it seems to be causing extra closing tags for empty elements, like hr, img, br, that break my layout. Here is my…
mheppler9d
  • 169
  • 2
  • 2
  • 9
2
votes
3 answers

Squid+iptables: how do i allow https to pass-through and bypassing Squid?

Basically started with Squid and iptables today (google is your friend). This stuff is going to be the death of me. I have Squid3 setup on Ubuntu 9.04 server as Transparent Proxy. It works sweetly when i use the proxy-box as my default gateway etc.…
David 'the bald ginger'
  • 1,296
  • 3
  • 20
  • 38
1
2
3
…
12 13