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