ASP.NET

Re: Can We Install IIS 6.0 on Windows XP Professional.

24-Mar-07 23:22

Hi there,
I am a newt to IIS and ASP.net.
So, I just wanted to know if we can install IIS 6.0 on Windows XP professional.
Thank you.

kubben25-Mar-07 2:06

Re: Can We Install IIS 6.0 on Windows XP Professional.

25-Mar-07 2:06

Yes you can.

Go to Control panel
Add or Remove Programs
Click the left side bar Add remove windows components
Select the check box for IIS.
Then click Next and follow the prompts.

You may need to re-install asp.net after IIS is installed. I have had some problems before if asp.net is installed before IIS.

Hope that helps.
Ben

MinhajuddinK25-Mar-07 16:52

Re: Can We Install IIS 6.0 on Windows XP Professional.

25-Mar-07 16:52

Hi thanks for the time spent.

But I don't have an IIS 6.0 server with me. Do you have any idea where I can download it from, because even a lot of googling hasn't helped. And how do we install ASP.NET. Is it different from the .Net framework we install.
I really appreciate the time spent on this.
Thank you.

kubben26-Mar-07 2:21

Re: Can We Install IIS 6.0 on Windows XP Professional.

26-Mar-07 2:21

Did you check the control panel add remove program and then add remove microsoft components?

IIS should be there. It might prompt you for a XP Professional install disk, but that is the easiest way to install IIS.

If you have already installed the .net framework that is fine. asp.net is the programming language that is in Visual studio. so you would need a visual studio install.

Hope that helps.
Ben

RichardGrimmer26-Mar-07 5:31

RichardGrimmer

26-Mar-07 5:31

Rubbish - that installs 5.x - 6.0 is from Win Server 2k3....

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Re: Can We Install IIS 6.0 on Windows XP Professional.

MinhajuddinK26-Mar-07 5:39

Re: Can We Install IIS 6.0 on Windows XP Professional.

26-Mar-07 5:39

You mean to say that there is no way to install an IIS 6.0 on an XP Pro.
And the only way to install IIS 6.0 is to install an Win 2003 Server?

RichardGrimmer26-Mar-07 21:48

RichardGrimmer

26-Mar-07 21:48

Not that I or any of my co-workers have found!

IIRC, you can get hold of 6 in a desktop OS, but only under
Vista...it's something to do with the concept of app pools under 6.0 I believe...

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Failed to access IIS Metabase.

MinhajuddinK24-Mar-07 22:01

Asp.net and Webfocus reporting

24-Mar-07 22:01

Hi there!
Please help me in this!
The error message when I try to run the asp.net application from the IIS server is this.

Server Error in '/Test' Application.
--------------------------------------------------------------------------------

Failed to access IIS metabase.

Thanx for the help.

Problem

MHASSANF24-Mar-07 21:14

MHASSANF

24-Mar-07 21:14

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'

i received this error when i upload the database to server (i don't know that server have aspnetdb or no )

what is this error and if the aspnetdb dose not exist how can i do ?

Thanks

Re: Problem

Bassam Saoud25-Mar-07 1:43

Bassam Saoud

25-Mar-07 1:43

You can install them to your DB using aspnet_regsql Tool[^].If you are using shared hosting check this [^]out.

adRotator control

raj@code24-Mar-07 19:58

raj@code

24-Mar-07 19:58

The above html element refreshes the entire page.

But I dont want the entire page to get refreshed but only the adRotator control to get refreshed frequently.

Help me out

Re: adRotator control

Tamimi - Code25-Mar-07 0:51

Tamimi - Code

25-Mar-07 0:51

put the adRotator in a speared page
then place this page in a original page inside an ifream tag

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: adRotator control

raj@code25-Mar-07 2:14

raj@code

25-Mar-07 2:14

My problem is solved.

ThankYou

Mohamed Arif24-Mar-07 17:30

Mohamed Arif

24-Mar-07 17:30

Hi All,
Is there any integration between Asp.net and Webfocus reporting. Please help me out in webfocus reporting with Asp.net 2.0.

- Arif

Nested Query Results (DataReader woes)

GregStevens24-Mar-07 14:03

GregStevens

24-Mar-07 14:03

I am connecting to an Oracle database using an OleDbConnection. I am using DataReader objects to get query results. However, this limits me to only having one reader open at a time, which is a problem for one of the operations I am doing.

I have a table with hierarhical data (only 3 levels deep) that I would like to parse through in a depth-first search. Each row in the table in the database has a Name and a ParentName, and I'm doing something like this:

oCmd1 = New OleDbCommand( "Select Name from tblTree where parentName='_top'", oCxn )
oRdr1 = oCmd1.ExecuteReader()

While oRdr1.Read()
     sName1 = oRdr1("Name")
     oCmd2 = New OleDbCommand( "Select Name from tblTree where parentName='" & sName1 & "'", oCxn )
     oRdr2 = oCmd2.ExecuteReader()

     While oRdr2.Read()
         '  do the third level, you get the idea
     End While
     oRdr2.Close()

End While
oRdr1.Close()

The problem is, it won't let me use oRdr2 while oRdr1 is open; and I can't close oRdr1 because it is still in the middle of cycling through the top-level items.

SO, my question is this: What is the PREFERRED way of dealing with this?

The options seem to be:

1) create a new DB connection for each level in the hierarchy
2) move to a different kind of object (DataSet?), instead of a DataReader
3) ??????.... some other option I haven't thought of?

I don't know which approach would be best, or if there are other approaches I'm not thinking of. Any help or advice is greatly appreciated.

Also, I apologize if this question would be better suited to a different forum. Please just let me know, and I'll take it there.

Thanks!
--- Greg Stevens

kubben24-Mar-07 14:13

24-Mar-07 14:13

Or option 3 use .net 2.0 where you can have multiple result sets open. I am guessing that probably isn't an option for you. So if you are stuck in .net 1.1 then I would go with option 1. Just have multiple connections. Since web apps use application pools as long as your connection string for each of the connection objects is the same you will use connection pooling. So your connections shouldn't get too out of control. If this data isn't going to change too much and isn't too big, I would think seriously of using caching to help out.

Hope that helps.
Ben

GregStevens24-Mar-07 14:22

GregStevens

24-Mar-07 14:22

Thank you for your reply.

My main worry is that this process will be called every time each page is loaded by every user. Does opening and closing three simultaneous connections on every page read incur bad performance hits if there are a large number of users?

Also, you say "I would think seriously of using caching to help out" but I'm not sure that I understand what you mean. Can you give me a two-sentence summary, or point me in the direction of a website / reference where I could find out more?

Thanks again!

kubben24-Mar-07 14:36

24-Mar-07 14:36

There is a Cache object, that is similar to the Session or Application object. In this case your only options would be application or cache if you want the data to be the same across sessions (users). If the data is completely static and will not change, then you might want to just put it in the Application object. Otherwise you can put it in the Cache.

Here is a Microsoft help on cache:
http://msdn2.microsoft.com/en-us/library/system.web.caching.cache.add.aspx[^]

Hope that helps.
Ben