RE: ora-12170
Date: Tue, 1 Dec 2015 15:52:53 +0000
Message-ID: <65b7f360578b4630a941addd1399b9ad_at_wpvl1dag02.hcrec.com>
I've seen this same error when Access is trying to pull back too much information (especially when the Windows side is 32 bit rather than 64 bit). Have you tried testing against small tables?
Matt Adams
Trover Solutions
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Tuesday, December 01, 2015 9:27 AM To: oracle-l (oracle-l_at_freelists.org) Subject: ora-12170
I have a user who wants to connect from Access to Oracle. We created the System DSN for the connection. I am using the instant client for 12 on this machine. But when we test the connection or try and open it thru Access, we get ORA-12170 error, TNS: Connect timeout occurred. I've used this setup several times before without issue so what could be holding up this one pc? I googled and keep getting This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server type messages......
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you. **** This communication may contain privileged and/or confidential information. If you are not the intended recipient, you are hereby notified that disclosing, copying, or distributing of the contents is strictly prohibited. If you have received this message in error, please contact the sender immediately and destroy any copies of this document. ****
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 01 2015 - 16:52:53 CET