473,387 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

asp.net w/ Oracle, web page connections not closing

1
Hey All,

Hoping you might be able to shed some light for me here. I've just been handed this project/website thats supposed to connect to an oracle database. Everything connects, works fine, except that the connections stay opened and eventually after a 60 second timeout period, they get sniped. I've tried setting the connection string in my config file to 'pooling = false', i've checked and rechecked every reader to make sure its closed. I've also checked and made sure the connections are closed everytime they were opened. Heres a bit of a background on the system, its running on Oracle 10g. I havent a clue as to which asp.net version its running but im using VisualWeb Developer 2005 to edit the aspx.vb pages.

heres the web.config files connection string

<connectionStrings>
<add name="Web_TrainingConnection" connectionString="Provider=OraOLEDB.Oracle;Data Source=WPGS118.cna.dfo-mpo.ca/orcl2;User Id=userid;Password=pwd; pooling=false;" providerName="System.Data.OleDb"/>
<!--<add name="Web_TrainingConnection" connectionString="Provider=SQLOLEDB;Data Source=ecburdev1;Password=pwd;User ID=userid;Initial Catalog=WebTraining " providerName="System.Data.OleDb"/>-->
</connectionStrings>

And here are the closing statements i use to close the connection

'closes the connection two ways, and should clear all the pools
If sqlCon.State <> Data.ConnectionState.Closed Then
sqlCon.Dispose()
sqlCon.Close()
SqlConnection.ClearAllPools()
End If


Thanks in advance for any ideas,

Toan
Jan 17 '08 #1
0 1205

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Shelly | last post by:
I set a session variable on error in the login page and then call the login page again. I test on that session variable but it shows as not set. I checked with an echo immediately after setting the...
3
by: Harry | last post by:
Using Oracle 8i enterprise on win 2000 (sp3) Installed the standard configuration & whenever I make a connection it takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason there...
8
by: DP | last post by:
I read some articles and post how to optimize te speed of asp pages regarding opening and closing DB connections but I am still not sure about this. Is it true that it doesn't matter how many...
0
by: ʹÃûÑï | last post by:
ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access...
4
by: Steve | last post by:
We are using ODP.net (version 9.2.0.4.01) as data provider for Oracle in our dotnet app. Currently we are using Microsoft.NET Framework 1.1 (VS.net IDE 2003) in our project. One thing I feel...
2
by: Steve Foo | last post by:
I have been posting this question in google group, EE, and Oracle OTN forum and still no cannot find a suitable solution for it. I have contacted Singapore Microsoft support regarding the problem...
11
by: Bob | last post by:
In our new .NET web applications, we try to limit the use of SqlConnection to just one instance per page, even if there are multiple accesses to various queries. The thinking behind is that this...
5
by: mortb | last post by:
Hi, I'm overriding OnUload in my pages. I've put the Connection.Close in the method. But I have noticed that the method is run twice if I do a Response.Redirect in the page. Do some one know...
9
by: Keith E. Sauvant | last post by:
Hi, we got a strange problem connecting to an Oracle database onsite with our PHP application: During CSV import job handled by our application, PHP opens up to some hundred connections to the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.