Accessing as400 libraries through ASP odbc

[Mahendra]

Hi,

We are having IIS 5.0 installed with default setting. we
are trying to access as400 libraries (DB2) through ASP.
But whenever we run this asp after few minutes page stops
responding, It does not give any error. It is also
observed that after running this page, no asp page run
until IIS service is restarted. We have configured ODBC
configuration is OK as we can access as400 with other
applcations.We are using mdac 2.5 and mcafee netshied 4.5
on server and it does not have any option like script
disable.

Pl. help.


Thanks,

Mahendra

[Ray at]

I've run into the same behavior before when executing simple queries against
and AS/400 that had a ; at the end. Oddly enough, dropping the ; off the
end of the query fixed it. I don't know that that's the issue though. Can
you switch to OLE DB instead of ODBC? I'm using OLEDB drivers from IBM's
Client Access.

Ray at home

"Mahendra" <mahendra.ghadi@castrol.com> wrote in message
news:0a6d01c3a8e5$fc2fbcf0$a301280a@phx.gbl...

> Hi,
>
> We are having IIS 5.0 installed with default setting. we
> are trying to access as400 libraries (DB2) through ASP.
> But whenever we run this asp after few minutes page stops
> responding, It does not give any error. It is also
> observed that after running this page, no asp page run
> until IIS service is restarted. We have configured ODBC
> configuration is OK as we can access as400 with other
> applcations.We are using mdac 2.5 and mcafee netshied 4.5
> on server and it does not have any option like script
> disable.
>
> Pl. help.
>
>
> Thanks,
>
> Mahendra
>

[Jeff Cochran]

On Tue, 11 Nov 2003 22:27:02 -0800, "Mahendra"
<mahendra.ghadi@castrol.com> wrote:

>We are having IIS 5.0 installed with default setting. we
>are trying to access as400 libraries (DB2) through ASP.
>But whenever we run this asp after few minutes page stops
>responding, It does not give any error. It is also
>observed that after running this page, no asp page run
>until IIS service is restarted. We have configured ODBC
>configuration is OK as we can access as400 with other
>applcations.We are using mdac 2.5 and mcafee netshied 4.5
>on server and it does not have any option like script
>disable.

It could be multiple issues. Using OLEDB to access an AS/400 works
fine for us, but occasionally the IIS pages seem to hang because
something on the AS/400 is locking the process. Checking the AS/400
job queue may help there.

You may also be running into an IIS issue, check the event log for
errors and try the IIS groups for specific help there.

Jeff