[mapserver-users] Number of users are connected

[Venkat Rao Tammineni]

Sir,

  I am using C# npgsql.dll I am getting this error    "Timeout while getting
a connection from pool"  sometimes. but not  every time.

 

Here is my code to connect database

 

My connection string in web config 

 <add key="ConnectionString" value="Server=localhost;port=5432;User
Id=postgres;password=mytest;Database=GIS;"/>

 

And here is my code to connect database.

public  NpgsqlConnection PgSqlDataConnection()

     {

            if (pgSqlConnection != null)

            {

                if (pgSqlConnection.State == ConnectionState.Open)

                {

                    pgSqlConnection.Close();

                    pgSqlConnection.Dispose();

                }

            }

            pgConnectionString =
ConfigurationSettings.AppSettings["ConnectionString"].ToString();

            pgSqlConnection = new NpgsqlConnection(pgConnectionString);

            

            pgSqlConnection.Open();

           

            return pgSqlConnection;

      }

 

 

I don't know where I am doing wrong ?Please guide me .

I am waiting for your great response.

 

Thanks,

Venkat

 

 

From: Tamas Szekeres [mailto:szekerest at gmail.com] 
Sent: Tuesday, January 27, 2009 8:12 PM
To: Venkat Rao Tammineni
Cc: mapserver-users
Subject: Re: [mapserver-users] Number of users are connected

 

Hi,

IIS on Windows XP is limited to 10 concurrent users, however you shouldn't
find such problems with a Windows Server OS.

Best regards,

Tamas




2009/1/27 Venkat Rao Tammineni <vtammineni at roulacglobal.com>

Dear All,

 

 

  I have developed web application using  C# asp.net 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".

 

I am waiting for your great response,

 

Advanced Thanks

 

Regards

Venkat.


_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090128/458d420e/attachment-0001.html