Solved

MSSQL-ORACLE "Error calling GetNextRows"

Posted on 2001-06-06
9
404 Views
Last Modified: 2008-02-01
Hello:

When using the DTS wizard to import an Oracle table to a MSSQL DB, I get the following message at the time of previewing the Oracle table:

   Context: "Error calling GetNextRows".
   Your provider does not support all the interfaces/methods required by DTS.

Could someone help me with this?

Thanks.

Juarrero
0
Comment
Question by:juarrero
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 6159908
hi juarrero, if you want your question to appear in multiple topics, you can simply post a 0-point question in the additional topics, with a link like the following:
http://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20130721
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 200 total points
ID: 6159919
This said, we need some more info:
Version of SQL Server, Version Of Oracle,
How do you connect to Oracle (ODBC/OLEDB)

I assume that you use ODBC, and you should try OLEDB Provider instead...
Cheers
0
 
LVL 3

Expert Comment

by:sanjaykp
ID: 6160014
Angel's right. There have been issues with ODBC driver versions for Oracle.

If possible, use the Microsoft OLEDB provider for Oracle.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:juarrero
ID: 6160171
Hello:

The versions are:

   MSSQL 7, SP2
   Oracle 8.0.5

I am using the ODBC driver provided by Oracle in its client for WinNT

Thanks,

Juarrero
0
 

Author Comment

by:juarrero
ID: 6160316
Hello:

The versions are:

   MSSQL 7, SP2
   Oracle 8.0.5

I am using the ODBC driver provided by Oracle in its client for WinNT

Thanks,

Juarrero
0
 
LVL 3

Expert Comment

by:sanjaykp
ID: 6160354
Hi Juarrero,

Please refer to Angel's answer, and my comment. Use the Microsoft OLEDB provider for Oracle as your DTS connection.

Cheers
0
 
LVL 3

Expert Comment

by:mathavra
ID: 6160524
Try using the later version of Oracle provider or ODBC. The later Clients does work with Oracle 8.0.6. It is an option to try.

   Oracle8i Client Software 8.1.6
   Oracle Provider for OLE DB 8.1.6

The following items are also necessary:

   OLE DB SDK 2.1
   MDAC 2.1  

These can be obtained from the Microsoft web site below:
 
   www.microsoft.com/data/oledb

Additionally, if MTS is to be used, Oracle Services for Microsoft Transaction Server version 8.1.5.0.1 or later should be installed.

The Oracle Provider for OLE DB can run against Oracle Server Version 7.3.4 or later.

Mathav
0
 
LVL 3

Expert Comment

by:sanjaykp
ID: 6160578
Mathav,

Angel's solution should work.

What's the need for the SDK? Juarrero is not going to write his own OLE DB driver.

Also you should be updating your MDAC v2.1 to at least MDAC v2.6 at least.

Where is the reference to MTS?

Why are you complicating the issue?
0
 

Author Comment

by:juarrero
ID: 6289841
Hello,

I accept angellll's answer as he supplied the idea first.

I have installed and checked it and it runs.

Thanks everybody.

Juarrero
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS 2013 - Creating a summarized report 19 35
SSIS with VPN COnnection 2 77
SQL Improvement  ( Speed) 14 27
sql server tables from access 18 19
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question