Oracle Connection String in asp.net c#

mudar dastam

11y1.2k.NET

Please help.....

I'm using c# asp.net and oracle database, And here is my connection string

static string strConnection = "Data Source=test;User ID=testing;Password=test123";

public OracleConnection DbConn = new OracleConnection(strConnection);

DbConn.Open();

i did anything from own idea but it doesn't work.

thank you.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

mudar dastam11y ago
yes i did. and i checked all the connection string it is properly opened and properly closed. i think this is from asp.net side problem.
0
Manas Mohapatra11y ago
1. Did you go through the link I provided.
2. Please make sure that you are closing the connection.

Ask your administrator to increase sessions in Oracle database.
0
mudar dastam11y ago
regarding the database i don't have an authorized to modify or do something else, but the session parameter it is already increased by the oracle administrator. it was 5 session parameter limits now it's 10 session parameter limits. but still the same error. by the way thanks for help.
0
Manas Mohapatra11y ago
As per your error, it is using all the sessions in Oracle DB Server. There is no session available for next call so you are getting error. You need to increase session values Oracle DN Server.

Please go through below article:

http://nimishgarg.blogspot.in/2011/11/ora-00018-maximum-number-of-sessions.html

If doesn't resolve your problem please details here.
+1