Jim Lawrence
accessd at shaw.ca
Tue Sep 18 15:36:52 CDT 2007
Jim, that is a very good recommendation. I try to run all my queries on the
server as that is what it does best, limits the downloads and let your
Access do what it does best; present information in a great user interface.
Jim
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Tuesday, September 18, 2007 11:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] {Accessd] ODBC driver to Oracle to enableAccess
queries
Actually I believe you are correct. My pass through queries use the IBM
client Access ODBC driver to return the data. The difference(at least in
my case) is that instead of sending a million record table down to
Access and then running the query to create a record set of 10,000
records, the pass through query runs on the AS400 and sends only the
result recordset down the line. This results in significantly fewer
problems.
Jim Hale
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, September 18, 2007 11:43 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] {Accessd] ODBC driver to Oracle to enableAccess
queries
Jim:
Isn't pass-through connections just ODBC?
With good routers at each end of the connections you should not have any
corruption. The banks use Cisco router and they have no lost packets...
The
Cisco router does the encryption, manages the network and monitors the
packet flow. If a packet drops it automatically requests a resend. Even
if a
remote server or connection goes down the router just re-routes to
another
connection and/or server.
This type of system takes all corruption concerns out of transactions.
Jim
***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com