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
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > > >
> > >
> >
> >
>