Connecting to DB2 Database - Drivers Needed -- sql server reporting services

PCL
3/4/2005 10:07:04 AM

Thank You for your response - I guess i am not sure where i make this ODBC
connection. In .Net when i am creating a report it asks for a datasource
which I can use a DSN for. When i goto make a DSN, i do not see a generic
ODBC connection - I see ODBC for oracle but that is about it. How do i go
about creating this DSN?

Thanx!

[quoted text, click to view]

Bruce L-C [MVP]
3/4/2005 11:45:33 AM

You need an ODBC driver or an OLEDB driver. Either will work theorectically.
I go against Sybase and for them I found that the ODBC driver worked better.
Just a few days ago there was someone going against an AS400 running DB2
that has had good luck with ODBC.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
3/4/2005 12:27:43 PM

Assuming you have an ODBC driver installed, create a machine datasource
name. Then in RS create a new datasource, select the microsoft oledb for
odbc driver, you will then come to the screen that will allow you to pick
the DSN.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Usenet User
3/7/2005 5:46:23 PM

On Fri, 4 Mar 2005 08:59:03 -0800, PCL <PCL@discussions.microsoft.com>
[quoted text, click to view]

You maybe out of luck. OLE DB Provider for DB2 is not something you
can obtain free or even separately for a fee. As far as I know, it
only comes with MS Host Integration Server 2000 and 2004 (~$2500). We
recently had a discussion with Microsoft about this, and they
confirmed that this is a known business problem.

If you end up buying Host Integration Server, I'd strongly suggest you
get the latest release (2004): the provider seems to be less bugged
(it had some annoying instability issues in 2000), plus they now
include a managed provider as well, which is nice to have, if you're
programming on .NET platform.

There are other options, like getting a provider from IBM (or even
some 3rd party), but those are not free either, and I cannot tell you

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Connecting to DB2 Database - Drivers Needed