Problems with MS OLE DB Provider for IBM DB2

Hi,

I am using MS SQL Server Developer's Edition.
I have downloaded the MS OLE DB Provider for IBM DB2.

However, when I am trying to create a connection to the IBM DB2 source in my SSIS Package, I am getting the following error:

Code Snippet

TITLE: Connection Manager

Test connection failed because of an error in initializing provider. The parameter is incorrect.

Any idea as to what could be the problem with this?

Thanks and Regards,
B@.ns

As I said in the other post 'ibm db2 as datasource': you still need the IBM client-access software to access the IBM DB2 databases. The Microsoft db2 provider is only a layer on top of that.|||

AVNIP,

Are you trying to connect to IBM DB on AS/400?

If yes, I can provide you the detailed steps how to configure the MS OLE DB provider for DB2

Regards,

Yitzhak

|||

Jan DHondt wrote:

As I said in the other post 'ibm db2 as datasource': you still need the IBM client-access software to access the IBM DB2 databases. The Microsoft db2 provider is only a layer on top of that.

I don't believe this is true. It isn't like the Oracle driver.|||

Phil is absolutely right.

Single MS OLE DB provider for DB2 supports multiple platforms:

- DB2/6000

- DB2/AS400

- DB2/MVS

- DB2/NT

The provider doesn't need anything else installed to work properly.

Regards,

Yitzhak

|||

Phil,

I have been using ibm iseries db2 and you need a client licence before the server will give you access. so it is a lot like Oracle. I had installed microsoft provider for db2 and connections did not work. I installed ibm series client and it did work with the microsoft provider after that. I think the server side checks if you have a valid licence to connect.

Maybe IBM licencing system is different on the servers that I have to work with.

|||

Jan DHondt wrote:

Phil,

I have been using ibm iseries db2 and you need a client licence before the server will give you access. so it is a lot like Oracle. I had installed microsoft provider for db2 and connections did not work. I installed ibm series client and it did work with the microsoft provider after that. I think the server side checks if you have a valid licence to connect.

so it is probably like Oracle.

We don't have the DB2 drivers installed on our servers and the Microsoft DB2 for OLE DB drivers work fine.|||

The Microsoft OLE DB Provider for DB2 is based on technology available in Microsoft Host Integration Server 2006.

That's why it is self-sufficient and doesn't need anything else to be installed to work.

It just needs the following (directlt from the readme file):

"...The Microsoft OLE DB Provider for DB2 is for use exclusively with Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Developer Edition and Microsoft SQL Server 2005 Evaluation Copy...."

Regards,

Yitzhak