How to connect from IIS to IBM DB2 mainframe

Could someone tell me step by step what to do to make a
connection to DB2.

I have to write an application which will display DB2 data
on the web.
My experience level is 5 years with classic ASP & one
month with ASP.net.

I understand that I have to use ADO.net. But after that I
am lost.

I would think that you have to get the DB2 driver (not
sure where you get it)
Then put it on IIS.

Then what do you do?

Thank you in advance

[McKirahan]

<anonymous@discussions.microsoft.com> wrote in message
news:04c901c3cdd1$171ad800$a101280a@phx.gbl...

> Could someone tell me step by step what to do to make a
> connection to DB2.
>
> I have to write an application which will display DB2 data
> on the web.
> My experience level is 5 years with classic ASP & one
> month with ASP.net.
>
> I understand that I have to use ADO.net. But after that I
> am lost.
>
> I would think that you have to get the DB2 driver (not
> sure where you get it)
> Then put it on IIS.
>
> Then what do you do?
>
> Thank you in advance
>

Perhaps,

[url]http://www.connectionstrings.com/[/url]

[Jeff Cochran]

On Sun, 28 Dec 2003 22:00:41 -0800,
<anonymous@discussions.microsoft.com> wrote:

>Could someone tell me step by step what to do to make a
>connection to DB2.

What *kind* of connection?

>I have to write an application which will display DB2 data
>on the web.
>My experience level is 5 years with classic ASP & one
>month with ASP.net.

Which would you like to use?

>I understand that I have to use ADO.net. But after that I
>am lost.

You don't have to, but it works.

>I would think that you have to get the DB2 driver (not
>sure where you get it)

Well, this one is likely too obvious -- IBM. :)

We've been using an ODBC connection, with the driver from IBM's Client
Access.

>Then put it on IIS.

Um, no. You use an ODBC connection to DB2, or an OLEDB connection.
Check some of the connection string options here:

[url]http://www.able-consulting.com/ADO_Conn.htm[/url]

>Then what do you do?

Write the code to access the DB2 database in whatever manner you need.
This is exactly the same as accessing any other database such as
Access or MS-SQL, though you do have the IBM security to attend to
(assuming you run DB2 on an AS/400, System 390, etc.).

Jeff

[Ray at]

I use the OLEDB driver from IBM Client Access. On my webserver, I only
installed the driver though, and any necessary components. There isn't any
need to install the emulator and all the other nonsense. After that, it's
just a matter of building a connection string and treating the connection
like any other data source, for the most part. A sample connection string:

sDB2String = "Provider=IBMDA400.DataSource.1;Persist Security
Info=False;User ID=AnAS400UserID;Password=ValidPassword;Data
Source=HOST_NAME_OR_AS_400_IP_ADDRESS;Catalog Library
List=LIBRARY1,LIBRARY2,LIBRARY3"

Ray at work


<anonymous@discussions.microsoft.com> wrote in message
news:04c901c3cdd1$171ad800$a101280a@phx.gbl...

> Could someone tell me step by step what to do to make a
> connection to DB2.
>
> I have to write an application which will display DB2 data
> on the web.
> My experience level is 5 years with classic ASP & one
> month with ASP.net.
>
> I understand that I have to use ADO.net. But after that I
> am lost.
>
> I would think that you have to get the DB2 driver (not
> sure where you get it)
> Then put it on IIS.
>
> Then what do you do?
>
> Thank you in advance
>

[DB2]

Hi there,

Pretty simple, you will need an ODBC driver for DB2 (ie StarSQL, check
[url]www.starquest.com[/url]) and then define an ODBC data source that you will
use to connect your application to DB2. The data source will include
all the info you need to connect to DB2 (DB2 name, IP address of the
host etc...).

Hope this helps.

Good luck!

Bob

[email]jcochran.nospam@naplesgov.com[/email] (Jeff Cochran) wrote in message news:<3ff02f09.605178009@msnews.microsoft.com>...

> On Sun, 28 Dec 2003 22:00:41 -0800,
> <anonymous@discussions.microsoft.com> wrote:
>

> >Could someone tell me step by step what to do to make a
> >connection to DB2.

>
> What *kind* of connection?
>

> >I have to write an application which will display DB2 data
> >on the web.
> >My experience level is 5 years with classic ASP & one
> >month with ASP.net.

>
> Which would you like to use?
>

> >I understand that I have to use ADO.net. But after that I
> >am lost.

>
> You don't have to, but it works.
>

> >I would think that you have to get the DB2 driver (not
> >sure where you get it)

>
> Well, this one is likely too obvious -- IBM. :)
>
> We've been using an ODBC connection, with the driver from IBM's Client
> Access.
>

> >Then put it on IIS.

>
> Um, no. You use an ODBC connection to DB2, or an OLEDB connection.
> Check some of the connection string options here:
>
> [url]http://www.able-consulting.com/ADO_Conn.htm[/url]
>

> >Then what do you do?

>
> Write the code to access the DB2 database in whatever manner you need.
> This is exactly the same as accessing any other database such as
> Access or MS-SQL, though you do have the IBM security to attend to
> (assuming you run DB2 on an AS/400, System 390, etc.).
>
> Jeff