Re: Can PostGreSQL handle 100 user database - more info

But there is an OLE DB provider for ODBC, so you can use ADO with an ODBC;
just not as nice.

As for the multiple connections thing, I do not know anything about that.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Elmar Haneke" <elmar(at)haneke(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, November 30, 2000 1:59 PM
Subject: Re: [GENERAL] Can PostGreSQL handle 100 user database - more info

>
>
> martin(dot)chantler(at)convergys(dot)com wrote:
> >
> > I am not sure what an ole db provider is? This must be another method of
> > talking to the server from a client application. What advantages does it
have?
>
>
> If you intend to use ADO you need an OLE-DB provider.
>
> > I have the open source ODBC client (and I know a Java version exists),
it seems
> > ok but I don't know if it handles things like transactions and other
advanced
> > functions.
>
>
> The ODBC midht cause some "interesting" trouble since VisualBasic
> tends to open multiple connections to the Server. This has tow
> disadvantages:
>
> 1. While using transaction isolation (not reading uncommitted data)
> you cannot read the data written on one connection over another one.
> If this does happen you might not immediately notive the rubbish
> happening.
>
> 2. With 100 users it might significant if there are 500 simultaneous
> connections open. At leas you have to raise the connection-limit.
>
> Elmar