1
Answer

I am getting a pooling error from my database in C#.net

santhosh kumar

santhosh kumar

10y
693
1
"time out expired. the timeout period elapsed prior to obtaining a connection from the pool"

I  am getting this error when having more data in database and it is showing this error can anyone help me to solve this issue.

Answers (1)
0
Midhun T P
NA 19.7k 281.2k 8y
Hi,
I don't think it is possible to achieve what you are looking with a single select query.
You won't get distinct from every columns while selecting multiple columns. Because distinct keyword considers whether a single row is distinct or not. Not a column. Please have a look at below link -
http://dba.stackexchange.com/questions/102677/select-distinct-on-multiple-columns
0
Abhishek Chadha
NA 454 26.3k 8y
your logic is true
could you post the screenshots of the table with data