from Oracle to Access

Last Post 10 Aug 2007 08:47 AM by roma. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
roma
New Member
New Member

--
10 Aug 2007 07:12 AM
Hi, I try to copy some data from Oracle DB to Access using DTS.
I created connection and run simple select:
Select * into NewTbl from or_customer where customer_id=123.

DTS generate mean the 12560 error.
Please , help me to understand what is problem.

Thanks

Fatal NI connect error 12560:

VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production
Time: 10-AUG-2007 09:34:02
Tracing not turned on.
Tns error struct:
ns main err code: 12560
TNS-12560: TNSrotocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 126
nt OS err code: 0
roma
New Member
New Member

--
10 Aug 2007 08:47 AM
Yes, this machine has oracle client because I have an application which is call to Oracle and execute some sp.
On the first step I open OLE DB Oracle connection and Access connection.; than connect to each other using ‘transformation data Task’; than open
‘Execute task SQL ’ add select and run it.
You are not authorized to post a reply.

Acceptable Use Policy