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!

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

Maybe the problem is with the Oracle user for that connection which doesn't
have enough permissions.
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)


"Adam St. Pierre" wrote:

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: