by Samant » Fri, 20 Dec 2002 18:31:25
I am using DTS to extract data from a Oracle database which as about
17,000 tables and about 12,000 indexes. I am using the MS OLE-DB
provider for Oracle when I double click on the transform it takes more
than 10-15 minutes for the screen asking me for the query. If I access
a Oracle database that as 50 or so tables the MS OLEDB provider comes
out fast. Does this need a MDAC patch ?
Thanks
Samantha
by Euan Garden[MS » Fri, 20 Dec 2002 19:19:47
--
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
Quote:> Hi All
> I am using DTS to extract data from a Oracle database which as about
> 17,000 tables and about 12,000 indexes. I am using the MS OLE-DB
> provider for Oracle when I double click on the transform it takes more
> than 10-15 minutes for the screen asking me for the query. If I access
> a Oracle database that as 50 or so tables the MS OLEDB provider comes
> out fast. Does this need a MDAC patch ?
> Thanks
> Samantha
1. Unable to connect Oracle using the Microsoft OLE DB Provider for Oracle
I am unable to connect to my Oracle database (Oracle7 Server Release
7.3.3.0.0). When I try to test my connection I get the following error
message:
"Test connection failed because of an error in initializing provider. The
Oracle(tm) client and network components were not found. These components are
supplied by Oracle Corporation and are part of the Oracle Version 7.3.3. (or
greater) client software installation.
You will be unable to use this provider until these components have been
installed."
I have tried it using the Oracle 7.3.3 and Oracle 8.0 client software, both
didn't work. I am using: VB6 SP1, WinNT 4.0 SP3, SQL *Net Client 2.3.30.0,
Oracle Net8 Client 8.0.4.0.0 and Oracle TCP/IP adaper 2.3.30.0.
The 'Microsoft OLE DB Provider for ODBC Drivers' works fine.
Could somebody tell me what I am doing wrong?
Thanks,
Fons
3. Microsoft's slow Oracle OLE DB Provider
4. Undefined user-defined type
5. Microsoft's OLE DB Simple Provider 1.5 Library isn't cutting it :(
6. Problem in procedures with update from a float
7. Microsoft OLEDB provider or Oracle OLEDB provider
8. Oracle package equiv. in Sql Server 7.0
9. Can't connect to Oracle using MSDAORA OLE DB provider
10. Comparing OLE DB Providers for Oracle - Microsoft Vs Oracle Vs Merant
11. Problem with linked server using ADSDSOObject (OLE DB Provider for Microsoft Directory Services)
12. OpenQuery using OLE DB provider 'SQLOLEDB'