Jim Lawrence
accessd at shaw.ca
Tue Sep 18 12:36:31 CDT 2007
Hi John: You are right; the Bound type applications do not work well in this environment. If you are using an ADO connection the ConnectionTimeout property can be set very high in the event of unstable connections. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, September 18, 2007 9:53 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] {Accessd] ODBC driver to Oracle to enableAccess queries 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com