[AccessD] {Accessd] ODBC driver to Oracle to enable Access 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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Tuesday, September 18, 2007 8:20 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] {Accessd] ODBC driver to Oracle to enable Access
queries


ODBC connections over long distances has never worked for me- too slow
and prone to corruption. Pass through queries, OTOH, have always worked
well for me since the heavy lifting is done on the host machine and only
the result set is delivered to Access.

Jim Hale 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Morrill
Sent: Tuesday, September 18, 2007 9:49 AM
To: Accessd at databaseadvisors.com
Subject: [AccessD] {Accessd] ODBC driver to Oracle to enable Access
queries

 9-18-07

I have a client who wishes to link up to Oracle databases in several US
cities. These hookups would be up to 1000 miles from his office.   He
wants
to use an Access ODBC driver via the Internet to enable Access querying.
He
has asked me to check this out as to the whys and wherefores.


Help!!!!!.   Is it possible to do this?  Any books/articles on this
topic?

Thanks in advance,

Bill
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
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