Skip site navigation (1) Skip section navigation (2)

IIS Only Opens One Database Connection At A Time

From: Kenny Cheng <bohr936(at)hotmail(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: IIS Only Opens One Database Connection At A Time
Date: 2007-12-14 09:07:05
Message-ID: BLU122-W30626B3084737C36E9DCE4E4670@phx.gbl (view raw or flat)
Thread:
Lists: 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.uuid order 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_namespace n 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 outer join 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 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=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/

pgsql-odbc by date

Next:From: lshafranovichDate: 2007-12-14 17:33:01
Subject: weird vb6 odbc null problem
Previous:From: Hiroshi InoueDate: 2007-12-14 08:14:42
Subject: Re: odbc problem on Japanese windows machine

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group