ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am trying to test your software, but I am having problems retrieving rows from a
oracle database.I can only retrieve 100 rows of info.
I do not know if its because I need the license or its a bug in the software.
please answer me asap..

Adrian

It woul be great to know which software you are talking about and version of oracle

Mike

Visual Importer
Oracle 9i

Adrian

Please can you also provide us the following information

1. Import script
2. Error log
3. Example of your data
4. script to create tables
5. What version VImp are you using?
6. Version of operating system
7. Exact versions of the database and odbc drivers.

Mike

Hi,

this is the sqlnet.log:

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program
Files\DB Software
Laboratory\VImp.exe)(HOST=MACLEE-D096CFF8)(USER=Administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 -
Production
Time: 15-MAR-2004 16:27:03
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:protocol 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

the database are 2 oracle 9i that im trying to transfer the data from one to
the other one. i have been succesfull but only with 100 rows. it wont load any
more.

op: windows 2003 server
drivers: are the ones that come with oracle version 9.2.0.1.0

please help.

thank you

Hi.

We have just loaded data from oracle odbc source into oracle database
(9.2.0.4), 10000 records.

The only difference we can see that we used TCP/IP protocol instead
of BEQ.

Can you try to use TCP/IP and let us know the outcome

There are alot of articles in the internet about error 12560
People having probles like 'Our aplication works fine for a while
than it suddenly disconnects from the database'

www.orafaq.com/msgboard/server/messages/21218.htm

do you have access to oracle metalink?

I think problem with BEQ was fixed in patch 9.2.0.3

Mike
DB Software Laboratory