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

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=20
> available with psqlodbc_08_04_0100. Is there any=20
> documentation for it?=20

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=20
> Certificate file name in connection string? In libpq=20
> sslcert, sslkey, sslrootcert, sslcrl options are available=20
> for same. Are they available with psqlodbc_08_04_0100?

I don't think so.

Yours,
Laurenz Albe

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@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@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 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.

--=20
Regards,
Richard Broersma Jr.

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

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@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"
>To: "Adnan DURSUN"
>Cc:
>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@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"
>> To: "Adnan DURSUN"
>> Cc:
>> 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

Re: ODBC driver & connection limit

After which version of psqlODBC driver the limitation was removed ?

Regards,
Adnan DURSUN
----- Original Message -----
From: "Hiroshi Inoue"
To: "Adnan DURSUN"
Cc:
Sent: Sunday, August 23, 2009 12:29 PM
Subject: Re: [ODBC] ODBC driver & connection limit


> Adnan DURSUN wrote:
>>
>> ----- Original Message -----
>>> From: "Richard Broersma"
>>> To: "Adnan DURSUN"
>>> Cc:
>>> 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
>

--
Sent via pgsql-odbc mailing list (pgsql-odbc@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"
> To: "Adnan DURSUN"
> Cc:
> Sent: Sunday, August 23, 2009 12:29 PM
> Subject: Re: [ODBC] ODBC driver & connection limit
>
>
>> Adnan DURSUN wrote:
>>>
>>> ----- Original Message -----
>>>> From: "Richard Broersma"
>>>> To: "Adnan DURSUN"
>>>> Cc:
>>>> 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