O'Connor, Patricia (OTDA)
Patricia.O'Connor at otda.state.ny.us
Tue Sep 18 18:26:51 CDT 2007
The number one thing is use the ORACLE driver not the ms oracle driver!!! The ms driver does not seem to play with oracle as well. I have been using the ORACLE drivers for the last 7 years. I do both passthru and access queries. I tend to do more passthru because i do more complex and special subqueries.
The second thing is under PROPERTIES change the TIMEOUT (? i am not at work right now to check wording)
from 60 to 6000 or 600. I tend to use 6000. Otherwise the queries will bomb out after about 4 minutes even if it is simple. change it to a higher number and whallah it runs.
HTH
Patti
*************************************************************
* Patricia E. O'Connor
* Associate Computer Programmer/Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (W) mailto:aa1160 at otda.state.ny.us
***********************************************************
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.
________________________________
From: accessd-bounces at databaseadvisors.com on behalf of Jim Lawrence
Sent: Tue 09/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 <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 <http://www.databaseadvisors.com/>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>