Connecting to DB2 Database - Drivers Needed

I am trying to connect my reporting services server to a DB2 server - What
drivers / info do i need to accomplish this. I cant seem to figure out how
to get this to work. Any help would be appreciated.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
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> I am trying to connect my reporting services server to a DB2 server - What
> drivers / info do i need to accomplish this. I cant seem to figure out
how
> to get this to work. Any help would be appreciated.|||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!
"Bruce L-C [MVP]" wrote:
> 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
> "PCL" <PCL@.discussions.microsoft.com> wrote in message
> news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> > I am trying to connect my reporting services server to a DB2 server - What
> > drivers / info do i need to accomplish this. I cant seem to figure out
> how
> > to get this to work. Any help would be appreciated.
>
>|||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
"PCL" <PCL@.discussions.microsoft.com> wrote in message
news:C27653D2-CBA2-43BD-A9AF-2A31DF5488FA@.microsoft.com...
> 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!
> "Bruce L-C [MVP]" wrote:
> > 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
> >
> > "PCL" <PCL@.discussions.microsoft.com> wrote in message
> > news:16E09229-DEDF-4D37-9F9A-5D4897359C54@.microsoft.com...
> > > I am trying to connect my reporting services server to a DB2 server -
What
> > > drivers / info do i need to accomplish this. I cant seem to figure
out
> > how
> > > to get this to work. Any help would be appreciated.
> >
> >
> >|||On Fri, 4 Mar 2005 08:59:03 -0800, PCL <PCL@.discussions.microsoft.com>
wrote:
>I am trying to connect my reporting services server to a DB2 server - What
>drivers / info do i need to accomplish this. I cant seem to figure out how
>to get this to work. Any help would be appreciated.
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
much about them...

connecting to database

Ilya Tumanov wrote:

Yes, but it makes no sense. To accomplish that you would have to purchase SQL 2000/2005 and pay CALs per device (or per CPU license). If that’s acceptable, simply get rid of Access and use much more powerful SQL you've paid for.

Alternative solution is to use Web Service to talk to Access database. Create couple WEB methods to talk to access and call them from device. Something like this should do:

DataSet GetAccessData(String command, …)

{

// Connect to Access DB here, execute command and populate data set with returned data.

return dataSet;

}

Bool UpdateAccessData(DataSet dataSet, … )

{

// Connect to Access DB here and update DB with data from Data Set.

return success;

}

How would I connect to an access database through a web service? Or where would I find information about this?
[code]
Dim FHDB As New OleDb.OleDbConnection("connstr")
Dim daFoodDonor As New OleDb.OleDbDataAdapter("select * from FoodDonations", FHDB)
[/code]
Actually I think i have this figured out but now i have a new preoblem that does not makes sense to me.
In my project I added the webservice and make a call to is
[code]
Dim upload As New Access.Access()
upload.UpdateAccessData(DonorChanges, AgencyChanges)
[/code]
but it tells me that DeviceApplication1.FHHDBDataSet.DonorInformationDataTable cannot be converted to type DeviceApplication1.Access.FHHDBDataSet.DonorInformationDataTable
I dont understand why not they are both the same type, only difference is the '.Access' in there.Sounds like this is a access db issue. You probably want o ask around in access forum. Thx,