[AccessD] {Accessd] ODBC driver to Oracle to enableAccess queries

jwcolby jwcolby at colbyconsulting.com
Tue Sep 18 11:52:53 CDT 2007


I think it is Access corruptions that are the issue.  Access is finicky when
its connections don't answer up in time.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Tuesday, September 18, 2007 12:43 PM
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

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




More information about the AccessD mailing list