Thread: What connection string driver options are available in psqlodbc_08_04_0100 ? Any documentation?
What connection string driver options are available in psqlodbc_08_04_0100 ? Any documentation?
From
Jalaj Negi
Date:
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
Re: What connection string driver options are available in psqlodbc_08_04_0100 ? Any documentation?
From
"Albe Laurenz"
Date:
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