IIS Issue: developing

Showing posts with label developing. Show all posts

Saturday, March 31, 2012

strange authentication dialog

Hi all,
I'm developing a website and deployed on webserver, it always
display an authentication dialog that user must login with valid
Windows user. Would anyone helps to instruct how to prohibit this
dialog?
Some information provides for you:
1) Dev softs:
- VS 2005, ASP.NET 2.0, SQL Server 2005 Enterprise edition
2) Server:
a) Website Directory security:
- Allow anonymous access (IUSR_Server)
- Integrated Windows authentication.
b) OS: Windows 2003 Server.
The particular note is when deplying other Windows 2003 Server PC, it
works fine without any authentication dialog although the configuration
is exactly the same.
Some no - effective solutions:
- Remove "Integrated Windows authentication": result of "you are
unauthorized to ..."
- Add permission for user Evryone, Anonymous Logon, Network Service.
Very appreciated for any hint.
KNCKNC,
You should anyway remove the "Integrated WIndows Authentication"
setting from IIS. Having done that, you should make sure that the
physical directory that you have your website in has permissions for
the Network Service. Thirdly, what kind of authentication have you
specified for your web site (typically a setting in your web.config
file). Try checking that.
- Vaibhav
On Nov 2, 1:25 pm, "KNC" <k...@.glassegg.com> wrote:
> Hi all,
> I'm developing a website and deployed on webserver, it always
> display an authentication dialog that user must login with valid
> Windows user. Would anyone helps to instruct how to prohibit this
> dialog?
> Some information provides for you:
> 1) Dev softs:
> - VS 2005, ASP.NET 2.0, SQL Server 2005 Enterprise edition
> 2) Server:
> a) Website Directory security:
> - Allow anonymous access (IUSR_Server)
> - Integrated Windows authentication.
> b) OS: Windows 2003 Server.
> The particular note is when deplying other Windows 2003 Server PC, it
> works fine without any authentication dialog although the configuration
> is exactly the same.
> Some no - effective solutions:
> - Remove "Integrated Windows authentication": result of "you are
> unauthorized to ..."
> - Add permission for user Evryone, Anonymous Logon, Network Service.
> Very appreciated for any hint.
> KNC
Hi V,
Thanks for your help. But as my message, I already tried to remove
"Integrated Windows authentication" and add user "NETWORK SERVICE" into
user list of my folder of website (under wwwroot) but no effect.
I've just re-tried as your instruction but it is still the same
phenomenon.
FYI, the authentication type of web.config is <authentication
mode="Forms">
Moreover, if I setting the Anonymous user account is a power user
(such as Administrator), it works fine, no authentication dialog at
all.
Would you guys pls give the root cause of this problem?
Thanks in advance,
KNC
V wrote:
> KNC,
> You should anyway remove the "Integrated WIndows Authentication"
> setting from IIS. Having done that, you should make sure that the
> physical directory that you have your website in has permissions for
> the Network Service. Thirdly, what kind of authentication have you
> specified for your web site (typically a setting in your web.config
> file). Try checking that.
> - Vaibhav
> On Nov 2, 1:25 pm, "KNC" <k...@.glassegg.com> wrote:
KNC,
if you have configured Forms authentication in your application, have
you implemented it in your pages? To be honest, I am not entirely sure
why your application is behaving this way (need one those experts to
answer on your thread :) ). However, i am trying to think of all the
things that I do when i setup Forms Authentication based web-app as I
have NEVER faced this problem.
Cheers,
- V
KNC wrote:
> Hi V,
> Thanks for your help. But as my message, I already tried to remove
> "Integrated Windows authentication" and add user "NETWORK SERVICE" into
> user list of my folder of website (under wwwroot) but no effect.
> I've just re-tried as your instruction but it is still the same
> phenomenon.
> FYI, the authentication type of web.config is <authentication
> mode="Forms">
> Moreover, if I setting the Anonymous user account is a power user
> (such as Administrator), it works fine, no authentication dialog at
> all.
> Would you guys pls give the root cause of this problem?
> Thanks in advance,
> KNC
> V wrote:

strange authentication dialog

Hi all,

I'm developing a website and deployed on webserver, it always
display an authentication dialog that user must login with valid
Windows user. Would anyone helps to instruct how to prohibit this
dialog?
Some information provides for you:
1) Dev softs:
- VS 2005, ASP.NET 2.0, SQL Server 2005 Enterprise edition
2) Server:
a) Website Directory security:
- Allow anonymous access (IUSR_Server)
- Integrated Windows authentication.
b) OS: Windows 2003 Server.

The particular note is when deplying other Windows 2003 Server PC, it
works fine without any authentication dialog although the configuration
is exactly the same.
Some no - effective solutions:
- Remove "Integrated Windows authentication": result of "you are
unauthorized to ..."
- Add permission for user Evryone, Anonymous Logon, Network Service.

Very appreciated for any hint.
KNCKNC,

You should anyway remove the "Integrated WIndows Authentication"
setting from IIS. Having done that, you should make sure that the
physical directory that you have your website in has permissions for
the Network Service. Thirdly, what kind of authentication have you
specified for your web site (typically a setting in your web.config
file). Try checking that.

- Vaibhav

On Nov 2, 1:25 pm, "KNC" <k...@.glassegg.comwrote:

Quote:

Originally Posted by

Hi all,
>
I'm developing a website and deployed on webserver, it always
display an authentication dialog that user must login with valid
Windows user. Would anyone helps to instruct how to prohibit this
dialog?
Some information provides for you:
1) Dev softs:
- VS 2005, ASP.NET 2.0, SQL Server 2005 Enterprise edition
2) Server:
a) Website Directory security:
- Allow anonymous access (IUSR_Server)
- Integrated Windows authentication.
b) OS: Windows 2003 Server.
>
The particular note is when deplying other Windows 2003 Server PC, it
works fine without any authentication dialog although the configuration
is exactly the same.
Some no - effective solutions:
- Remove "Integrated Windows authentication": result of "you are
unauthorized to ..."
- Add permission for user Evryone, Anonymous Logon, Network Service.
>
Very appreciated for any hint.
KNC

Hi V,

Thanks for your help. But as my message, I already tried to remove
"Integrated Windows authentication" and add user "NETWORK SERVICE" into
user list of my folder of website (under wwwroot) but no effect.
I've just re-tried as your instruction but it is still the same
phenomenon.
FYI, the authentication type of web.config is <authentication
mode="Forms">
Moreover, if I setting the Anonymous user account is a power user
(such as Administrator), it works fine, no authentication dialog at
all.

Would you guys pls give the root cause of this problem?

Thanks in advance,
KNC

V wrote:

Quote:

Originally Posted by

KNC,
>
You should anyway remove the "Integrated WIndows Authentication"
setting from IIS. Having done that, you should make sure that the
physical directory that you have your website in has permissions for
the Network Service. Thirdly, what kind of authentication have you
specified for your web site (typically a setting in your web.config
file). Try checking that.
>
- Vaibhav
>
On Nov 2, 1:25 pm, "KNC" <k...@.glassegg.comwrote:

Quote:

Originally Posted by

Hi all,

Very appreciated for any hint.
KNC

KNC,

if you have configured Forms authentication in your application, have
you implemented it in your pages? To be honest, I am not entirely sure
why your application is behaving this way (need one those experts to
answer on your thread :) ). However, i am trying to think of all the
things that I do when i setup Forms Authentication based web-app as I
have NEVER faced this problem.

Cheers,
- V

KNC wrote:

Quote:

Originally Posted by

Hi V,
>
Thanks for your help. But as my message, I already tried to remove
"Integrated Windows authentication" and add user "NETWORK SERVICE" into
user list of my folder of website (under wwwroot) but no effect.
I've just re-tried as your instruction but it is still the same
phenomenon.
FYI, the authentication type of web.config is <authentication
mode="Forms">
Moreover, if I setting the Anonymous user account is a power user
(such as Administrator), it works fine, no authentication dialog at
all.
>
Would you guys pls give the root cause of this problem?
>
Thanks in advance,
KNC
>
V wrote:

Quote:

Originally Posted by

KNC,

- Vaibhav

On Nov 2, 1:25 pm, "KNC" <k...@.glassegg.comwrote:

Quote:

Originally Posted by

Monday, March 26, 2012

Strange css problem (bug?)

Hi,
I'm developing a asp.net application and ran into a strange css problem.
I want all my links to have a dashed underline and when they are
hovered, it must change to a solid line. Sounds simple, but it's not
working.
I've cooked down my output code to show you what I mean. If you run the
code below, there's no line under the link, but if you either remove the
<!DOCTYPE...> line or the body-part of the css decleration, everything
works fine.
Here's my code (watch for wrappings):
---
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Strange</title>
<style>

</style>
</head>
<body>
<a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
</body>
</html>
---
Any idea'?
I also found out, if I put a <p> </p> below the <a href...> in the
code above, everything works fine.
I'm

!!!!!
HHHHEEELLLPPPPP! :o)
Thank you in advance.
M O J OCheck out the css newsgroup
Let me know if you have any more questions...
Cheers,
Tom Pester

> Hi,
> I'm developing a asp.net application and ran into a strange css
> problem.
> I want all my links to have a dashed underline and when they are
> hovered, it must change to a solid line. Sounds simple, but it's not
> working.
> I've cooked down my output code to show you what I mean. If you run
> the code below, there's no line under the link, but if you either
> remove the <!DOCTYPE...> line or the body-part of the css decleration,
> everything works fine.
> Here's my code (watch for wrappings):
> ---
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html;
> charset=windows-1252">
> <title>Strange</title>
> <style>
> 
> </style>
> </head>
> <body>
> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
> </body>
> </html>
> ---
> Any idea'?
> I also found out, if I put a <p> </p> below the <a href...> in
> the code above, everything works fine.
> I'm

!!!!!
> HHHHEEELLLPPPPP! :o)
> Thank you in advance.
> M O J O
>
Hi Tom,
Which group are you exactly talking about?
M O J O
tom pester wrote:
> Check out the css newsgroup
> Let me know if you have any more questions...
> Cheers,
> Tom Pester
>
>
http://groups.google.com/group/comp.infosystems.www.authoring.stylesheets?gvc=2&hl
=en
Let me know if it helped you or not...
Cheers,
Tom Pester
> Hi Tom,
> Which group are you exactly talking about?
> M O J O
> tom pester wrote:
>
Try putting your style-block before the body tag. Inside the head you
should only refer to external css files.
Okay thanks, I'll give it a try.
M O J O
tom pester wrote:
> http://groups.google.com/group/comp...2&
hl=en
>
> Let me know if it helped you or not...
> Cheers,
> Tom Pester
>
>
Hi Stefan,
Thanks for letting me know. Unfortunately it does not solve my problem.
:o(
Hmmmmm.
Thanks anyway.
M O J O
Stefan wrote:
> Try putting your style-block before the body tag. Inside the head you
> should only refer to external css files.
>
your problem is that an <a> is an inline element, not a block element, so it
does not have a border. normally you use the text-decoration to control
underlining, but there is no dashed version. you can try setting the display
style to block.
-- bruce (sqlwork.com)
"M O J O" < mojo@._no_spam_delete_this_newwebsolution
s.dk> wrote in message
news:uNHXoi8qFHA.904@.tk2msftngp13.phx.gbl...
> Hi,
> I'm developing a asp.net application and ran into a strange css problem.
> I want all my links to have a dashed underline and when they are hovered,
> it must change to a solid line. Sounds simple, but it's not working.
> I've cooked down my output code to show you what I mean. If you run the
> code below, there's no line under the link, but if you either remove the
> <!DOCTYPE...> line or the body-part of the css decleration, everything
> works fine.
> Here's my code (watch for wrappings):
> ---
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
> <title>Strange</title>
> <style>
> 
> </style>
> </head>
> <body>
> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
> </body>
> </html>
> ---
> Any idea'?
> I also found out, if I put a <p> </p> below the <a href...> in the
> code above, everything works fine.
> I'm

!!!!!
> HHHHEEELLLPPPPP! :o)
> Thank you in advance.
> M O J O

Strange css problem (bug?)

Hi,

I'm developing a asp.net application and ran into a strange css problem.

I want all my links to have a dashed underline and when they are
hovered, it must change to a solid line. Sounds simple, but it's not
working.

I've cooked down my output code to show you what I mean. If you run the
code below, there's no line under the link, but if you either remove the
<!DOCTYPE...> line or the body-part of the css decleration, everything
works fine.

Here's my code (watch for wrappings):

----------------------

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Strange</title>
<style>
<!--
body
{
font-family: verdana, arial, helvetica, sans-serif;
}

a:link, a:visited
{
font-family: verdana, arial, helvetica, sans-serif;
color: #d32525;
border-bottom: 1px dashed #d32525;
text-decoration: none;
}

a:hover
{
font-family: verdana, arial, helvetica, sans-serif;
color: #d32525;
border-bottom: 1px solid #d32525;
text-decoration: none;
}
-->
</style>
</head
<body>
<a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
</body
</html
----------------------

Any idea???

I also found out, if I put a <p> </p> below the <a href...> in the
code above, everything works fine.

I'm confused!!!!!

HHHHEEELLLPPPPP! :o)

Thank you in advance.

M O J OCheck out the css newsgroup

Let me know if you have any more questions...

Cheers,
Tom Pester

> Hi,
> I'm developing a asp.net application and ran into a strange css
> problem.
> I want all my links to have a dashed underline and when they are
> hovered, it must change to a solid line. Sounds simple, but it's not
> working.
> I've cooked down my output code to show you what I mean. If you run
> the code below, there's no line under the link, but if you either
> remove the <!DOCTYPE...> line or the body-part of the css decleration,
> everything works fine.
> Here's my code (watch for wrappings):
> ----------------------
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html;
> charset=windows-1252">
> <title>Strange</title>
> <style>
> 
> </style>
> </head>
> <body>
> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
> </body>
> </html>
> ----------------------
> Any idea???
> I also found out, if I put a <p> </p> below the <a href...> in
> the code above, everything works fine.
> I'm confused!!!!!
> HHHHEEELLLPPPPP! :o)
> Thank you in advance.
> M O J O
Hi Tom,

Which group are you exactly talking about?

M O J O

tom pester wrote:
> Check out the css newsgroup
> Let me know if you have any more questions...
> Cheers,
> Tom Pester
>> Hi,
>>
>> I'm developing a asp.net application and ran into a strange css
>> problem.
>>
>> I want all my links to have a dashed underline and when they are
>> hovered, it must change to a solid line. Sounds simple, but it's not
>> working.
>>
>> I've cooked down my output code to show you what I mean. If you run
>> the code below, there's no line under the link, but if you either
>> remove the <!DOCTYPE...> line or the body-part of the css decleration,
>> everything works fine.
>>
>> Here's my code (watch for wrappings):
>>
>> ----------------------
>>
>> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>>
>> <html>
>> <head>
>> <meta http-equiv="Content-Type" content="text/html;
>> charset=windows-1252">
>> <title>Strange</title>
>> <style>
>> 
>> </style>
>> </head>
>> <body>
>> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
>> </body>
>> </html>
>>
>> ----------------------
>>
>> Any idea???
>>
>> I also found out, if I put a <p> </p> below the <a href...> in
>> the code above, everything works fine.
>>
>> I'm confused!!!!!
>>
>> HHHHEEELLLPPPPP! :o)
>>
>> Thank you in advance.
>>
>> M O J O
>>
>
http://groups.google.com/group/comp...ets?gvc=2&hl=en

Let me know if it helped you or not...

Cheers,
Tom Pester

> Hi Tom,
> Which group are you exactly talking about?
> M O J O
> tom pester wrote:
>> Check out the css newsgroup
>>
>> Let me know if you have any more questions...
>>
>> Cheers,
>> Tom Pester
>>> Hi,
>>>
>>> I'm developing a asp.net application and ran into a strange css
>>> problem.
>>>
>>> I want all my links to have a dashed underline and when they are
>>> hovered, it must change to a solid line. Sounds simple, but it's not
>>> working.
>>>
>>> I've cooked down my output code to show you what I mean. If you run
>>> the code below, there's no line under the link, but if you either
>>> remove the <!DOCTYPE...> line or the body-part of the css
>>> decleration, everything works fine.
>>>
>>> Here's my code (watch for wrappings):
>>>
>>> ---------------------
>>> --
>>>
>>> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
>>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>>>
>>> <html>
>>> <head>
>>> <meta http-equiv="Content-Type" content="text/html;
>>> charset=windows-1252">
>>> <title>Strange</title>
>>> <style>
>>> 
>>> </style>
>>> </head>
>>> <body>
>>> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
>>> </body>
>>> </html>
>>> ---------------------
>>> --
>>>
>>> Any idea???
>>>
>>> I also found out, if I put a <p> </p> below the <a href...> in
>>> the code above, everything works fine.
>>>
>>> I'm confused!!!!!
>>>
>>> HHHHEEELLLPPPPP! :o)
>>>
>>> Thank you in advance.
>>>
>>> M O J O
>>
Try putting your style-block before the body tag. Inside the head you
should only refer to external css files.
Okay thanks, I'll give it a try.

M O J O

tom pester wrote:
> http://groups.google.com/group/comp...ets?gvc=2&hl=en
>
> Let me know if it helped you or not...
> Cheers,
> Tom Pester
>> Hi Tom,
>>
>> Which group are you exactly talking about?
>>
>> M O J O
>>
>> tom pester wrote:
>>
>>> Check out the css newsgroup
>>>
>>> Let me know if you have any more questions...
>>>
>>> Cheers,
>>> Tom Pester
>>>
>>>> Hi,
>>>>
>>>> I'm developing a asp.net application and ran into a strange css
>>>> problem.
>>>>
>>>> I want all my links to have a dashed underline and when they are
>>>> hovered, it must change to a solid line. Sounds simple, but it's not
>>>> working.
>>>>
>>>> I've cooked down my output code to show you what I mean. If you run
>>>> the code below, there's no line under the link, but if you either
>>>> remove the <!DOCTYPE...> line or the body-part of the css
>>>> decleration, everything works fine.
>>>>
>>>> Here's my code (watch for wrappings):
>>>>
>>>> ---------------------
>>>> --
>>>>
>>>> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
>>>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>>>>
>>>> <html>
>>>> <head>
>>>> <meta http-equiv="Content-Type" content="text/html;
>>>> charset=windows-1252">
>>>> <title>Strange</title>
>>>> <style>
>>>> 
>>>> </style>
>>>> </head>
>>>> <body>
>>>> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
>>>> </body>
>>>> </html>
>>>> ---------------------
>>>> --
>>>>
>>>> Any idea???
>>>>
>>>> I also found out, if I put a <p> </p> below the <a href...> in
>>>> the code above, everything works fine.
>>>>
>>>> I'm confused!!!!!
>>>>
>>>> HHHHEEELLLPPPPP! :o)
>>>>
>>>> Thank you in advance.
>>>>
>>>> M O J O
>>>>
>
Hi Stefan,

Thanks for letting me know. Unfortunately it does not solve my problem.

:o(

Hmmmmm.

Thanks anyway.

M O J O

Stefan wrote:
> Try putting your style-block before the body tag. Inside the head you
> should only refer to external css files.
your problem is that an <a> is an inline element, not a block element, so it
does not have a border. normally you use the text-decoration to control
underlining, but there is no dashed version. you can try setting the display
style to block.

-- bruce (sqlwork.com)

"M O J O" <mojo@._no_spam_delete_this_newwebsolutions.dk> wrote in message
news:uNHXoi8qFHA.904@.tk2msftngp13.phx.gbl...
> Hi,
> I'm developing a asp.net application and ran into a strange css problem.
> I want all my links to have a dashed underline and when they are hovered,
> it must change to a solid line. Sounds simple, but it's not working.
> I've cooked down my output code to show you what I mean. If you run the
> code below, there's no line under the link, but if you either remove the
> <!DOCTYPE...> line or the body-part of the css decleration, everything
> works fine.
> Here's my code (watch for wrappings):
> ----------------------
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
> <title>Strange</title>
> <style>
> 
> </style>
> </head>
> <body>
> <a href="http://links.10026.com/?link=http://www.microsoft.com/">This is just a link</a>
> </body>
> </html>
> ----------------------
> Any idea???
> I also found out, if I put a <p> </p> below the <a href...> in the
> code above, everything works fine.
> I'm confused!!!!!
> HHHHEEELLLPPPPP! :o)
> Thank you in advance.
> M O J O

Strange DataView Problem

Hello,

I need some clarification about a stange DataView behaviour I have noticed. I am developing a dynamic website that is binding data (from an Access db) to a datagrid. I use a cached dataset to save trips to the db, here is the code...

'populate the Cache Variable that stores the Web Content Dataset
 Public Function PopulateWebContentDataset(Optional ByVal blnRepopulate As Boolean = False) As Boolean
 Dim ds As New DataSet()
 'check if cached dataset already exists
 If Current.Cache("WebContent") Is Nothing = False Then
 'the cached variable already exists
 Return True
 End If
 'get the Web Content from the database
 Dim cn As New OleDbConnection(AppSettings("cnStringWebContent"))
 Dim da As New OleDbDataAdapter("SELECT * FROM tblWebContent", cn)
 Try
 'fill the Web Content dataset with records from the database
 da.Fill(ds, "tblWebContent")
 If ds.Tables("tblWebContent").Rows.Count > 0 Then
 'add the dataset to the cache
 Current.Cache.Insert("WebContent", ds, _
 New System.Web.Caching.CacheDependency(AppSettings("dbPathWebContent")), _
 DateTime.Now.AddDays(1), Current.Cache.NoSlidingExpiration, _
 System.Web.Caching.CacheItemPriority.Normal, Nothing)
 Return True
 Else
 'no records were found
 Current.Cache.Remove("WebContent")
 Current.Cache("WebContent") = Nothing
 Return False
 End If
 Catch DefaultExc As Exception
 Finally
 cn.Dispose()
 da.Dispose()
 ds.Dispose()
 End Try
 End Function
 Public Function BindPageContent(ByRef dgr As DataGrid, ByVal strPage As String, _
 Optional ByVal blnRepopulate As Boolean = False) As Boolean
 'check if the cache Web Content dataset already exists
 If PopulateWebContentDataset(blnRepopulate) = False And blnRepopulate = False Then
 'unable to get the information from the database
 Return False
 End If
 Dim ds As DataSet
 Dim dv As New DataView()
 Try
 ds = Current.Cache("WebContent")
 'ds.Tables("tblWebContent").DefaultView.RowFilter = "Page=" & "'" & strPage & "'"
 dv = ds.Tables("tblWebContent").DefaultView
 dv.RowFilter = "Page=" & "'" & strPage & "'"
 dgr.DataSource = dv
 dgr.DataBind()
 Catch DefaultExc As Exception
 Finally
 ds.Dispose()
 dv.Dispose()
 End Try
 End Function

My question is, the above code works perfectly the first time the page loads but when I return to this specific page (which should be getting the cached dataset), nothing is displayed. I checked the dataset and it has the correct amount of rows, however, the dataview has a rowcount of 0 (when it previously had a rowcount of 1).

I have done the following to fix this problem, all of which have worked...
1. Instead of getting the dataset from the cache, I connected to the db on each page_load and repopulated the dataset
2. When I bind the datagrid using the dataset as the datasource instead of the dataview, it works...

(ds.tables("tblWebContent").defaultview.rowfilter="Page='" & strPage & "'")

3. When I take out dv.dispose, everything works as expected

I have many instances in my code where I use the exact same code as posted above and it doesn't seem like there is a problem with the DataView. Should I re-examine all my code and remove dataview.dispose()? Does anyone have any suggestions on why this may be happening?Indeed, you shouldn't dispose that object since it's needed when the page execution is done further to display the data on the web form. In fact, it's a strange problem for me too but I would never dispose the dataview... Remember, the dataset object is a disconnected object which doesn't need any connection whatsoever with the database.

Strange Date Problem

Hi all,

i am using visual studio 2005 and sql server 2005, i am developing a web application using visual basic 2005. i also let you know that i am in UK.

i am having a strange problem. i have got a form from whcih i need to insert the date values into the data base my querystring is as follows.

StrSql = "insert into tasks (TaskName,Sdate,PropEdate,InitID,TaskManager) values (" & _
"'" & Me.TxtTaskName.Text & "'," & _
"'" & Me.TxtSDate.Text & "'," & _
"'" & Me.TxtEdate.Text & "'," & _
Session("InitID") & "," & _
Me.DropDownList1.SelectedValue & _
")"

which is working fine except that it is storing date in different format that is mm/dd/yyyy.

on my other form i again want to insert the date value wich is not working.
my querystring is

StrSql = "insert into tasklog (taskid,currentstatus,updatedon,comments) values (" & _
Me.GridView1.SelectedValue & "," & _
Me.TxtRecentpos.Text & "," & _
"'" & Me.TxtDate.Text & "'," & _
"'" & Me.TxtComments.Text & "'" & _
")"

when i try to run this query it gives me the following error message:

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value..

i have checked in the sqlserver and both the tables have got the smalldatetime datatype for my fields. it's really scaring for me that it is working on one place and not working on other.
any help would be highly appretiated.
thanksNo matter what the settings are in your code/computer/database, when putting date values into SQL statements, you cannot use the UK format (dd/mm/yyyy).

You must use either the US format (mm/dd/yyyy), or better a format which cannot be mis-interpreted (like yyyy/mm/dd).

If you format the values in this style, you will probably find that the code works perfectly.
Hi si,

i have tried both us format and the other format you told me. but sitll giving the same erroe message.

regards
Faizee
You must use either the US format (mm/dd/yyyy), or better a format which cannot be mis-interpreted (like yyyy/mm/dd).

If you format the values in this style, you will probably find that the code works perfectly.[/QUOTE]

Hi Si sorry i have tried (mm-dd-yyyy) and (yyyy-mm-dd) both are working fine. is it not possible that user enter the date in UK format ( i am using vb 2005) and then i format this to us format or other format to save in the SQL Server so that the users are not confused?

regards
Of course... you just have to convert it before using it in an SQL string.

I haven't used .Net enough to suggest the code you would use to convert it, but can recommend that you use a special date control rather than a textbox - as this is always clear to the user, and to your code too (no matter what settings the PC has).
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value..

This can be caused by trying to put a date less than 1/1/1900 or larger than 6/6/2079

Also check out using parameters with your SQL strings, it prevents sql injection as well has handles special characters.
Thanks Si and Bill,

i am using RJS Calendar control now and it's working fine.

thanks a lot for your help

Faizee

Thursday, March 22, 2012

Strange IIS connection error

Hi all
While developing a web app in visual interdev.net 2003
i get this error when i try to run the app:

There are too many people accessing the Web site at this time.

-----------------------

Please try the following:

a.. Click the Refresh button, or try again later.

b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 403.9 - Access Forbidden: Too many users are connected
Internet Information Services

The problem is intermitent. I'm using IIS 5.1 and ASP 1.1

What can cause this? It's never happened to me before in the last 3 years

Thanks in advance

JohnWhat can cause this? It's never happened to me before in the last 3 years

It is caused by too many users being connected to Internet Information
Services.

--
HTH,

Kevin Spencer
Microsoft MVP
Chicken Salad Surgery

What You Seek Is What You Get.

"John Haycock" <jhayc@dotnet.itags.org.blueyonder.co.ukwrote in message
news:h_cOg.42635$89.33698@dotnet.itags.org.fe1.news.blueyonder.co.u k...

Quote:

Originally Posted by

Hi all
While developing a web app in visual interdev.net 2003
i get this error when i try to run the app:
>
There are too many people accessing the Web site at this time.
>
-----------------------
>
Please try the following:
>
a.. Click the Refresh button, or try again later.
>
b.. Open the localhost home page, and then look for links to the
information you want.
HTTP 403.9 - Access Forbidden: Too many users are connected
Internet Information Services
>
The problem is intermitent. I'm using IIS 5.1 and ASP 1.1
>
What can cause this? It's never happened to me before in the last 3 years
>
Thanks in advance
>
John
>
>

"Kevin Spencer" <uce@dotnet.itags.org.ftc.govwrote in message
news:%23GqxNrA2GHA.3464@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

It is caused by too many users being connected to Internet Information
Services.

Hi Kevin

That's the thing its on my development machine at home. Theres noone
connected to it but me?
One user can generate several connections.

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"John Haycock" <jhayc@dotnet.itags.org.blueyonder.co.ukwrote in message
news:WYdOg.43278$89.6405@dotnet.itags.org.fe1.news.blueyonder.co.uk ...

Quote:

Originally Posted by

>
"Kevin Spencer" <uce@dotnet.itags.org.ftc.govwrote in message news:%23GqxNrA2GHA.3464@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

>It is caused by too many users being connected to Internet Information Services.

>
Hi Kevin
>
That's the thing its on my development machine at home. Theres noone connected to it but me?
>
>

"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:uYziF3A2GHA.1288@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

One user can generate several connections.

Yes but I don't see how by just running a web app. I always close
connections in the code and it's the first time it's happened in over 3
years. it's just a basic site with some web forms and fckeditor embedded in
some of the pages
re:

Quote:

Originally Posted by

I always close connections in the code

The problem is not data access connections. You're not running out of those.
It's http connections.

Windows XP is limited to 10 connections...of all types, both incoming and outgoing.

Run this little test and you'll probably be surprised
at the number of connections you actually have open :

Open a command window ( Start, Run, cmd ) and issue the command :

netstat -a

Make sure you're sitting down when you do that.
I'll bet you didn't know you had so many active connections open.

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"John Haycock" <jhayc@dotnet.itags.org.blueyonder.co.ukwrote in message
news:qceOg.43433$89.34469@dotnet.itags.org.fe1.news.blueyonder.co.u k...

Quote:

Originally Posted by

>
"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:uYziF3A2GHA.1288@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

>One user can generate several connections.

Quote:

Originally Posted by

Yes but I don't see how by just running a web app. I always close connections in the code and it's
the first time it's happened in over 3 years. it's just a basic site with some web forms and
fckeditor embedded in some of the pages

"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:%23kK7LjB2GHA.3476@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

re:

Quote:

Originally Posted by

>I always close connections in the code

>
The problem is not data access connections. You're not running out of
those.
It's http connections.
>
Windows XP is limited to 10 connections...of all types, both incoming and
outgoing.
>
Run this little test and you'll probably be surprised
at the number of connections you actually have open :
>
Open a command window ( Start, Run, cmd ) and issue the command :
>
netstat -a
>
Make sure you're sitting down when you do that.
I'll bet you didn't know you had so many active connections open.

Hey Juan you are right that is a shock. But why has localhost got so many
connections open with lots of different ports? Am I being hacked or what? As
I say this is the first time in three years I've got that error so I'm
assuming I have more connections now for some reason
re:

Quote:

Originally Posted by

Hey Juan you are right that is a shock.

heh, heh... I knew it'd be a surprise. :-)

re:

Quote:

Originally Posted by

Am I being hacked or what?

Nope. That's just the way things work.

re:

Quote:

Originally Posted by

But why has localhost got so many connections open with lots of different ports?

Your server ( IIS 5.1 ) is listening on several ports and your active connections
( browser requests from IIS ) stay alive for the default time-to-live configured for Windows XP.

You shouldn't mess with the default time-to-live, but you can tweak
Windows XP so you can have more connections ( although you aren't supposed to ).

See :
http://www.theeldergeek.com/increas...connections.htm
and
http://www.helpwithwindows.com/WindowsXP/tune-120.html
They have the same instructions...

Note : Doing what those sites recommend implies editing the Windows Registry.

What I am telling you is not a recommendation to go ahead and hack
the Windows Registry and, if you do it, you do it at your own risk.

At the very least, backup your registry so you can restore it later in case of an "accident".
After those required disclaimers, feel free to proceed at your own risk.

:-)

Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"John Haycock" <jhayc@dotnet.itags.org.blueyonder.co.ukwrote in message
news:cZfOg.44739$89.34883@dotnet.itags.org.fe1.news.blueyonder.co.u k...

Quote:

Originally Posted by

>
"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:%23kK7LjB2GHA.3476@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

>re:

Quote:

Originally Posted by

>>I always close connections in the code

>>
>The problem is not data access connections. You're not running out of those.
>It's http connections.
>>
>Windows XP is limited to 10 connections...of all types, both incoming and outgoing.
>>
>Run this little test and you'll probably be surprised
>at the number of connections you actually have open :
>>
>Open a command window ( Start, Run, cmd ) and issue the command :
>>
>netstat -a
>>
>Make sure you're sitting down when you do that.
>I'll bet you didn't know you had so many active connections open.

>
Hey Juan you are right that is a shock. But why has localhost got so many connections open with
lots of different ports? Am I being hacked or what? As I say this is the first time in three years
I've got that error so I'm assuming I have more connections now for some reason
>
>

Thanks for the help Juan. If it keeps happening as reguarly as it is doing
lately I might just give it a tweak :)

"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
news:eDEqZbC2GHA.868@dotnet.itags.org.TK2MSFTNGP03.phx.gbl...

Quote:

Originally Posted by

re:

Quote:

Originally Posted by

>Hey Juan you are right that is a shock.

>
heh, heh... I knew it'd be a surprise. :-)
>
re:

Quote:

Originally Posted by

>Am I being hacked or what?

>
Nope. That's just the way things work.
>
re:

Quote:

Originally Posted by

>But why has localhost got so many connections open with lots of different
>ports?

>
Your server ( IIS 5.1 ) is listening on several ports and your active
connections
( browser requests from IIS ) stay alive for the default time-to-live
configured for Windows XP.
>
You shouldn't mess with the default time-to-live, but you can tweak
Windows XP so you can have more connections ( although you aren't supposed
to ).
>
See :
http://www.theeldergeek.com/increas...connections.htm
and
http://www.helpwithwindows.com/WindowsXP/tune-120.html
>
They have the same instructions...
>
Note : Doing what those sites recommend implies editing the Windows
Registry.
>
What I am telling you is not a recommendation to go ahead and hack
the Windows Registry and, if you do it, you do it at your own risk.
>
At the very least, backup your registry so you can restore it later in
case of an "accident".
After those required disclaimers, feel free to proceed at your own risk.
>
:-)
>
>
>
>
Juan T. Llibre, asp.net MVP
aspnetfaq.com : http://www.aspnetfaq.com/
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
===================================
"John Haycock" <jhayc@dotnet.itags.org.blueyonder.co.ukwrote in message
news:cZfOg.44739$89.34883@dotnet.itags.org.fe1.news.blueyonder.co.u k...

Quote:

Originally Posted by

>>
>"Juan T. Llibre" <nomailreplies@dotnet.itags.org.nowhere.comwrote in message
>news:%23kK7LjB2GHA.3476@dotnet.itags.org.TK2MSFTNGP04.phx.gbl...

Quote:

Originally Posted by

>>re:
>>>I always close connections in the code
>>>
>>The problem is not data access connections. You're not running out of
>>those.
>>It's http connections.
>>>
>>Windows XP is limited to 10 connections...of all types, both incoming
>>and outgoing.
>>>
>>Run this little test and you'll probably be surprised
>>at the number of connections you actually have open :
>>>
>>Open a command window ( Start, Run, cmd ) and issue the command :
>>>
>>netstat -a
>>>
>>Make sure you're sitting down when you do that.
>>I'll bet you didn't know you had so many active connections open.

>>
>Hey Juan you are right that is a shock. But why has localhost got so many
>connections open with lots of different ports? Am I being hacked or what?
>As I say this is the first time in three years I've got that error so I'm
>assuming I have more connections now for some reason
>>
>>

>
>
>

Tuesday, March 13, 2012

Strange problem on database update

Does anyone have this problem before, I was developing asp.net 2.0 using VS
2005, everything works fine, I had used "Publish Web Site" to deploy my app.
on local machine's IIS, works as I expected too.
But today, when I use same method to deploy my solution on my IIS, while I
do the testing, any function which requires performing action query on my
Access DB, the web page displayed following error:
Operation must use an updateable query
Exception Details: System.Data.OleDb.OleDbException: Operation must use an
updateable query.
Other than that, all "retrieve" data operation to display records on web
pages had no problem. If I use VS 2005 to run my app. this problem does not
occur, I had also copy the same folder of IIS to another machine, this
problem doesn't occur.
Does anyone know what would be the problem on my IIS or something else?This must be a security problem. If the process does not have access to
Change the MDB (or MDE) Access file then the database becomes read-only
and you cannot update. Make sure that the ASPNET local account in the
computer were IIS is running has Change rights on the MDB or MDE file.
Hope this helps.
thanks very much, you are absolutely right. I'm using WinXP as my IIS
platform for testing, once i share the web site's folder to "Allow network
users to change my files", the update operation working now!
If I don't want to share the directory this way. You mentioned setting
ASPNET local account to have change rights! how do you properly do this in
Win XP?
"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegroups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
>
goodie, i went to my IIS root directory (C:\Inetpub\wwwroot) to add ASPNet
account to have write permission, which i think is a more proper way of
setting it up!
thanks for your help anyway!
"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegroups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
>

Strange problem on database update

But today, when I use same method to deploy my solution on my IIS, while I
do the testing, any function which requires performing action query on my
Access DB, the web page displayed following error:

Operation must use an updateable query
Exception Details: System.Data.OleDb.OleDbException: Operation must use an
updateable query.

Other than that, all "retrieve" data operation to display records on web
pages had no problem. If I use VS 2005 to run my app. this problem does not
occur, I had also copy the same folder of IIS to another machine, this
problem doesn't occur.

Does anyone know what would be the problem on my IIS or something else?This must be a security problem. If the process does not have access to
Change the MDB (or MDE) Access file then the database becomes read-only
and you cannot update. Make sure that the ASPNET local account in the
computer were IIS is running has Change rights on the MDB or MDE file.

Hope this helps.
thanks very much, you are absolutely right. I'm using WinXP as my IIS
platform for testing, once i share the web site's folder to "Allow network
users to change my files", the update operation working now!

If I don't want to share the directory this way. You mentioned setting
ASPNET local account to have change rights! how do you properly do this in
Win XP?

"Neutrino" <neo_virtual@.yahoo.com> wrote in message
news:1145249072.160245.235360@.v46g2000cwv.googlegr oups.com...
> This must be a security problem. If the process does not have access to
> Change the MDB (or MDE) Access file then the database becomes read-only
> and you cannot update. Make sure that the ASPNET local account in the
> computer were IIS is running has Change rights on the MDB or MDE file.
> Hope this helps.
goodie, i went to my IIS root directory (C:\Inetpub\wwwroot) to add ASPNet
account to have write permission, which i think is a more proper way of
setting it up!

thanks for your help anyway!

Saturday, March 31, 2012

strange authentication dialog

strange authentication dialog

Monday, March 26, 2012

Strange css problem (bug?)

Strange css problem (bug?)

Strange DataView Problem

Strange Date Problem

Thursday, March 22, 2012

Strange IIS connection error

Tuesday, March 13, 2012

Strange problem on database update

Strange problem on database update

IIS Issue

Blog Archive

About Me