I was trying to display an html file with a page viewer web part
today. It worked, but even though the file fit in the area I
allocated to it, I could still see a scroll bar on the right. Is
there a way to get rid of that?

Often, there is white space that is displayed to the right and below the
HTML. I don't exactly know where it comes from but you can even see it
in IE. I suspect that this is where the scroll bars are coming from.

Have you tried the Content Editor Web Part?

Increas the height of the web part in tools pane it will disappear.

I am trying to develop a simple web page that access data from a SQL
database using the logged in user id to determine which data should be
displayed.
I have developed a web site and was planning on using the "Page Viewer
Web Part" to display the web site in SharePoint. The problem I have is
when I access the SharePoint page that shows the web site through the
Page Viewer Web Part it is not using the logged in SharePoint User.
Instead it uses the Administrator, which is the user that I am logged
into the Virtual PC as. I am using Page.User.Identity.Name to get the
logged in userid.

Can anyone advise on how I can use the SharePoint logged in user within
my code?

Following code will give you the formatted user name(removing domain name)

string luser =
Context.User.Identity.Name.Substring(Context.User.Identity.Name.IndexOf('\\') +
1);

Unfortunately that does not help me. All that appears to do is to
strip the Domain out. It is not giving me the SharePoint logged in
user but instead still the user who is logged into the PC (as
opposed to the SharePoint Web Site).

I am pretty new to Sharepoint and will try to describe our problem as best I
can. We are running SharePoint Portal Server 2003. On one of the pages, I have
added a Page Viewer Web Part that contains a link to a web app that retrieves
data from a SQL Server 2005 database based on the identity of the logged-in
user. The portal server uses https and is in a domain like my.companyname.com.
The web app is on a separate server. The link to the web app in the Page Viewer
web part is http://servername.companyname.com/appdirectory. The portal is
accessed both internally and externally. The web app uses
Context.User.Identity.Name to get the identity of the logged-in user and works
correctly outside of Sharepoint (accessing it via
http://servername.companyname.com/appdirectory).

If I set the link to the app in the Page Viewer Web Part to use https, we are
prompted to log in when trying to access the page even when we're logged in to
the company network. If I use http, we get the security message that there are
nonsecure items on the page, and after clicking through them, the app displays
(internally; over the Internet it prompts you to log in to the server).

I've been told that if the web app were in the my.companyname.com domain, I
could use https for the app and this would work seamlessly. When I asked our
Sharepoint guy about testing this, he said he wasn't sure about putting a web
site beneath the Sharepoint site but he would try.

So my question is, where should the web app reside in order for it to display in
the Page Viewer web part without requiring a separate login?

I know that I have been asking a lot about the RSS feeds for a couple of days
but I have another question about Page Viewer Web Part. Is there a way to
display the page viewer web and hide it when necessary using Javascript?

Example: if no data then do not show the page viewer if it is show the page
viewer.

Essentially, the page viewer just adds an iframe to the page. You can use
some JS to find the iframe and check the contents of document.body , at
which point you can set height/width or display/visibility through the style
object.