
What connection string driver options are available in
--00221532c7a4e485060470872076
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hello,
1) I need to know all the connection string driver options available with
psqlodbc_08_04_0100. Is there any documentation for it?
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?
regards,
jalaj negi
--00221532c7a4e485060470872076
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
<div>Hello, </div>
<div>=A0</div>
<div>1) I=A0need to know all the connection string driver options available=
with psqlodbc_08_04_0100.=A0Is there any documentation for it? </div>
<div>=A0</div>
<div>2) Is there any option from where I can specify SSL Certificate file n=
ame in connection string?=A0 In libpq <font face=3D"Courier New">sslcert, s=
slkey, sslrootcert, sslcrl </font><font face=3D"arial,helvetica,sans-serif"=
>options are available for same. </font><font face=3D"arial,helvetica,sans-=
serif">Are they available with psqlodbc_08_04_0100?</font></div>
<div>=A0</div>
<div>=A0</div>
<div>regards,</div>
<div>jalaj negi</div>
<div><font face=3D"Courier New"></font>=A0</div>
--00221532c7a4e485060470872076--
Re: 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~/psqlo dbc/psqlodbc/do=
cs/config.html?content-type=3Dtext/html&only_with_tag=3DREL- 08_04_0100
and
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlo dbc/psqlodbc/do=
cs/config-opt.html?content-type=3Dtext/html&only_with_tag=3D 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
--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
ODBC driver & connection limit
Hi all,
Does PostgreSQL ODBC driver has a connection limit ? If so, how we can
change this ?
Adnan DURSUN
--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Re: ODBC driver & connection limit
On Thu, Aug 20, 2009 at 4:15 AM, Adnan DURSUN<a_dursun [at] hotmail.com> wrote:
> =A0 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.htm=
l#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
--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Re: ODBC driver & connection limit
----- Original Message -----
>From: "Richard Broersma" <richard.broersma [at] gmail.com>
>To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
>Cc: <pgsql-odbc [at] 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
--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Re: ODBC driver & connection limit
Adnan DURSUN wrote:
>
> ----- Original Message -----
>> From: "Richard Broersma" <richard.broersma [at] gmail.com>
>> To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
>> Cc: <pgsql-odbc [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Re: ODBC driver & connection limit
After which version of psqlODBC driver the limitation was removed ?
Regards,
Adnan DURSUN
----- Original Message -----
From: "Hiroshi Inoue" <inoue [at] tpf.co.jp>
To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
Cc: <pgsql-odbc [at] 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 [at] gmail.com>
>>> To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
>>> Cc: <pgsql-odbc [at] 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 [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>
--
Sent via pgsql-odbc mailing list (pgsql-odbc [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
Re: ODBC driver & connection limit
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 [at] tpf.co.jp>
> To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
> Cc: <pgsql-odbc [at] 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 [at] gmail.com>
>>>> To: "Adnan DURSUN" <a_dursun [at] hotmail.com>
>>>> Cc: <pgsql-odbc [at] 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 [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc