Share via

OLE DB Provider for DB2

Bilal H. Bhatt 136 Reputation points
2023-12-18T04:50:26.2066667+00:00

Hello,

We have an SQL instance running on Version SQL Server 2012. it has an SSIS package which is pulling the data from a DB2 database. this jobs is failing with below error.

"Error : the requested OLE DB Provider DB2OLEDB.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code 0x00000000."

I enabled the 32-Bit runtime for this job, but then it show the error

"If the 32-bit driver is not installed, run the package in 64-bit mode. Error code 0x00000000."

Please advise

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,492 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,296 Reputation points
    2023-12-18T05:54:21.9533333+00:00

    Hi @Bilal H. Bhatt,

    You may follow the documentation to install both 32bit and 64bit OLE DB Provider DB2OLEDB.

    https://learn.microsoft.com/en-us/host-integration-server/db2oledbv/installing-data-provider-version-6-0

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.