IIS Only Opens One Database Connection At A Time - Mailing list pgsql-odbc

hello!

I'm using Postgresql database from IIS/ASP with ODBC driver ( psqlodbc-08_02_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  
queries - for example, different uses run SELECTs from different tables, there are no transactions, no deadlocks. no
updates.

I can see it also from pgadmin - there's only one connection from web-server -
and from ODBC logs:

[0.015]conn=026435D0, PGAPI_DriverConnect(out)='DRIVER={PostgreSQL
Unicode};DATABASE=***;SERVER=***;PORT=5432;UID=***;PWD=;SSLmode=disable;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=1;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;XaOpt=1;AB=10;'

[24.687]conn=026435D0, query='select prar_cbo.uuid, substring(prar_cbo.identifier_ from 4 for 1) || '.' ||
substring(prar_cbo.identifier_from 9 for 1) as prar from tbl_ccam_program_action prar join tbl_ccam_corebo prar_cbo on
prar.uuid=prar_cbo.uuidorder by prar_cbo.identifier_' 

[24.703]    [ fetched 22 rows ]

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

[24.718]    [ fetched 7 rows ]


conn=026435D0 – the same connection ID

If I open two or more connections from my script, they open normally, but when users run it simultaneously, they still
usethe 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=PostgreSQL Unicode
UID=***
AB=10
XaOpt=1
LowerCaseIdentifier=0
UseServerSidePrepare=0
ByteaAsLongVarBinary=0
BI=0
TrueIsMinus1=0
DisallowPremature=0
UpdatableCursors=1
LFConversion=1
ExtraSysTablePrefixes=dd_
CancelAsFreeStmt=0
Parse=0
BoolsAsChar=1
UnknownsAsLongVarchar=0
TextAsLongVarchar=1
UseDeclareFetch=0
Ksqo=1
Optimizer=0
CommLog=0
Debug=0
MaxLongVarcharSize=8190
MaxVarcharSize=255
UnknownSizes=0
Socket=4096
Fetch=100
ConnSettings=
ShowSystemTables=0
RowVersioning=0
ShowOidColumn=0
FakeOidIndex=0
Protocol=7.4-1
ReadOnly=0
SSLmode=disable
PORT=5432
SERVER=***
DATABASE=***

_________________________________________________________________
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/