IBM Universe Database

My company has an IBM Universe database that i would like to connect to via SSIS. Is this possible? If so, please point me in the right direction. I managed to find the U2 tools on the IBM website but i am a bit confused as to what i need to do.

Thanks

In order to load data to/from other data sources into SSIS, you'd need OleDB, ADO.NET or ODBC (supported via the .NET-ODBC bridge) connectors. Microsoft doesn't have a connector for UniVerse, but have you checked with IBM or its vendors?

|||IBM has ADO.NET Provider called "IBM Data Server Provider for .NET" and "IBM Database Add-ins".

Please try the above product.

Please read this article
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0711kumar/

IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379008&SiteID=1

Thanks

sql

IBM SDK

When connecting to an INFORMIX database with SQL Servers Linked Server tool, the ifxoledbc.dll (which is part of IBM's SDK) is used. Which version of IBM's SDK and the ifxoledbc.dll work with SQL Server 2005 and Informix Dynamic Server 7.3? I'm getting an the following error (confidential is the artificial name of my linked server):

Msg 7302, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot create an instance of OLE DB provider "Ifxoledbc" for linked server "CONFIDENTIAL".

I'm using SQL SERVER 2005 and I'm trying to connect to a INFORMIX Dynamic Server 7.3 through a linked server.

Do I need an update with IBM's SDK or am I not set-up properly?

Thanks,

Matt

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379008&SiteID=1

Thanks

IBM Informix Ole Db Provider

Hello,

I'm getting the below errors when using sql server's data import wizard. Please Note: My test connection was successful and the error occurs when I click the "Next" button after closing the properties window. For Security reasons I've filled the User Id and DataSource with a bogus account, database, and server i.e. xxxx. Notice the password is blank?... Is that normal? I'm in a jam and appreciate your help.

Thanks,

Matt

===================================

Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=xxx;Data Source=xxx@.xxxx". (SQL Server Import and Export Wizard)

===================================

IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)

Program Location:

at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.LoadTypeData(OleDbConnection myDestConnection)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.CacheDataSourceInfo(IDbConnection myConnection)

Moving to the "SQL Server Integration Services", which deals with data transformation issues.

|||

This means your OLE DB provider does not publish Provider_Types schema. The wizard relies on this schema to map data types between heterogeneous data sources.

You may want to try to build your SSIS package manually using OLE DB Source to access your Informix database.

Thanks.

|||

Hello,

Does your solution apply to the linked server as well? Any chance you know if SQL Server 2005 allows setting up an informix 7.3 db as a Linked Server? I now can connect with ADO.NET 2.0 using the IBM.Data.Informix namespace but have not been able to find any documentation on setting up connection through a linked server. FYI, I now have to correct IBM SDKs installed (2.9).

Thanks,

Matt

|||

I am having the same problem. Is there a way to get SQL server 2005 to talk to the Informix 7.3 engine? I get the following error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Ifxoledbc" for linked server "MINNYME2" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "MINNYME2".

|||

You are in luck. I'm currently still looking into this but have done a significant grind and configured the connection with ODBC. How are you connecting? With the Informix OLEDB? I'm currently waiting for the AIX admin to set something up on the server. He has to run a few scripts to set up the OLEDB properly. I found a page on IBM's site with significant documentation. Please see below. I believe I know what is wrong with my OLEDB connection, it is the set-up. I have a working ODBC now and can help you with that if need be.

http://www-306.ibm.com/software/data/informix/pubs/library/csdk_29.html

Regards,

Matt

|||

Yes, I am connecting using Informix OLE DB. I tried create a linked server with SQL Server 2005 with the IBM Informix OLE DB Provider. Here is my connection info. Did specify something wrong? It seems you abandoned this approach. Should I do the same and try to link the server with ODBC?

/****** Object: LinkedServer [MINNYME5] Script Date: 05/02/2006 11:10:06 ******/

EXEC master.dbo.sp_addlinkedserver @.server = N'MINNYME5', @.srvproduct=N'Informix-CLI 2.9 (32 bit)', @.provider=N'Ifxoledbc', @.datasrc=N'bsco@.becton_tcp', @.provstr=N'server=bsco@.becton_tcp;database=bsco;uid=informix;password=tewwetca'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'collation compatible', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'data access', @.optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'dist', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'pub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'rpc', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'rpc out', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'sub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'connect timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'collation name', @.optvalue=null

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'lazy schema validation', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'query timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'use remote collation', @.optvalue=N'true'

|||

Here is the code to set up the ODBC linked server. Please read the comments and notes provided throughout. I can help you further if need be. Just so we are on the same page, I'm using

OS: Windows XP Pro.

DotNet Framework: .NET SDK 1.1

IBM software development kit version: IBM CSDK 2.9

Good Luck!

EXEC sp_addlinkedserver

@.server = 'yourServer', -- defined in SetNet32 on tab 'Server information', -- field 'Informix Server'

@.provider = 'MSDASQL', -- DO NOT CHANGE !

@.datasrc = 'yourOdbcConnectionName', -- name of the ODBC connection defined in your system. (you must configure this.)

@.srvproduct = 'Informix-CLI 3.30 (32 bit)',

@.provstr = 'Host=yourHost;Server=yourServer;Service=yourService;Protocol=olsoctcp;Database=yourDB;UID=yourUIDToConnectToAIX;PWD=yourPWD'

NOTE: I'm not 100% sure if a login is needed but i created one.

EXEC sp_addlinkedsrvlogin 'yourLinkedServer', 'false', 'yourWindowsXPUserID', 'yourUIDToConnectToAIX', 'yourPassword'

READ-You need to set up permission for the UserId connecting to the AIX server in the AIX server. I had a AIX admin set me up considering I know little about IBM products.

Run the following query from SQL SERVER to query an ODBC linked server:

SELECT * FROM OPENQUERY(yourLinkedServer, 'select * from yourTable')

|||i done that , but cant insert into linked server tables and this error happens
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
[OLE/DB provider returned message: Query cannot be updated because the FROM clause is not a single simple table name.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x8000ffff: The provider reported an unexpected catastrophic failure.].
do u know why?

|||

Although I have never tried inserting a row into an Informix Linked Server, I'd assume that it is not possible considering I've seen similar results with other data sources.

|||thank you for replying
also i cant set linked server with oledb informix
when setup linked server with odbc can update, delete and select from linked table but only cant insert into the table

IBM Informix Ole Db Provider

Hello,

I'm getting the below errors when using sql server's data import wizard. Please Note: My test connection was successful and the error occurs when I click the "Next" button after closing the properties window. For Security reasons I've filled the User Id and DataSource with a bogus account, database, and server i.e. xxxx. Notice the password is blank?... Is that normal? I'm in a jam and appreciate your help.

Thanks,

Matt

===================================

Cannot get the supported data types from the database connection "Provider=Ifxoledbc;Password=;Persist Security Info=True;User ID=xxx;Data Source=xxx@.xxxx". (SQL Server Import and Export Wizard)

===================================

IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002).
IErrorInfo.GetDescription failed with E_NOINTERFACE(0x80004002). (System.Data)

Program Location:

at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions)
at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.LoadTypeData(OleDbConnection myDestConnection)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.CacheDataSourceInfo(IDbConnection myConnection)

Moving to the "SQL Server Integration Services", which deals with data transformation issues.

|||

This means your OLE DB provider does not publish Provider_Types schema. The wizard relies on this schema to map data types between heterogeneous data sources.

You may want to try to build your SSIS package manually using OLE DB Source to access your Informix database.

Thanks.

|||

Hello,

Does your solution apply to the linked server as well? Any chance you know if SQL Server 2005 allows setting up an informix 7.3 db as a Linked Server? I now can connect with ADO.NET 2.0 using the IBM.Data.Informix namespace but have not been able to find any documentation on setting up connection through a linked server. FYI, I now have to correct IBM SDKs installed (2.9).

Thanks,

Matt

|||

I am having the same problem. Is there a way to get SQL server 2005 to talk to the Informix 7.3 engine? I get the following error:

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Ifxoledbc" for linked server "MINNYME2" reported an error. The provider did not give any information about the error.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "MINNYME2".

|||

You are in luck. I'm currently still looking into this but have done a significant grind and configured the connection with ODBC. How are you connecting? With the Informix OLEDB? I'm currently waiting for the AIX admin to set something up on the server. He has to run a few scripts to set up the OLEDB properly. I found a page on IBM's site with significant documentation. Please see below. I believe I know what is wrong with my OLEDB connection, it is the set-up. I have a working ODBC now and can help you with that if need be.

http://www-306.ibm.com/software/data/informix/pubs/library/csdk_29.html

Regards,

Matt

|||

Yes, I am connecting using Informix OLE DB. I tried create a linked server with SQL Server 2005 with the IBM Informix OLE DB Provider. Here is my connection info. Did specify something wrong? It seems you abandoned this approach. Should I do the same and try to link the server with ODBC?

/****** Object: LinkedServer [MINNYME5] Script Date: 05/02/2006 11:10:06 ******/

EXEC master.dbo.sp_addlinkedserver @.server = N'MINNYME5', @.srvproduct=N'Informix-CLI 2.9 (32 bit)', @.provider=N'Ifxoledbc', @.datasrc=N'bsco@.becton_tcp', @.provstr=N'server=bsco@.becton_tcp;database=bsco;uid=informix;password=tewwetca'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'collation compatible', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'data access', @.optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'dist', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'pub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'rpc', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'rpc out', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'sub', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'connect timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'collation name', @.optvalue=null

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'lazy schema validation', @.optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'query timeout', @.optvalue=N'0'

GO

EXEC master.dbo.sp_serveroption @.server=N'MINNYME5', @.optname=N'use remote collation', @.optvalue=N'true'

|||

Here is the code to set up the ODBC linked server. Please read the comments and notes provided throughout. I can help you further if need be. Just so we are on the same page, I'm using

OS: Windows XP Pro.

DotNet Framework: .NET SDK 1.1

IBM software development kit version: IBM CSDK 2.9

Good Luck!

EXEC sp_addlinkedserver

@.server = 'yourServer', -- defined in SetNet32 on tab 'Server information', -- field 'Informix Server'

@.provider = 'MSDASQL', -- DO NOT CHANGE !

@.datasrc = 'yourOdbcConnectionName', -- name of the ODBC connection defined in your system. (you must configure this.)

@.srvproduct = 'Informix-CLI 3.30 (32 bit)',

@.provstr = 'Host=yourHost;Server=yourServer;Service=yourService;Protocol=olsoctcp;Database=yourDB;UID=yourUIDToConnectToAIX;PWD=yourPWD'

NOTE: I'm not 100% sure if a login is needed but i created one.

EXEC sp_addlinkedsrvlogin 'yourLinkedServer', 'false', 'yourWindowsXPUserID', 'yourUIDToConnectToAIX', 'yourPassword'

READ-You need to set up permission for the UserId connecting to the AIX server in the AIX server. I had a AIX admin set me up considering I know little about IBM products.

Run the following query from SQL SERVER to query an ODBC linked server:

SELECT * FROM OPENQUERY(yourLinkedServer, 'select * from yourTable')

|||i done that , but cant insert into linked server tables and this error happens
OLE DB provider 'MSDASQL' reported an error. The provider reported an unexpected catastrophic failure.
[OLE/DB provider returned message: Query cannot be updated because the FROM clause is not a single simple table name.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x8000ffff: The provider reported an unexpected catastrophic failure.].
do u know why?

|||

Although I have never tried inserting a row into an Informix Linked Server, I'd assume that it is not possible considering I've seen similar results with other data sources.

|||thank you for replying
also i cant set linked server with oledb informix
when setup linked server with odbc can update, delete and select from linked table but only cant insert into the table

IBM DB2 UDB for iSeries .NET data provider

Hello:
Is it possible to import "IBM DB2 UDB for iSeries .NET data provider" into
Reporting Services 2005? I tried to do it but was unsuccessful. I'm
attempting to access data on our IBM i-Series(AS/400) and I need to pass
parameters in my datasets. I appreciate any assistance you can give me.
Best regardsYou can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
The OleDB driver should come with your iSeries Access installer. The IBM
DB2 UDB provider is not specific to DB/400 though whereas the one provided
with iSeries Access is. I've encounter a few oddities when using the
regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
OleDB provider which can be found here:
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
69484/DB2OLEDB.exe
If you don't use OleDB or ODBC as your connection provider you will have to
create a Reporting Services Data Extension to have the .NET DB2 Provider
show up in the list.
Here are some links to example OleDB connection strings for DB2 / DB/400
you can try:
http://www.connectionstrings.com/?carrier=ibmdb2
http://www.connectionstrings.com/?carrier=as400
The connection string for the Microsoft DB2 provider should be included in
the download.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> Subject: IBM DB2 UDB for iSeries .NET data provider
> Date: Tue, 2 Oct 2007 10:50:02 -0700
> Hello:
> Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
into
> Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> attempting to access data on our IBM i-Series(AS/400) and I need to pass
> parameters in my datasets. I appreciate any assistance you can give me.
> Best regards
>|||Thanks Chris, I'll give it a whirl.
"Chris Alton [MSFT]" wrote:
> You can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
> The OleDB driver should come with your iSeries Access installer. The IBM
> DB2 UDB provider is not specific to DB/400 though whereas the one provided
> with iSeries Access is. I've encounter a few oddities when using the
> regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
> OleDB provider which can be found here:
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> 69484/DB2OLEDB.exe
> If you don't use OleDB or ODBC as your connection provider you will have to
> create a Reporting Services Data Extension to have the .NET DB2 Provider
> show up in the list.
> Here are some links to example OleDB connection strings for DB2 / DB/400
> you can try:
> http://www.connectionstrings.com/?carrier=ibmdb2
> http://www.connectionstrings.com/?carrier=as400
> The connection string for the Microsoft DB2 provider should be included in
> the download.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > Subject: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 2 Oct 2007 10:50:02 -0700
> >
> > Hello:
> >
> > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> into
> > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > attempting to access data on our IBM i-Series(AS/400) and I need to pass
> > parameters in my datasets. I appreciate any assistance you can give me.
> >
> > Best regards
> >
> >
>|||Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
Provider to work with Reporting Services. I downloaded the DB2OLEDB provider
from Microsoft but it looks like it is only for the Enterprise edition which
we do not have. I wrote a C# program and I used the IBM DB2 UDB provider and
it worked fine. I keep getting an error "Object reference not set to an
instance of an object.
"Chris Alton [MSFT]" wrote:
> You can use the OleDB provider instead of the .NET for DB2 and/or DB/400.
> The OleDB driver should come with your iSeries Access installer. The IBM
> DB2 UDB provider is not specific to DB/400 though whereas the one provided
> with iSeries Access is. I've encounter a few oddities when using the
> regular DB2 driver pointing to DB/400. You can also try the Microsoft DB2
> OleDB provider which can be found here:
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> 69484/DB2OLEDB.exe
> If you don't use OleDB or ODBC as your connection provider you will have to
> create a Reporting Services Data Extension to have the .NET DB2 Provider
> show up in the list.
> Here are some links to example OleDB connection strings for DB2 / DB/400
> you can try:
> http://www.connectionstrings.com/?carrier=ibmdb2
> http://www.connectionstrings.com/?carrier=as400
> The connection string for the Microsoft DB2 provider should be included in
> the download.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > Subject: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 2 Oct 2007 10:50:02 -0700
> >
> > Hello:
> >
> > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> into
> > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > attempting to access data on our IBM i-Series(AS/400) and I need to pass
> > parameters in my datasets. I appreciate any assistance you can give me.
> >
> > Best regards
> >
> >
>|||Have you tried the AS/400 specific OleDB driver? Also, have you tried
creating an ODBC DSN and using that for your connection?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
<kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> Date: Tue, 9 Oct 2007 12:59:00 -0700
> Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
> Provider to work with Reporting Services. I downloaded the DB2OLEDB
provider
> from Microsoft but it looks like it is only for the Enterprise edition
which
> we do not have. I wrote a C# program and I used the IBM DB2 UDB provider
and
> it worked fine. I keep getting an error "Object reference not set to an
> instance of an object.
>
> "Chris Alton [MSFT]" wrote:
> > You can use the OleDB provider instead of the .NET for DB2 and/or
DB/400.
> > The OleDB driver should come with your iSeries Access installer. The
IBM
> > DB2 UDB provider is not specific to DB/400 though whereas the one
provided
> > with iSeries Access is. I've encounter a few oddities when using the
> > regular DB2 driver pointing to DB/400. You can also try the Microsoft
DB2
> > OleDB provider which can be found here:
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > 69484/DB2OLEDB.exe
> >
> > If you don't use OleDB or ODBC as your connection provider you will
have to
> > create a Reporting Services Data Extension to have the .NET DB2
Provider
> > show up in the list.
> >
> > Here are some links to example OleDB connection strings for DB2 /
DB/400
> > you can try:
> > http://www.connectionstrings.com/?carrier=ibmdb2
> >
> > http://www.connectionstrings.com/?carrier=as400
> >
> > The connection string for the Microsoft DB2 provider should be included
in
> > the download.
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > >
> > > Hello:
> > >
> > > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> > into
> > > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > > attempting to access data on our IBM i-Series(AS/400) and I need to
pass
> > > parameters in my datasets. I appreciate any assistance you can give
me.
> > >
> > > Best regards
> > >
> > >
> >
> >
>|||Chris, I have a better question. Why can't Microsoft make 2005 SQL Reporting
Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine with
the Driver? The Drivers are a part of IBM Client Access and I have the
latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I did
make the connection work with ODBC but as you know it is slower than OLEDB.
Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL Server
2005? If you have the name or a link to the AS/400 specific OleDB driver you
are talking about that would be great.
Steve!
"Chris Alton [MSFT]" wrote:
> Have you tried the AS/400 specific OleDB driver? Also, have you tried
> creating an ODBC DSN and using that for your connection?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > X-WBNR-Posting-Host: 207.46.19.197
> > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE DB
> > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> provider
> > from Microsoft but it looks like it is only for the Enterprise edition
> which
> > we do not have. I wrote a C# program and I used the IBM DB2 UDB provider
> and
> > it worked fine. I keep getting an error "Object reference not set to an
> > instance of an object.
> >
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You can use the OleDB provider instead of the .NET for DB2 and/or
> DB/400.
> > > The OleDB driver should come with your iSeries Access installer. The
> IBM
> > > DB2 UDB provider is not specific to DB/400 though whereas the one
> provided
> > > with iSeries Access is. I've encounter a few oddities when using the
> > > regular DB2 driver pointing to DB/400. You can also try the Microsoft
> DB2
> > > OleDB provider which can be found here:
> > >
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > 69484/DB2OLEDB.exe
> > >
> > > If you don't use OleDB or ODBC as your connection provider you will
> have to
> > > create a Reporting Services Data Extension to have the .NET DB2
> Provider
> > > show up in the list.
> > >
> > > Here are some links to example OleDB connection strings for DB2 /
> DB/400
> > > you can try:
> > > http://www.connectionstrings.com/?carrier=ibmdb2
> > >
> > > http://www.connectionstrings.com/?carrier=as400
> > >
> > > The connection string for the Microsoft DB2 provider should be included
> in
> > > the download.
> > >
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > >
> > > > Hello:
> > > >
> > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data provider"
> > > into
> > > > Reporting Services 2005? I tried to do it but was unsuccessful. I'm
> > > > attempting to access data on our IBM i-Series(AS/400) and I need to
> pass
> > > > parameters in my datasets. I appreciate any assistance you can give
> me.
> > > >
> > > > Best regards
> > > >
> > > >
> > >
> > >
> >
>|||There could be a lot of reasons why the DB2 UDB driver does not work with
Reporting Services. The driver could deviate from the OleDB spec or
countless other things. Without delving further into your problem (memory
dumps etc) I won't be able to give you much more information on it though.
You can find connection strings for the AS/400 specific OleDB provider here:
http://www.connectionstrings.com/?carrier=as400
Since you got the ODBC connection working why not at least use that in the
mean time while you try to get the OleDB working?
I'd contact IBM and see if they can give you a hand or if you need this
done quicker you can always open up a support case with us and that will
get your issue resolved much faster.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> Chris, I have a better question. Why can't Microsoft make 2005 SQL
Reporting
> Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine
with
> the Driver? The Drivers are a part of IBM Client Access and I have the
> latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I
did
> make the connection work with ODBC but as you know it is slower than
OLEDB.
> Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
Server
> 2005? If you have the name or a link to the AS/400 specific OleDB driver
you
> are talking about that would be great.
> Steve!
> "Chris Alton [MSFT]" wrote:
> > Have you tried the AS/400 specific OleDB driver? Also, have you tried
> > creating an ODBC DSN and using that for your connection?
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > X-WBNR-Posting-Host: 207.46.19.197
> > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE
DB
> > > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> > provider
> > > from Microsoft but it looks like it is only for the Enterprise
edition
> > which
> > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
provider
> > and
> > > it worked fine. I keep getting an error "Object reference not set to
an
> > > instance of an object.
> > >
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > You can use the OleDB provider instead of the .NET for DB2 and/or
> > DB/400.
> > > > The OleDB driver should come with your iSeries Access installer.
The
> > IBM
> > > > DB2 UDB provider is not specific to DB/400 though whereas the one
> > provided
> > > > with iSeries Access is. I've encounter a few oddities when using
the
> > > > regular DB2 driver pointing to DB/400. You can also try the
Microsoft
> > DB2
> > > > OleDB provider which can be found here:
> > > >
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > 69484/DB2OLEDB.exe
> > > >
> > > > If you don't use OleDB or ODBC as your connection provider you will
> > have to
> > > > create a Reporting Services Data Extension to have the .NET DB2
> > Provider
> > > > show up in the list.
> > > >
> > > > Here are some links to example OleDB connection strings for DB2 /
> > DB/400
> > > > you can try:
> > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > >
> > > > http://www.connectionstrings.com/?carrier=as400
> > > >
> > > > The connection string for the Microsoft DB2 provider should be
included
> > in
> > > > the download.
> > > >
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > >
> > > > > Hello:
> > > > >
> > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
provider"
> > > > into
> > > > > Reporting Services 2005? I tried to do it but was unsuccessful.
I'm
> > > > > attempting to access data on our IBM i-Series(AS/400) and I need
to
> > pass
> > > > > parameters in my datasets. I appreciate any assistance you can
give
> > me.
> > > > >
> > > > > Best regards
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>|||Chris,
I am currently using the ODBC connection but I would like to get
this issue resolved because I know there are many DB2 shops that would like
to use Reporting Services but they are having the same issue. Can I get the
Microsoft OLE DB Driver for DB2 for the Standard Edition of SQL
Server 2005?
Thanks!
"Chris Alton [MSFT]" wrote:
> There could be a lot of reasons why the DB2 UDB driver does not work with
> Reporting Services. The driver could deviate from the OleDB spec or
> countless other things. Without delving further into your problem (memory
> dumps etc) I won't be able to give you much more information on it though.
> You can find connection strings for the AS/400 specific OleDB provider here:
> http://www.connectionstrings.com/?carrier=as400
> Since you got the ODBC connection working why not at least use that in the
> mean time while you try to get the OleDB working?
> I'd contact IBM and see if they can give you a hand or if you need this
> done quicker you can always open up a support case with us and that will
> get your issue resolved much faster.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> >
> > Chris, I have a better question. Why can't Microsoft make 2005 SQL
> Reporting
> > Services Work with the DB2 UDB Driver if Visual Studio 2005 works fine
> with
> > the Driver? The Drivers are a part of IBM Client Access and I have the
> > latest version V5R4 and this driver is the specific AS400 OLEDB Driver. I
> did
> > make the connection work with ODBC but as you know it is slower than
> OLEDB.
> > Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
> Server
> > 2005? If you have the name or a link to the AS/400 specific OleDB driver
> you
> > are talking about that would be great.
> > Steve!
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > Have you tried the AS/400 specific OleDB driver? Also, have you tried
> > > creating an ODBC DSN and using that for your connection?
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > > X-WBNR-Posting-Host: 207.46.19.197
> > > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB OLE
> DB
> > > > Provider to work with Reporting Services. I downloaded the DB2OLEDB
> > > provider
> > > > from Microsoft but it looks like it is only for the Enterprise
> edition
> > > which
> > > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
> provider
> > > and
> > > > it worked fine. I keep getting an error "Object reference not set to
> an
> > > > instance of an object.
> > > >
> > > >
> > > > "Chris Alton [MSFT]" wrote:
> > > >
> > > > > You can use the OleDB provider instead of the .NET for DB2 and/or
> > > DB/400.
> > > > > The OleDB driver should come with your iSeries Access installer.
> The
> > > IBM
> > > > > DB2 UDB provider is not specific to DB/400 though whereas the one
> > > provided
> > > > > with iSeries Access is. I've encounter a few oddities when using
> the
> > > > > regular DB2 driver pointing to DB/400. You can also try the
> Microsoft
> > > DB2
> > > > > OleDB provider which can be found here:
> > > > >
> > >
> http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > > 69484/DB2OLEDB.exe
> > > > >
> > > > > If you don't use OleDB or ODBC as your connection provider you will
> > > have to
> > > > > create a Reporting Services Data Extension to have the .NET DB2
> > > Provider
> > > > > show up in the list.
> > > > >
> > > > > Here are some links to example OleDB connection strings for DB2 /
> > > DB/400
> > > > > you can try:
> > > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > > >
> > > > > http://www.connectionstrings.com/?carrier=as400
> > > > >
> > > > > The connection string for the Microsoft DB2 provider should be
> included
> > > in
> > > > > the download.
> > > > >
> > > > > --
> > > > > Chris Alton, Microsoft Corp.
> > > > > SQL Server Developer Support Engineer
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > > --
> > > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > > >
> > > > > > Hello:
> > > > > >
> > > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
> provider"
> > > > > into
> > > > > > Reporting Services 2005? I tried to do it but was unsuccessful.
> I'm
> > > > > > attempting to access data on our IBM i-Series(AS/400) and I need
> to
> > > pass
> > > > > > parameters in my datasets. I appreciate any assistance you can
> give
> > > me.
> > > > > >
> > > > > > Best regards
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > >
> > >
> >
>|||Unfortunately there isn't one to my knowledge. The DB2 provider is only for
Enterprise. Not sure why this is though.
I found an article that gives you an example of how to add the .NET data
provider though.
http://msdn2.microsoft.com/en-us/library/bb326409.aspx
and
This article that talks about data providers more in depth.
http://msdn2.microsoft.com/en-us/library/ms159219.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> thread-index: AcgME3y8WWy6aoDyQxmv6iFkPWLKRQ==> X-WBNR-Posting-Host: 207.46.193.207
> From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
<kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
<27152120-17C7-4C3C-8514-B778DF8C0267@.microsoft.com>
<8NOZs50CIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
<8A2566B0-4DBA-414F-A9A6-95D5B882A72A@.microsoft.com>
<$dmrTkADIHA.4200@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> Date: Thu, 11 Oct 2007 07:32:01 -0700
> Lines: 157
> Chris,
> I am currently using the ODBC connection but I would like to get
> this issue resolved because I know there are many DB2 shops that would
like
> to use Reporting Services but they are having the same issue. Can I get
the
> Microsoft OLE DB Driver for DB2 for the Standard Edition of SQL
> Server 2005?
> Thanks!
>
> "Chris Alton [MSFT]" wrote:
> > There could be a lot of reasons why the DB2 UDB driver does not work
with
> > Reporting Services. The driver could deviate from the OleDB spec or
> > countless other things. Without delving further into your problem
(memory
> > dumps etc) I won't be able to give you much more information on it
though.
> > You can find connection strings for the AS/400 specific OleDB provider
here:
> > http://www.connectionstrings.com/?carrier=as400
> >
> > Since you got the ODBC connection working why not at least use that in
the
> > mean time while you try to get the OleDB working?
> >
> > I'd contact IBM and see if they can give you a hand or if you need this
> > done quicker you can always open up a support case with us and that
will
> > get your issue resolved much faster.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > thread-index: AcgLUZfus8IJ/YLMRH2FGIETc13TfQ==> > > X-WBNR-Posting-Host: 207.46.19.168
> > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > >
> > > Chris, I have a better question. Why can't Microsoft make 2005 SQL
> > Reporting
> > > Services Work with the DB2 UDB Driver if Visual Studio 2005 works
fine
> > with
> > > the Driver? The Drivers are a part of IBM Client Access and I have
the
> > > latest version V5R4 and this driver is the specific AS400 OLEDB
Driver. I
> > did
> > > make the connection work with ODBC but as you know it is slower than
> > OLEDB.
> > > Can I get the Microsoft OLEDB Driver for the Standard Edition of SQL
> > Server
> > > 2005? If you have the name or a link to the AS/400 specific OleDB
driver
> > you
> > > are talking about that would be great.
> > > Steve!
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > Have you tried the AS/400 specific OleDB driver? Also, have you
tried
> > > > creating an ODBC DSN and using that for your connection?
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > thread-index: AcgKrtWvPTYjJjAlScKsEj3MWa53hw==> > > > > X-WBNR-Posting-Host: 207.46.19.197
> > > > > From: =?Utf-8?B?c3RldmU=?= <steve@.discussions.microsoft.com>
> > > > > References: <8DC06CC6-C70E-40E9-A3D3-302FEC6E5F6E@.microsoft.com>
> > > > <kmqs4WSBIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
> > > > > Subject: RE: IBM DB2 UDB for iSeries .NET data provider
> > > > > Date: Tue, 9 Oct 2007 12:59:00 -0700
> > > > > Chris, I am having the same issue. I cannot get the IBM DB2 UDB
OLE
> > DB
> > > > > Provider to work with Reporting Services. I downloaded the
DB2OLEDB
> > > > provider
> > > > > from Microsoft but it looks like it is only for the Enterprise
> > edition
> > > > which
> > > > > we do not have. I wrote a C# program and I used the IBM DB2 UDB
> > provider
> > > > and
> > > > > it worked fine. I keep getting an error "Object reference not set
to
> > an
> > > > > instance of an object.
> > > > >
> > > > >
> > > > > "Chris Alton [MSFT]" wrote:
> > > > >
> > > > > > You can use the OleDB provider instead of the .NET for DB2
and/or
> > > > DB/400.
> > > > > > The OleDB driver should come with your iSeries Access
installer.
> > The
> > > > IBM
> > > > > > DB2 UDB provider is not specific to DB/400 though whereas the
one
> > > > provided
> > > > > > with iSeries Access is. I've encounter a few oddities when
using
> > the
> > > > > > regular DB2 driver pointing to DB/400. You can also try the
> > Microsoft
> > > > DB2
> > > > > > OleDB provider which can be found here:
> > > > > >
> > > >
> >
http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f2
> > > > > > 69484/DB2OLEDB.exe
> > > > > >
> > > > > > If you don't use OleDB or ODBC as your connection provider you
will
> > > > have to
> > > > > > create a Reporting Services Data Extension to have the .NET DB2
> > > > Provider
> > > > > > show up in the list.
> > > > > >
> > > > > > Here are some links to example OleDB connection strings for DB2
/
> > > > DB/400
> > > > > > you can try:
> > > > > > http://www.connectionstrings.com/?carrier=ibmdb2
> > > > > >
> > > > > > http://www.connectionstrings.com/?carrier=as400
> > > > > >
> > > > > > The connection string for the Microsoft DB2 provider should be
> > included
> > > > in
> > > > > > the download.
> > > > > >
> > > > > > --
> > > > > > Chris Alton, Microsoft Corp.
> > > > > > SQL Server Developer Support Engineer
> > > > > > This posting is provided "AS IS" with no warranties, and
confers no
> > > > rights.
> > > > > > --
> > > > > > > Thread-Topic: IBM DB2 UDB for iSeries .NET data provider
> > > > > > > From: =?Utf-8?B?U3Rldmll?= <Stevie@.discussions.microsoft.com>
> > > > > > > Subject: IBM DB2 UDB for iSeries .NET data provider
> > > > > > > Date: Tue, 2 Oct 2007 10:50:02 -0700
> > > > > > >
> > > > > > > Hello:
> > > > > > >
> > > > > > > Is it possible to import "IBM DB2 UDB for iSeries .NET data
> > provider"
> > > > > > into
> > > > > > > Reporting Services 2005? I tried to do it but was
unsuccessful.
> > I'm
> > > > > > > attempting to access data on our IBM i-Series(AS/400) and I
need
> > to
> > > > pass
> > > > > > > parameters in my datasets. I appreciate any assistance you
can
> > give
> > > > me.
> > > > > > >
> > > > > > > Best regards
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>

IBM DB2 as Data Source

Hi,

I need to connect to a IBM DB2 database as a source in the Data Flow Task.

However, I am not able to figure out which is the provider I should be using.

It will be great if you can help me with that.

Thanks in advance.

Regards,

B@.ns

You want an OLE DB provider for DB2, available from both MS or IBM. The Microsoft OLE DB Provider for DB2 is available with SQL 2005, but is a separate download.

Feature Pack for Microsoft SQL Server 2005 - February 2007 - Includes Microsoft OLE DB Provider for DB2

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

You may want to review this KB if things are a bit slow -

http://support.microsoft.com/kb/918362

|||

Thank you so much! I am downloading the provider now.

Hopefully, it will work

Thanks again.

Regards,

B@.ns

|||

Hi,

I installed the OLE DB Provider for DB2 from the link provided.

However, when I am trying to create a new connection using the "Connection Manager", I am getting the following error:

"Test connection failed because of an error in initializing the provider. The parameter is not correct."

I have provided the Server IP address in the "Server or filename" field and a specific user name and password.

Interestingly, I am able to connect to the same server in my DTS package using the iSeries Access ODBC driver (by creating a system DSN).

I am using SQL Server 2005 Developer Edition - is that the problem?

Regards,

B@.ns

|||apart from downloading and installing the MS DB2 oledb adapter, If you are using IBM DB2 on AS400 iseries, you still need the iseries client software to be installed on your SSIS server system. I have no experience with other than iSeries, but I reckon the IBM client software would still need to be installed.|||

Thank you Jan DHondt,

Could you please give me the URL for this client software?

Thanks again.

Regards,

B@.ns

|||

IBM iSeries client software is a licensed client software and comes together with the AS400 license. You will have to contact your friendly IBM representative for more info.

If have tried once to download and install a more recent version v5r4, but the software did not allow this since the server was version v5r2.

this is the download site http://www.ibm.com/support/us/en/ but you'll still need a license. Except if you use DB2 Express-C which is a free version also for Windows platform (like sql-express): http://www-306.ibm.com/software/data/db2/express/download.html

sql

IBM DB2 as Data Source

Hi,

I need to connect to a IBM DB2 database as a source in the Data Flow Task.

However, I am not able to figure out which is the provider I should be using.

It will be great if you can help me with that.

Thanks in advance.

Regards,

B@.ns

You want an OLE DB provider for DB2, available from both MS or IBM. The Microsoft OLE DB Provider for DB2 is available with SQL 2005, but is a separate download.

Feature Pack for Microsoft SQL Server 2005 - February 2007 - Includes Microsoft OLE DB Provider for DB2

http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&DisplayLang=en

You may want to review this KB if things are a bit slow -

http://support.microsoft.com/kb/918362

|||

Thank you so much! I am downloading the provider now.

Hopefully, it will work

Thanks again.

Regards,

B@.ns

|||

Hi,

I installed the OLE DB Provider for DB2 from the link provided.

However, when I am trying to create a new connection using the "Connection Manager", I am getting the following error:

"Test connection failed because of an error in initializing the provider. The parameter is not correct."

I have provided the Server IP address in the "Server or filename" field and a specific user name and password.

Interestingly, I am able to connect to the same server in my DTS package using the iSeries Access ODBC driver (by creating a system DSN).

I am using SQL Server 2005 Developer Edition - is that the problem?

Regards,

B@.ns

|||apart from downloading and installing the MS DB2 oledb adapter, If you are using IBM DB2 on AS400 iseries, you still need the iseries client software to be installed on your SSIS server system. I have no experience with other than iSeries, but I reckon the IBM client software would still need to be installed.|||

Thank you Jan DHondt,

Could you please give me the URL for this client software?

Thanks again.

Regards,

B@.ns

|||

IBM iSeries client software is a licensed client software and comes together with the AS400 license. You will have to contact your friendly IBM representative for more info.

If have tried once to download and install a more recent version v5r4, but the software did not allow this since the server was version v5r2.

this is the download site http://www.ibm.com/support/us/en/ but you'll still need a license. Except if you use DB2 Express-C which is a free version also for Windows platform (like sql-express): http://www-306.ibm.com/software/data/db2/express/download.html