ASP to DB2 database?

[Bill]

I am confused. I need to access data on a mainfram IBM DB2
database. Is it as simple as setting up a ODBC DB2 driver.
Or does a data conversion need to take place?

[Ray at]

It's pretty much that simple. The only issue I've ever come across that I
can warn about is do not terminate your queries with a ; character. Doing
so can hang up your IIS server. Also, IBM Client Access has OLEDB drivers
that you may want to use instead of using an ODBC connection.

Ray at home

"Bill" <lhudspeth@mindspring.com> wrote in message
news:043801c3b484$1706a4e0$a501280a@phx.gbl...

> I am confused. I need to access data on a mainfram IBM DB2
> database. Is it as simple as setting up a ODBC DB2 driver.
> Or does a data conversion need to take place?

Thank you for responding. I will look into the OLEDB
drivers. How do you expose the IBM drivers? I know that
with ODBC it is a matter of pointing to the database. I
have found out that the DB2 database is not on the network.
If that is the case how do you point to the database. FTP?
Is there a book or web site that can put this into
perspective.
Also where do you get a DB2 ODBC driver?

>-----Original Message-----
>It's pretty much that simple. The only issue I've ever

come across that I

>can warn about is do not terminate your queries with a ;

character. Doing

>so can hang up your IIS server. Also, IBM Client Access

has OLEDB drivers

>that you may want to use instead of using an ODBC

connection.

>
>Ray at home
>
>"Bill" <lhudspeth@mindspring.com> wrote in message
>news:043801c3b484$1706a4e0$a501280a@phx.gbl...

>> I am confused. I need to access data on a mainfram IBM

DB2

>> database. Is it as simple as setting up a ODBC DB2

driver.

>> Or does a data conversion need to take place?

>
>
>.
>

[Ray at]

<anonymous@discussions.microsoft.com> wrote in message
news:a8b101c3b840$231d5b10$a601280a@phx.gbl...

> Thank you for responding. I will look into the OLEDB
> drivers. How do you expose the IBM drivers? I know that
> with ODBC it is a matter of pointing to the database.

??

> I
> have found out that the DB2 database is not on the network.
> If that is the case how do you point to the database. FTP?

If it's not on the network, you wouldn't be able to FTP from it either. If
you do not have a network connection to the AS/400, you won't be able to do
anything....

> Is there a book or web site that can put this into
> perspective.

Red Books from IBM? I don't know.

> Also where do you get a DB2 ODBC driver?

Off the IBM Client Access CD. Selective install.

Ray at work

[Jeff Cochran]

On Mon, 1 Dec 2003 11:20:10 -0800,
<anonymous@discussions.microsoft.com> wrote:

>Thank you for responding. I will look into the OLEDB
>drivers. How do you expose the IBM drivers? I know that
>with ODBC it is a matter of pointing to the database. I
>have found out that the DB2 database is not on the network.

You'll need network access to the AS/400 if you're going to access the
DB2 database. Check with your AS/400 admin on getting this done,
there are several methods possible. In our case we're using Client
Access to provide the connections.

>If that is the case how do you point to the database. FTP?

Can't use FTP if there's no network connection. You alsow ouldn't use
FTP anyway. You'd use either an OLEDB connection or an ODBC
connection.

>Is there a book or web site that can put this into
>perspective.

From which side, the IIS/Windows or the OS/400 side? The data is all
out there, sometimes it takes a few people with parts of the
information to make a whole though. Again, your AS/400 admin is the
best start for this.

>Also where do you get a DB2 ODBC driver?

Ours came off the Client Access install. Naturally this depends on
exactly what you're doing to connect to the AS/400. Check with IBM.

Jeff

>>-----Original Message-----
>>It's pretty much that simple. The only issue I've ever

>come across that I

>>can warn about is do not terminate your queries with a ;

>character. Doing

>>so can hang up your IIS server. Also, IBM Client Access

>has OLEDB drivers

>>that you may want to use instead of using an ODBC

>connection.

>>
>>Ray at home
>>
>>"Bill" <lhudspeth@mindspring.com> wrote in message
>>news:043801c3b484$1706a4e0$a501280a@phx.gbl...

>>> I am confused. I need to access data on a mainfram IBM

>DB2

>>> database. Is it as simple as setting up a ODBC DB2

>driver.

>>> Or does a data conversion need to take place?

>>
>>
>>.
>>

Thank you for the advice. The DB2 database is not on AS/400
it is on a mainframe. But I believe that your advice is
also appropriate for mainframe.

>-----Original Message-----
>On Mon, 1 Dec 2003 11:20:10 -0800,
><anonymous@discussions.microsoft.com> wrote:
>

>>Thank you for responding. I will look into the OLEDB
>>drivers. How do you expose the IBM drivers? I know that
>>with ODBC it is a matter of pointing to the database. I
>>have found out that the DB2 database is not on the

network.

>
>You'll need network access to the AS/400 if you're going

to access the

>DB2 database. Check with your AS/400 admin on getting

this done,

>there are several methods possible. In our case we're

using Client

>Access to provide the connections.
>

>>If that is the case how do you point to the database.

FTP?

>
>Can't use FTP if there's no network connection. You

alsow ouldn't use

>FTP anyway. You'd use either an OLEDB connection or an

ODBC

>connection.
>

>>Is there a book or web site that can put this into
>>perspective.

>
>From which side, the IIS/Windows or the OS/400 side? The

data is all

>out there, sometimes it takes a few people with parts of

the

>information to make a whole though. Again, your AS/400

admin is the

>best start for this.
>

>>Also where do you get a DB2 ODBC driver?

>
>Ours came off the Client Access install. Naturally this

depends on

>exactly what you're doing to connect to the AS/400.

Check with IBM.

>
>Jeff
>

>>>-----Original Message-----
>>>It's pretty much that simple. The only issue I've ever

>>come across that I

>>>can warn about is do not terminate your queries with

a ;

>>character. Doing

>>>so can hang up your IIS server. Also, IBM Client

Access

>>has OLEDB drivers

>>>that you may want to use instead of using an ODBC

>>connection.

>>>
>>>Ray at home
>>>
>>>"Bill" <lhudspeth@mindspring.com> wrote in message
>>>news:043801c3b484$1706a4e0$a501280a@phx.gbl.. .
>>>> I am confused. I need to access data on a mainfram

IBM

>>DB2

>>>> database. Is it as simple as setting up a ODBC DB2

>>driver.

>>>> Or does a data conversion need to take place?
>>>
>>>
>>>.
>>>

>
>.
>

[Jeff Cochran]

On Mon, 1 Dec 2003 18:52:22 -0800,
<anonymous@discussions.microsoft.com> wrote:

>Thank you for the advice. The DB2 database is not on AS/400
>it is on a mainframe. But I believe that your advice is
>also appropriate for mainframe.

Actually, basically identical. :)

Jeff

>>-----Original Message-----
>>On Mon, 1 Dec 2003 11:20:10 -0800,
>><anonymous@discussions.microsoft.com> wrote:
>>

>>>Thank you for responding. I will look into the OLEDB
>>>drivers. How do you expose the IBM drivers? I know that
>>>with ODBC it is a matter of pointing to the database. I
>>>have found out that the DB2 database is not on the

>network.

>>
>>You'll need network access to the AS/400 if you're going

>to access the

>>DB2 database. Check with your AS/400 admin on getting

>this done,

>>there are several methods possible. In our case we're

>using Client

>>Access to provide the connections.
>>

>>>If that is the case how do you point to the database.

>FTP?

>>
>>Can't use FTP if there's no network connection. You

>alsow ouldn't use

>>FTP anyway. You'd use either an OLEDB connection or an

>ODBC

>>connection.
>>

>>>Is there a book or web site that can put this into
>>>perspective.

>>
>>From which side, the IIS/Windows or the OS/400 side? The

>data is all

>>out there, sometimes it takes a few people with parts of

>the

>>information to make a whole though. Again, your AS/400

>admin is the

>>best start for this.
>>

>>>Also where do you get a DB2 ODBC driver?

>>
>>Ours came off the Client Access install. Naturally this

>depends on

>>exactly what you're doing to connect to the AS/400.

>Check with IBM.

>>
>>Jeff
>>

>>>>-----Original Message-----
>>>>It's pretty much that simple. The only issue I've ever
>>>come across that I
>>>>can warn about is do not terminate your queries with

>a ;

>>>character. Doing
>>>>so can hang up your IIS server. Also, IBM Client

>Access

>>>has OLEDB drivers
>>>>that you may want to use instead of using an ODBC
>>>connection.
>>>>
>>>>Ray at home
>>>>
>>>>"Bill" <lhudspeth@mindspring.com> wrote in message
>>>>news:043801c3b484$1706a4e0$a501280a@phx.gbl. ..
>>>>> I am confused. I need to access data on a mainfram

>IBM

>>>DB2
>>>>> database. Is it as simple as setting up a ODBC DB2
>>>driver.
>>>>> Or does a data conversion need to take place?
>>>>
>>>>
>>>>.
>>>>

>>
>>.
>>