ASP.NET

Re: Access Denied using VB.Net 2005 and Crystal 11.5 R2

11-Oct-06 15:02

Professorewan wrote:
Exception Details: System.Runtime.InteropServices.COMException: Access is denied.

Looks like the COM access permission, not the permission to the folder, you might want to check if the ASPNET process identity has the permission to work with the COM object, for details you can see Process and request identity in ASP.NET[^]

Professorewan19-Oct-06 11:03

Professorewan

19-Oct-06 11:03

I added the userName="SYSTEM" password="AutoGenerate" to the processmodel and this still did not work.

Is there any other suggestions.

Thank you Smile | :)

Re: Access Denied using VB.Net 2005 and Crystal 11.5 R2

minhpc_bk19-Oct-06 14:49

Re: Access Denied using VB.Net 2005 and Crystal 11.5 R2

19-Oct-06 14:49

You might try to use the dcomcnfg tool to grant the permissions to the account that runs the ASPNET process.

Vasudevan Deepak Kumar12-Oct-06 4:41

Vasudevan Deepak Kumar

12-Oct-06 4:41

Professorewan wrote:
Line 424: oRpt.Load("d:\mcsistest\" & dbrptName)

The most probable cause might be an NTFS permission on the quoted folder.

Vasudevan Deepak Kumar
Personal Homepage
namespace LavanyaDeepak
Personal Weblog
The World of Deepak and Lavanya
Views and Reviews

Label control's text property

Rohde11-Oct-06 5:58

Rohde

11-Oct-06 5:58

I've searched the 'net but can't seem to find the answer to this.

I'm using the Label to hold some HTML text read in from a database. So I'm curious what the character limit on the text property is (if there is any). Anyone know?

Re: Label control's text property

minhpc_bk11-Oct-06 15:15

Re: About Annotation [modified]

11-Oct-06 15:15

Do you mean the limit on size or special characters? You may probably know that the Label control renders to a Span element at the client size, and I see no limit on what is put inside between the open and close tags of the span element.

http://msdn.microsoft.com/workshop/author/dhtml/reference/objects/span.asp[^]
http://www.w3.org/TR/html401/struct/global.html#edef-SPAN[^]

About Annotation

sribachana11-Oct-06 2:57

sribachana

11-Oct-06 2:57

How to insert Annotation to some part of the text in a document using javascript.

Re: About Annotation

Mike Ellison11-Oct-06 5:42

Mike Ellison

11-Oct-06 5:42

Okay. What have you tried so far?

sribachana12-Oct-06 1:15

sribachana

12-Oct-06 1:15

i have captured the screen coordinates when mouse is clicked on the page.

i have designed one control in which we can add annotation.From the captured screen coordinates, i have drawn a polygon that was created using javascript
towards the control.

While in runtime when you move the control vertically or horizantally,the polygon that is drawn should move accordingly with respect to the coordinates of the control.

The way the polygon is drawn dynamically is not working properly.

So looking out for an Annotation tool(javascript based).

-- modified at 7:28 Thursday 12th October, 2006

Re: About Annotation

Mike Ellison12-Oct-06 6:20

Mike Ellison

12-Oct-06 6:20

So it sounds like you started developing your own solution, but would now like to get a tool that can do this, yes?

If you know how to use Google, you might try there. I did a quick search and one of the first links that came back was this:
http://fotonotes.net/[^]

RequiredFieldValidation

MHASSANF11-Oct-06 2:43

MHASSANF

11-Oct-06 2:43

i have a Funny Problem
when i use RequiredFieldValidation Control With Validation Summary an use them in my local pc they works good (ClientSide & serverSide)
But when i Upload the site on the internet Only ClientSide is Worked ( )
and serverside codes dosn't work (in asp.net1.1)( don't see any effect when all textbox is filled )
how can i solve it ??

With Thanks ....

MHF

Re: RequiredFieldValidation

minhpc_bk11-Oct-06 15:17

Problem with sqlserver connections not closing

11-Oct-06 15:17

With the ASP.NET 1.1, what you might need to check is the client side validation script that should appear in the folder aspnet_client at root.

macca2411-Oct-06 1:39

11-Oct-06 1:39

I have an application which has dropdown list which is populated with values from a database table. The dropdown list is populated by a subroutine which in turn calls a function. The function uses a stored procedure to get the datat for the dropdown from the database table. Here is the code that is used:

THIS IS THE SUBROUTINE

Private Sub GetDepartments()
'************************************************************
' This method populates the Depts dropdown with a list
' of departments
'************************************************************

MODULE_NAME = "GetDepartments"

Dim oStaff As Staff
Dim oDR As SqlDataReader

Try
oStaff = New Staff
oDR = oStaff.GetDepartments()

ddlSignedBy.Items.Add(New ListItem("", 0))
While oDR.Read()
ddlSignedBy.Items.Add(New ListItem(oDR("Dept_tdp").ToString(), oDR("DeptId_tdp").ToString()))
End While
oDR.Close()

Catch objException As Exception
'Display the exception message
Dim strError As String = objException.Message
If Not IsNothing(objException.InnerException) Then
strError += objException.InnerException.Message
End If

Finally
' Clean Up
oStaff = Nothing
oDR = Nothing
End Try

End Sub

THIS IS THE FUNCTION IT CALLS

Public Function GetDepartments() As SqlDataReader
'****************************************
' This method gets list of departments
'****************************************

MODULE_NAME = "GetDepartments"

Dim Conn As New SqlConnection(sqlcon)
Dim SqlCom As SqlCommand
Dim Param As SqlParameter

Try
Conn.Open()

SqlCom = New SqlCommand("sproc_GetDept", Conn)
SqlCom.CommandType = CommandType.StoredProcedure

Return SqlCom.ExecuteReader()

Catch objException As Exception
'Raise an exception
Dim strError As String = " [SubClass: " & CLASS_NAME & ", SubModule: " & MODULE_NAME & "] " & objException.Message
If Not IsNothing(objException.InnerException) Then
strError += objException.InnerException.Message
End If

Throw (New Exception(strError))

Finally
' Clean Up
SqlCom.Dispose()
SqlCom = Nothing
Conn = Nothing

End Try

End Function

The problem I have is that the database connection that is opened by the Stored Procedure sproc_GetDept is not getting closed. If I decide to close the connection in the Function then the oDR.Read cannot perform in the Subroutine.
Thsi is causing all the connections in the connection pool of the database to be used up.

Anyone any ideas how toget over this.

Thanks
macca

l0kke11-Oct-06 4:08

l0kke

11-Oct-06 4:08

Well, maybe I don't understand your problem correctly, but why you don't close your connection in finally {...} block?

Pilo

macca2411-Oct-06 5:06

11-Oct-06 5:06

If I close connection in finally I need to close it in the function, this solves that problem but this causes another problem that the datareader does not read in the Subroutine because the connection is closed. I cannot close the connection in the finally of the Subroutine as it has been opened in the function.

I may just have to put everything in the Subroutine and just not bother splitting my code up into the Function.

macca

l0kke11-Oct-06 5:03

l0kke

11-Oct-06 5:03

I see now...

you should initialize your connection object in Sub, pass it to Function as a parameter and close it in Sub after use. Or you can have your Function returning something else than SqlDataReader, DataTable for example, so you dont need to use connection in Sub and you can close it in Function.

Pilo

Ramasubramaniam11-Oct-06 5:30

Ramasubramaniam

11-Oct-06 5:30

Hi,
We have to use the below overloaded method on the executereader method of the command obect to close the connection automatically, otherwise we have to cloase manually.

objCommand.ExecuteReader(CommandBehavior.CloseConnection)

Ram

macca2411-Oct-06 5:34

11-Oct-06 5:34

Could you give me an example of this being used in some code.

macca

macca2411-Oct-06 23:07