AS/400 DB2 Driver

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;

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;

AS 2005 Slowly Changing Dimension - adding new rows when no change

Hi , I am using the Integration Services slowly changing dimension to move data from a SQL Server 2000 database table to a SQL Server 2005 table.

The other problem is the package is not tracking changes it is spending a lot of time doing lookups (it's slow), but ends up creating new records when there has not been a change.

I'm quite sure the business key is set up correctly (I'm using the PK from the source table).

The database I am transferring from has non Unicode data types (ie varchar and char) and the destination database has Unicode data types (ie nvarchar).

Also some of the fields in the dB are NULL - does this have an effect (ie one null doesn't equal another null)? Or shouldn't that matter?sorted out his issue

http://forums.microsoft.com/MSDN/showpost.aspx?postid=1475782&siteid=1