AS/400 DB2 Access through SQL Server 2000

Hi,

I tried the way of adding a Linked Server.But DB2OLEDB provider is not listing on the

Provider Name combo box when i go to add it.Waht should I do?

In the Provider String there are two attributes call

Package Collection=MyPkgCol;

Default Schema=Schema;

What does it mean?

This is SQL I used.

EXEC sp_addlinkedserver

@.server = '10.1.0.7',

@.provider = 'DB2OLEDB',

@.srvproduct = '',

@.provstr = 'Provider=DB2OLEDB;Network Transport Library=TCPIP;Network

Address=100.1.0.27;Initial Catalog=Depani;User ID=gift;Password=gift;'

Any coding related to Please send me.

Thanks.

Pubudu

If you have any issue with DB2OLEDB provider then you can use the following Driver.

Note: Your Server need to have the DRIVER/PROVIDER. If it is not available you can get it from IBM-DB2 site.

Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;

|||

I have installed the AS400 DB2 client and Im having a provider call IBM AS400

OLEDB Provider.

I have used in this way

'Driver={IBM AS400 OLEDB Provider};Database=upul;Hostname=10.1.0.4;Port=23;Protocol=TCPIP;Uid=upul;Pwd=upul02;'

Please help me.

Thanks,

Pubudu

|||

Are you able to connect the server.

If not use the IBM's oledb provider..

Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP;Port=50000;Uid=myUsername;Pwd=myPassword;