Re: DTS for Oracle through ODBC: Error Calling GetNextRows in Prev

Thank you for pointing that out, Allan. The driver was the problem. I'll post
my answer here in case anyone else needs to know what my particualr problem
was.

I found out the Oracle driver they had installed on my system was for Oracle
8. Which is fine - it's an Oracle 8 database. However, my system is running
on Windows XP. The Oracle 8 drivers were designed for NT. So while the Oracle
8 Client would work fine, the ODBC for some reason didn't agree with DTS.

I found out we had a a copy of Oracle 9i as well. I installed that client,
and connected to the Oracle 8 database fine with it. But with that, it also
allowed me to install a more recent Oracle Driver I downloaded from their
site (They have some odd way of installing things - you need a special
installer app in order to install their ODBC's.. Bleh).

This time it connected, and worked like a charm.

Just as a warning to all others with the problem - Check your drivers!

"Allan Mitchell" wrote:

Hello Adam,

I can think of a couple of things I would try

1. Make sure you are using the latest version of the driver.
2. Make sure that the name of the tables do not contain any funnies like
periods.




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hello again, everyone!

I'm attempting to create a DTS package to migrate data from our old
Oracle 8 system to SQL Server 2000.

I decided to use the Oracle ODBC provided in their client install. The
Microsoft ODBC Driver for Oracle, for some reason, doesn't see all the
tables when you attempt to proceed, although it does work fine on the
ones it can. (That's another question: Why can't it see them all? It
also, oddly enough, sees most of the "tables" as views.)

So the Oracle ODBC lets me see all the tables just fine. I selected
one to test, and select preview, and then I recieve the following
error:

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

So, my questions are these:

1) Has anyone ever encountered this error before? If so, how did you
reslove it?

2) Is there an update for the one provided by Microsoft that would let
me see all the tables?

Thanks for your help!




.

Relevant Pages

  • Adding new driver
    ... I tried to install the odbc driver of the oracle instant client. ... The entry disapeared from the odbc data source administrator. ...
    (microsoft.public.data.odbc)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... The oledb driver is not part of the 'standard' oracle client install ... > on our test web server, There is only one oracle home on the test server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: ORACLE DRIVER
    ... DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. ... DBD::Oracle - is the Oracle driver that DBI can use to handle oracle request. ...
    (perl.dbi.users)
  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • Re: Microfocus Netexpress question : COBSQL vs openESQL
    ... >couldnt connect with the oracle database specified in the program. ... It may be missing an ODBC driver and/or data source. ... You also need an entry for the data source in tnsnames.ora. ... precompiler directives to the precompiler and compiler directives to ...
    (comp.lang.cobol)