Solved

MSSQL-ORACLE "Error calling GetNextRows"

Posted on 2001-06-06
9
407 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 143

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 143

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 27
SQL, add where clause 5 24
sql server query 12 26
Transact SQL - Frequency of Length of Distinct Values 3 26
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

830 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