October 25, 2019 at 8:05 pm
Hello experts,
I'm posting this in SQL 2008 because that is the SQL Server version. But I think it is more a driver issue than a SQL 2008 issue.
A client reports the following error when trying to export data from SQL Server to Oracle:
SQL Server Import and Export Wizard
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
Additional information:
-> Provider cannot be found. It may not be properly installed. (ADODB.Properties)
The SQL version is:
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
The export option that the client chose is:
Destination: Oracle Provider for OLE DB
My noob question is: Is there a specific version of the Oracle provider that I need to install on this server? Or might there be some other issue going on?
Thanks for any help.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
October 26, 2019 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 29, 2019 at 2:49 pm
Bump, thx
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply