2003 Server - load balancing ODBC and Oracle client issues

[satxbiker]

Hi all,

I have 4 servers running Windows 2003 Server Standard and IIS 6. We
are using them as web servers. They are all load balanced together.
When I go to my website using a specific node I can connect to Access
using ODBC and Oracle using the Oracle client through my ASP page
fine. This works on all 4 nodes correctly. However when I go to my
website using the Virtual site (this uses the load balancing feature
and is supposed to throw me to the least used node at the time) I get
ODBC errors and Oracle client errors where he can not resolve the TNS
name.

I will admit I am not the network admin person working this, just the
web page developer, but I am helping him research this problem. Is
there some setting somewhere that I am missing in order to get the
virtual node connection to work? We have installed Oracle client
software on all 4 boxes and set up the ODBC system datasource on all 4
boxes. Of course this all works fine on our 2000 Server cluster but
it is not running load balancing. Thanks in advance for your help!

[[MSFT]]

Hello,

Thank you for using the community. From the description, it seems to be a
permission issue. Does the ASP appliaction use same account to access the
database resource when with load balance?

Luke
Microsoft Online Support

Get Secure! [url]www.microsoft.com/security[/url]
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[satxbiker]

[email]lukezhan@online.microsoft.com[/email] ([MSFT]) wrote in message news:<SkBHC5T8DHA.1988@cpmsftngxa07.phx.gbl>...

> Hello,
>
> Thank you for using the community. From the description, it seems to be a
> permission issue. Does the ASP appliaction use same account to access the
> database resource when with load balance?
>
> Luke
> Microsoft Online Support
>
> Get Secure! [url]www.microsoft.com/security[/url]
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)

Yes we are using the same user account if we are in load balance or if
we are using the node. We are using the IUSR local machine account.

[[MSFT]]

Thank you for the reply. I suggest you may try a more powerful account
other than IUser. Based the error message from Oracle (You didn't mentioned
error from Access), there is no enough permission to invoke Oracle client
component. You may perform further trouble shoot with following article:

[url]http://support.microsoft.com/?id=255084[/url]

Luke
Microsoft Online Support

Get Secure! [url]www.microsoft.com/security[/url]
(This posting is provided "AS IS", with no warranties, and confers no
rights.)