Обсуждение: What connection string driver options are available in psqlodbc_08_04_0100 ? Any documentation?

Jalaj Negi wrote:
> 1) I need to know all the connection string driver options
> available with psqlodbc_08_04_0100. Is there any
> documentation for it?


http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/config.html?content-type=text/html&only_with_tag=REL-08_04_0100

and


http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/config-opt.html?content-type=text/html&only_with_tag=REL-08_04_0100

> 2) Is there any option from where I can specify SSL
> Certificate file name in connection string?  In libpq
> sslcert, sslkey, sslrootcert, sslcrl options are available
> for same. Are they available with psqlodbc_08_04_0100?

I don't think so.

Yours,
Laurenz Albe

        Hi all,

    Does PostgreSQL ODBC driver has a connection limit ? If so, how we can
change this ?

Adnan DURSUN

On Thu, Aug 20, 2009 at 4:15 AM, Adnan DURSUN<a_dursun@hotmail.com> wrote:

>   Does PostgreSQL ODBC driver has a connection limit ? If so, how we can
> change this ?


As far as I know, the ODBC driver does not specify any limits.
However, the postgresql server does.   Notice the max_connection
parameter of the postgresql.conf file:

h

ttp://www.postgresql.org/docs/8.4/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS


There are other limiting factors involved beyond this setting also.

--
Regards,
Richard Broersma Jr.

Vit the LoLos Angeles PostgreSQL Users Gup (LAPUG)G)
http://pugs.postgresql.org/lapug

----- Original Message -----
>From: "Richard Broersma" <richard.broersma@gmail.com>
>To: "Adnan DURSUN" <a_dursun@hotmail.com>
>Cc: <pgsql-odbc@postgresql.org>
>Sent: Thursday, August 20, 2009 5:18 PM
>Subject: Re: [ODBC] ODBC driver & connection limit


>As far as I know, the ODBC driver does not specify any limits.
>However, the postgresql server does.

  But the psqlodbc.h file has the following line ;
#define MAX_CONNECTIONS 128 /* conns per environment * (arbitrary) */
What does that mean ?

NOTE: We will be using a windows terminal server to run our application.
Appx 500 users will use the same odbc driver.

Adnan DURSUN

Adnan DURSUN wrote:
>
> ----- Original Message -----
>> From: "Richard Broersma" <richard.broersma@gmail.com>
>> To: "Adnan DURSUN" <a_dursun@hotmail.com>
>> Cc: <pgsql-odbc@postgresql.org>
>> Sent: Thursday, August 20, 2009 5:18 PM
>> Subject: Re: [ODBC] ODBC driver & connection limit
>
>
>> As far as I know, the ODBC driver does not specify any limits.
>> However, the postgresql server does.
>
>  But the psqlodbc.h file has the following line ;
> #define MAX_CONNECTIONS 128 /* conns per environment * (arbitrary) */
> What does that mean ?

Once the connection limit was 128 but the current driver doesn't
have the limitation.

regards,
Hiroshi Inoue

        After which version of psqlODBC driver the limitation was removed ?

Regards,
Adnan DURSUN
----- Original Message -----
From: "Hiroshi Inoue" <inoue@tpf.co.jp>
To: "Adnan DURSUN" <a_dursun@hotmail.com>
Cc: <pgsql-odbc@postgresql.org>
Sent: Sunday, August 23, 2009 12:29 PM
Subject: Re: [ODBC] ODBC driver & connection limit


> Adnan DURSUN wrote:
>>
>> ----- Original Message -----
>>> From: "Richard Broersma" <richard.broersma@gmail.com>
>>> To: "Adnan DURSUN" <a_dursun@hotmail.com>
>>> Cc: <pgsql-odbc@postgresql.org>
>>> Sent: Thursday, August 20, 2009 5:18 PM
>>> Subject: Re: [ODBC] ODBC driver & connection limit
>>
>>
>>> As far as I know, the ODBC driver does not specify any limits.
>>> However, the postgresql server does.
>>
>>  But the psqlodbc.h file has the following line ;
>> #define MAX_CONNECTIONS 128 /* conns per environment * (arbitrary) */
>> What does that mean ?
>
> Once the connection limit was 128 but the current driver doesn't
> have the limitation.
>
> regards,
> Hiroshi Inoue
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>

Adnan DURSUN wrote:
>
>        After which version of psqlODBC driver the limitation was removed ?

8.2.5(or 8.2.4.02).

regards,
Hiroshi Inoue

> Regards,
> Adnan DURSUN
> ----- Original Message ----- From: "Hiroshi Inoue" <inoue@tpf.co.jp>
> To: "Adnan DURSUN" <a_dursun@hotmail.com>
> Cc: <pgsql-odbc@postgresql.org>
> Sent: Sunday, August 23, 2009 12:29 PM
> Subject: Re: [ODBC] ODBC driver & connection limit
>
>
>> Adnan DURSUN wrote:
>>>
>>> ----- Original Message -----
>>>> From: "Richard Broersma" <richard.broersma@gmail.com>
>>>> To: "Adnan DURSUN" <a_dursun@hotmail.com>
>>>> Cc: <pgsql-odbc@postgresql.org>
>>>> Sent: Thursday, August 20, 2009 5:18 PM
>>>> Subject: Re: [ODBC] ODBC driver & connection limit
>>>
>>>
>>>> As far as I know, the ODBC driver does not specify any limits.
>>>> However, the postgresql server does.
>>>
>>>  But the psqlodbc.h file has the following line ;
>>> #define MAX_CONNECTIONS 128 /* conns per environment * (arbitrary) */
>>> What does that mean ?
>>
>> Once the connection limit was 128 but the current driver doesn't
>> have the limitation.
>>
>> regards,
>> Hiroshi Inoue