IIS Only Opens One Database Connection At A Time

hello!

I'm using Postgresql database from IIS/ASP with ODBC driver ( psqlodbc-08_0=
2_0500 , also used previous versions)

When I run some scripts, everything works fine. But the problem is that all=
users are using the same connection to database, and the queries are being=
queued. It doesn't depend on the=20
queries - for example, different uses run SELECTs from different tables, th=
ere are no transactions, no deadlocks. no updates.

I can see it also from pgadmin - there's only one connection from web-serve=
r -=20
and from ODBC logs:

[0.015]conn=3D026435D0, PGAPI_DriverConnect(out)=3D'DRIVER=3D{PostgreSQL Un=
icode};DATABASE=3D***;SERVER=3D***;PORT=3D5432;UID=3D***;PWD =3D;SSLmode=3Dd=
isable;ReadOnly=3D0;Protocol=3D7.4-1;FakeOidIndex=3D0;ShowOi dColumn=3D0;Row=
Versioning=3D0;ShowSystemTables=3D0;ConnSettings=3D;Fetch=3D 100;Socket=3D40=
96;UnknownSizes=3D0;MaxVarcharSize=3D255;MaxLongVarcharSize= 3D8190;Debug=3D=
0;CommLog=3D1;Optimizer=3D1;Ksqo=3D1;UseDeclareFetch=3D0;Tex tAsLongVarchar=
=3D1;UnknownsAsLongVarchar=3D0;BoolsAsChar=3D1;Parse=3D0;Can celAsFreeStmt=
=3D0;ExtraSysTablePrefixes=3Ddd_;LFConversion=3D1;UpdatableC ursors=3D1;Disa=
llowPremature=3D0;TrueIsMinus1=3D0;BI=3D0;ByteaAsLongVarBina ry=3D0;UseServe=
rSidePrepare=3D0;LowerCaseIdentifier=3D0;XaOpt=3D1;AB=3D10;'

[24.687]conn=3D026435D0, query=3D'select prar_cbo.uuid, substring(prar_cbo.=
identifier_ from 4 for 1) || '.' || substring(prar_cbo.identifier_ from 9 f=
or 1) as prar from tbl_ccam_program_action prar join tbl_ccam_corebo prar_c=
bo on prar.uuid=3Dprar_cbo.uuid order by prar_cbo.identifier_'

[24.703] [ fetched 22 rows ]

[24.703]conn=3D026435D0, query=3D'select n.nspname, c.relname, a.attname, a=
..atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relh=
asrules, c.relkind, c.oid, d.adsrc from (((pg_catalog.pg_class c inner join=
pg_catalog.pg_namespace n on n.oid =3D c.relnamespace and c.oid =3D 89971)=
inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum>=
0 and a.attrelid =3D c.oid) inner join pg_catalog.pg_type t on t.oid =3D a=
..atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid =3D a.=
attrelid and d.adnum =3D a.attnum order by n.nspname, c.relname, attnum'

[24.718] [ fetched 7 rows ]


conn=3D026435D0 =96 the same connection ID

If I open two or more connections from my script, they open normally, but w=
hen users run it simultaneously, they still use the same connection.

I also use MS SQL Server - a new connection is opened for every user, so I =
expect the same from Postgres.

Below is my ODBC settings:

[ODBC]
DRIVER=3DPostgreSQL Unicode
UID=3D***
AB=3D10
XaOpt=3D1
LowerCaseIdentifier=3D0
UseServerSidePrepare=3D0
ByteaAsLongVarBinary=3D0
BI=3D0
TrueIsMinus1=3D0
DisallowPremature=3D0
UpdatableCursors=3D1
LFConversion=3D1
ExtraSysTablePrefixes=3Ddd_
CancelAsFreeStmt=3D0
Parse=3D0
BoolsAsChar=3D1
UnknownsAsLongVarchar=3D0
TextAsLongVarchar=3D1
UseDeclareFetch=3D0
Ksqo=3D1
Optimizer=3D0
CommLog=3D0
Debug=3D0
MaxLongVarcharSize=3D8190
MaxVarcharSize=3D255
UnknownSizes=3D0
Socket=3D4096
Fetch=3D100
ConnSettings=3D
ShowSystemTables=3D0
RowVersioning=3D0
ShowOidColumn=3D0
FakeOidIndex=3D0
Protocol=3D7.4-1
ReadOnly=3D0
SSLmode=3Ddisable
PORT=3D5432
SERVER=3D***
DATABASE=3D***

____________________________________________________________ _____
The best games are on Xbox 360. Click here for a special offer on an Xbox =
360 Console.
http://www.xbox.com/en-US/hardware/wheretobuy/
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate