pass-through

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 case where the name of the passed parameters is the same in some cases, but not in others. ...

MS Access, Pass through query with complex criteria. Criteria include Select statments and vba functions.

I currently have multiple queries that query data from a few tables linked through ODBC, and some temporary tables that are edited through the user interface. I have complex criteria in my queries such as: SELECT * from ThingsData WHERE (Thing In(SELECT Thing from ListOfThings) AND getThingFlag() = True); In this case Thing is a field...

Access 2007 pass-through query returning negative number instead of positive

I am using Access 2007 with a pass-through query. The data values that I am retrieving are from a bit column (0, 1) but when the pass-through query runs the data that is returned is either 0 or -1. I am calling a stored procedure on my SQL database for this pass-through query, this stored procedure works and returns the positive bit numb...

Webservice Passthrough FrontEnd -> BackEnd

Hi, We got a Citrix Environment with some databases, a frontend netwerk with local machines and a backend network on a shared AD-Domain. The frontend-servers cannot access the database-servers in the backend. I would like to build a webservice in the backend to access some data on the database-servers. On the frontend, I would like to...

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

Hello, 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. The iptable rules for this setup was part of the tutorial. :P I can unfortunatel...

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 choose a DSN to provide the database connection info. I need to be able to change the connect...

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 { .....<variables> } INSERT INTO @MyVar SELECT * FROM [MyTable] EXEC sproc_test @Myvar My stored-procedure: ALTER PROCEDURE [dbo].[sproc_test] @M...