Venkat,<br><br>This question is out of the scope of MapSever, and I'm afraid we can less likely provide a meaningful answer to it.<br>You should probably post this question to the npgsql project mailing list if exits.<br>
<br>Best regards,<br><br>Tamas<br><br><br><br><br><div class="gmail_quote">2009/1/28 Venkat Rao Tammineni <span dir="ltr"><<a href="mailto:vtammineni@roulacglobal.com">vtammineni@roulacglobal.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Sir,</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> I am using C# npgsql.dll I am getting this error </span><span style="font-size: 11pt; color: red;">"Timeout
while getting a connection from pool"</span><span style="font-size: 11pt; color: rgb(31, 73, 125);"> sometimes. but not every
time.</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Here is my code to connect database</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">My connection string in web config </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span><span style="font-size: 10pt; font-family: "Courier New"; color: blue;"><</span><span style="font-size: 10pt; font-family: "Courier New"; color: maroon;">add</span><span style="font-size: 10pt; font-family: "Courier New"; color: blue;"> </span><span style="font-size: 10pt; font-family: "Courier New"; color: red;">key</span><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">=</span><span style="font-size: 10pt; font-family: "Courier New";">"<span style="color: blue;">ConnectionString</span>"<span style="color: blue;"> </span><span style="color: red;">value</span><span style="color: blue;">=</span>"<span style="color: blue;">Server=localhost;port=5432;User Id=postgres;password=mytest;Database=GIS;</span>"<span style="color: blue;">/></span></span></p>
<p><span style="font-size: 10pt; font-family: "Courier New"; color: blue;"> </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">And here is my code to connect database.</span><span style="font-size: 11pt; color: rgb(31, 73, 125);"></span></p>
<p style="text-indent: 0.5in;"><span style="font-size: 10pt; font-family: "Courier New"; color: blue;">public</span><span style="font-size: 10pt; font-family: "Courier New";"> <span style="color: teal;">NpgsqlConnection</span> PgSqlDataConnection()</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";"> {</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
<span style="color: blue;">if</span> (pgSqlConnection != <span style="color: blue;">null</span>)</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
{</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
<span style="color: blue;">if</span> (pgSqlConnection.State == <span style="color: teal;">ConnectionState</span>.Open)</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
{</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
pgSqlConnection.Close();</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
pgSqlConnection.Dispose();</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
}</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
}</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
pgConnectionString = <span style="color: teal;">ConfigurationSettings</span>.AppSettings[<span style="color: maroon;">"ConnectionString"</span>].ToString();</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
pgSqlConnection = <span style="color: blue;">new</span> <span style="color: teal;">NpgsqlConnection</span>(pgConnectionString);</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
pgSqlConnection.Open();</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
</span></p>
<p style=""><span style="font-size: 10pt; font-family: "Courier New";">
<span style="color: blue;">return</span> pgSqlConnection;</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">
}</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";"> </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";"> </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">I don't
know where I am doing wrong ?Please guide me .</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">I
am waiting for your great response.</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";"> </span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">Thanks,</span></p>
<p><span style="font-size: 10pt; font-family: "Courier New";">Venkat</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Tamas Szekeres
[mailto:<a href="mailto:szekerest@gmail.com" target="_blank">szekerest@gmail.com</a>] <br>
<b>Sent:</b> Tuesday, January 27, 2009 8:12 PM<br>
<b>To:</b> Venkat Rao Tammineni<br>
<b>Cc:</b> mapserver-users<br>
<b>Subject:</b> Re: [mapserver-users] Number of users are connected</span></p>
</div><div><div></div><div class="Wj3C7c">
<p> </p>
<p style="margin-bottom: 12pt;">Hi,<br>
<br>
IIS on Windows XP is limited to 10 concurrent users, however you shouldn't find
such problems with a Windows Server OS.<br>
<br>
Best regards,<br>
<br>
Tamas<br>
<br>
<br>
</p>
<div>
<p>2009/1/27 Venkat Rao Tammineni <<a href="mailto:vtammineni@roulacglobal.com" target="_blank">vtammineni@roulacglobal.com</a>></p>
<div>
<div>
<p>Dear All,</p>
<p> </p>
<p> </p>
<p> I have developed web application using C# <a href="http://asp.net" target="_blank">asp.net</a> and postgresql/postgis. I
have deployed in IIS .if my 10 people connected my url. I am getting
error called "More number users are connected ".I don't
know, how to solve the problem. And sometimes I am getting error called
" connection pooled".</p>
<p> </p>
<p>I am waiting for your great response,</p>
<p> </p>
<p>Advanced Thanks</p>
<p> </p>
<p>Regards</p>
<p>Venkat.</p>
</div>
</div>
<p style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></p>
</div>
<p> </p>
</div></div></div>
</div>
</blockquote></div><br>