I am developing logging application with asp.net & vb.net & OracleAt present I'm using this mechanism to write logs
Method1 Connect (
Try{
Conn.open ()
[code]...
I am new in Asp.net with Oracle and not build proper connection in it.
View 2 RepliesI am currently working on the connection between ASP.NET and Oracle. I tried to search over the net and know there are many ways. Is there any 'normal practice' on which method to be used? Or it depends?
In the Web.Config
[code]...
I am connecting to Oracle database from .net using OLEDB.
My Connection string :
[Code]....
I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.
1) Is there any other connection string without username and password with oledb?
2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?
string sConnectionString = "Provider=OraOLEDB.Oracle;"
I am starting a new project where I have to use oracle and asp.net. Oracle 11 enterprise edition. Problem is oracle database reside in linux server and application server is in windows. My question is1. Is there any problem connecting oracle from asp.net?
View 1 RepliesI am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
I should be closing my readers and connections in a more robust way? Some of my questions are:
- If a try-catch block is used, should the closures be done in the Finally section? Or in the main Try section?
- Should all closures assess whether or not the control is already open before closing (to prevent error)? (see closure of conn below)
- Are there any other preferable ways of handling this? Trying to improve my code!
[Code]....
I'm trying to complete a regular expression that will pull out matches based on their opening and closing characters, the closest I've gotten is
^([[)[a-zA-Z.-_]+(]])
Which will match a string such as "[[word1]]" and bring me back all the matches if there is more than one, The problem is I want it to pick up matchs where there may be a space in so for example "[[word1 word2]]", now this will work if I add a space into my pattern above however this pops up a problem that it will only get one match for my entire string so for example if I have a string
"Hi [[Title]] [[Name]] [[surname]], How are you"
then the match will be "[[Title]] [[Name]] [[surname]]" rather than 3 matches "[[Title]]", "[[Name]]", "[[surname]]". I'm sure I'm just a char or two away in the Regex but I'm stuck, How can I make it return the 3 matches.
i need to store opening and closing time of Restaurants in database as well as compare them with current time to see whether it is closed or open when user is viewing it... How to do??
i am not able think how to desing UI through which resturant owner can save opening n closing time for their resturant ? like what control.
i need to save like in Database.
Rid opening closing
1 10.30 AM 6.45 PM
[code]....
how to circulate the running of the codes after opening the page once and closing it soon
I'm trying to run the templated user control example provided by MSDN. Code is as follows:
So according to MSDN this should implement as follows:
[code]...
Designer complains that content is not allowed between the opening and closing tags of TemplatedFirstControl and that FirstTemplate is not supported. So what's missing? I duplicated MSDN's code verbatim
MSDN Article: [URL]
The problem is accordion's showed on the page, but doesn't works. I try use code of all examples, but the problem is the same for all of them. I don't understand what to do, because the code is the same as in the tutorials. When I click on the pane it doesn't changing/closing/opening. What can it be?
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajaxToolkit" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> [code]....
I just upgraded from VWD 200t to VWD 2010. I'm now seeing an error message that I never saw before. Error is: 'Text is not allowed between the opening and closing tags for element SqlDataSource'
Here is my HTML:
[Code]....
There is a green squiggly line under SqlDataSource, here:
asp:SqlDataSource ID="SqlDataSource2"
I have a similar problem here:
[Code]....
Like above, there is a green squiggly line under SqlDataSource, here:
asp:SqlDataSource ID="SqlDataSource3"
How to add opening and closing effects of bootstrap model popup on Modelpopup Extender. I have tried but not solved this issue....
Look at this bootstrap model popup link .it open from top when click on demo button [URL] ....
How do I turn off the feature where closing tags are automatically inserted when an opening tag is typed? I want all auto text turned off.
View 1 RepliesI have an application, which connects to a Oracle 10g R2 database, but what it is doing is opening lots and lots of connections and is not disposing them.
My application is using the MVC model, and I have Database Connection Class, which on unload of the page calls my dispose method, which consists the dispose and close commands. Further, on model control, on each of methods requesting data from the database, I am calling the close method on Oracle Data Reader.
I know I've seen this in one of the video tutorials but I have no idea which one and I have reinstalled VS since then. I think it was Chris Pels that showed how to set up VS so that you had IntelliSense for XML files. The reason I ask is because I'm going through the Security tutorials series and working on the web.config file and the editor doesn't highlight the closing or opening tag when you click on one or the other like it does for HTML or C#.
Not sure if I'm explaining this clearly or not. When working with HTML or C# I can click on the opening tag for an element, say a div tag and VS will bold the type of the closing div tag. This makes it easy to be sure that I'm not messing up my tags. Well this doesn't happen with an XML document. I saw in one of the videos where the author configured the settings in VS so that IntelliSense would work in an XML document. I just don't remember the path to those settings or what changes were made.
I'm trying to make sure a block of code behind properly closes a connection to SQL after it's finished. But when I add the line "cmd.Connection.Close();" Visual Studio underlines "cmd" in green and says "unreachable code detected" What does that mean and how do I correct it?
[Code]....
I am using a AccessDatasource for getting values from a accessdatabase for a Dropdown list. After i load the page and close it, a .ldb file is created. After wards i am not able to open the database manually. How to close the connection. I have given Network service Modify access [URL] to share permission, still no go.
View 3 RepliesI have a program that calls a thread, which starts an oracle connection and runs a query that takes about 5 minutes to complete. I want the user to be able to cancel the action if desired. When I call the Close() method on the connection, it takes a good 2 - 3 minutes to close the connection, and then the thread aborts. Is there some way I can get the connection to close faster?
View 1 RepliesThis morning I found myself dealing with A SQL POOLING ERROR Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I did fix this with resetting my pooling and setting a pooling max =100 Anyway now Im starting to rethink how I open connections, dealing with errors and proper closing of connections Would you say this code below is a good way of opening, closing connections (even when errors occurred)
Dim Connection As SqlConnection
Dim myConn As String = (ConfigurationManager.ConnectionStrings("MyConnString").ConnectionString)
Connection = New SqlConnection(myConn)
Try
Dim DBCommand As SqlCommand
Dim dt As New DataTable()
Dim myDataSet As New DataSet
Connection.Open()
DBCommand = New SqlCommand("GetAllCategories_", Connection)
DBCommand.CommandType = CommandType.StoredProcedure
DBCommand.Parameters.Add("@HomePageID", SqlDbType.Int).Value = HiddenChosenVirtualMainID.Value
Dim mySqlAdapter As New SqlDataAdapter(DBCommand)
mySqlAdapter.Fill(dt)
SecondLevelChildDatalist.DataSource = dt
SecondLevelChildDatalist.DataBind()
Catch ex As Exception
'Error goes here
SqlConnection.ClearAllPools()
Finally
'close the connction
Connection.Close()
Connection.Dispose()
End Try
I have written a routine to delete a record from a table. I want to include a statement to 'close' the connection to the table but I do not know the syntex of the statement that will do this. My code is as follows:
[code]....
I am using a adapted version ofhttp://www.mikesdotnetting.com/Article/45/Programmatically-accessing-data-from-DataSource-controlsDon't we need something like a closing-routine / close connection command after getting data from the database?If yes: What is the correct closing command?
View 2 RepliesI was wondering about something. I'm supporting a .NET C# application which has a number of database connections declared locally as IDbConnection with MS SQL Server and NHibernate. These connections are declared locally and not explicitly closed after a specific operation is performed. Are these connections automatically closed after the local method is executed, or could these connections be floating around somewhere? We're having semaphore max out problems, and I'm trying to see if this may be the culprit. I'm doubtful, as I believe these connections would automatically close, but thought I'd throw out hte possibility.
View 1 Replies