|
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[^]
|
|
|
|
|
I added the userName="SYSTEM" password="AutoGenerate" to the processmodel and this still did not work.
Is there any other suggestions.
Thank you
|
|
|
|
|
You might try to use the dcomcnfg tool to grant the permissions to the account that runs the ASPNET process.
|
|
|
|
|
Professorewan wrote: Line 424: oRpt.Load("d:\mcsistest\" & dbrptName)
The most probable cause might be an NTFS permission on the quoted folder.
|
|
|
|
|
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?
|
|
|
|
|
|
How to insert Annotation to some part of the text in a document using javascript.
|
|
|
|
|
Okay. What have you tried so far?
|
|
|
|
|
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
|
|
|
|
|
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/[^]
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
Well, maybe I don't understand your problem correctly, but why you don't close your connection in finally {...} block?
Pilo
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Could you give me an example of this being used in some code.
macca
|
|
|
|
|
Thanks guys.
Got this sorted.
macca
|
|
|
|
|
I dont see you calling conn.Close() anywehere... call that method when you're done using the connection.
Nathan Lindley
.NET Aficionado
|
|
|
|
|
i m transferring data from sqlserver to sqlserver using webservices,when run the application from local machine data is getting tranferred correctly,but when i create exe and run the application the date showing one day lesser like if the date id 21/01/2006 its getting transferred as 20/01/2006
pls help me in solving
kavitha
|
|
|
|
|
please tell me about how can we pass values in a text box to another page by using QueryString
|
|
|
|
|
You can attach the value in the URL and there in the destination page you can retrive it using request.querystring
Best Regards,
Apurva Kaushal
|
|
|
|
|
can u please send me the syntax???
|
|
|
|
|
You can send value (which is kaushal in this case) with querystring like this:
string str = "../Destination.aspx?var=kaushal";<br />
Response.Redirect(str);
You can retrieve it like this in the destination page:
string str1 = Request.QueryString[var].ToString();
Best Regards,
Apurva Kaushal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
