firebird-odbc-devel

[Firebird-odbc-devel] Connection string default values

[Jorge A. B. <jor...@gm...>]

I can write a connectoin string like "DRIVER=Firebird/InterBase(r)
driver;UID=SYSDBA;PWD=masterkey;DBNAME=server:database" and works.
But there are several configurable parameters, acording to odbc driver docs:

*Verbose keyword* *Short form*
  Database Account   *UID* or *USER*
  Password   *PWD* or *PASSWORD*
  Role   *ROLE*
  Data Source Name   *DSN*
  Driver   *DRIVER*
  Database   *DBNAME* or *DATABASE*
  Client   *CLIENT*
  Character Set   *CHARSET* or *CHARACTERSET*
  Set read only   *READONLY*
  Set nowait   *NOWAIT*
  Dialect   *DIALECT*
  Set quoted identifier   *QUOTED*
  Set sensitive identifier   *SENSITIVE*
  Set auto quoted identifier   *AUTOQUOTED*
  File DSN   *FILEDSN*
  Save DSN   *SAVEDSN*
It not defined explicitly, what are the default values for each attribute?
(I´m interested particularly in those which admit "Y/N" values.
Thanks!

Re: [Firebird-odbc-devel] Connection string default values

[Alexander P. <ale...@gm...>]

Jorge,

You can see all default values in new DSN Windows dialog
Client will be gds32.dll, Driver is not used now.


On 13.10.2017 20:34, Jorge Andres Brugger wrote:
> I can write a connectoin string like "DRIVER=Firebird/InterBase(r) 
> driver;UID=SYSDBA;PWD=masterkey;DBNAME=server:database" and works.
> But there are several configurable parameters, acording to odbc driver 
> docs:
>
> *Verbose keyword* 	*Short form*
>   Database Account 	*UID* or *USER*
>   Password 	*PWD* or *PASSWORD*
>   Role 	*ROLE*
>   Data Source Name 	*DSN*
>   Driver 	*DRIVER*
>   Database 	*DBNAME* or *DATABASE*
>   Client 	*CLIENT*
>   Character Set 	*CHARSET* or *CHARACTERSET*
>   Set read only 	*READONLY*
>   Set nowait 	*NOWAIT*
>   Dialect 	*DIALECT*
>   Set quoted identifier 	*QUOTED*
>   Set sensitive identifier 	*SENSITIVE*
>   Set auto quoted identifier 	*AUTOQUOTED*
>   File DSN 	*FILEDSN*
>   Save DSN 	*SAVEDSN*
>
>
> It not defined explicitly, what are the default values for each 
> attribute? (I´m interested particularly in those which admit "Y/N" values.
> Thanks!
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


-- 
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru

Re: [Firebird-odbc-devel] Connection string default values

[Jorge A. B. <jor...@gm...>]

Thanks Alexander!
The use of gds32 is related to keeping support to interbase? (I would
prefer fbclient.dll to be the default library, as I usually dont intall
gds32 with my programs).
I would also happy if the default value for quoted identifiers is "NO" (I.m
not sure why someone will prefer quoted identififiers over non-quoted ones)
Regards!

2017-10-14 9:18 GMT-03:00 Alexander Potapchenko <
ale...@gm...>:

> Jorge,
>
> You can see all default values in new DSN Windows dialog
> Client will be gds32.dll, Driver is not used now.
>
>
> On 13.10.2017 20:34, Jorge Andres Brugger wrote:
>
> I can write a connectoin string like "DRIVER=Firebird/InterBase(r)
> driver;UID=SYSDBA;PWD=masterkey;DBNAME=server:database" and works.
> But there are several configurable parameters, acording to odbc driver
> docs:
>
> *Verbose keyword* *Short form*
>   Database Account   *UID* or *USER*
>   Password   *PWD* or *PASSWORD*
>   Role   *ROLE*
>   Data Source Name   *DSN*
>   Driver   *DRIVER*
>   Database   *DBNAME* or *DATABASE*
>   Client   *CLIENT*
>   Character Set   *CHARSET* or *CHARACTERSET*
>   Set read only   *READONLY*
>   Set nowait   *NOWAIT*
>   Dialect   *DIALECT*
>   Set quoted identifier   *QUOTED*
>   Set sensitive identifier   *SENSITIVE*
>   Set auto quoted identifier   *AUTOQUOTED*
>   File DSN   *FILEDSN*
>   Save DSN   *SAVEDSN*
> It not defined explicitly, what are the default values for each attribute?
> (I´m interested particularly in those which admit "Y/N" values.
> Thanks!
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Firebird-odbc-devel mailing lis...@li...://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>
>
> --
> Alexander Potapchenko
> Team leader
> LASP Technologies, http://www.lasptech.ru
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>

Re: [Firebird-odbc-devel] Connection string default values

[Alexander P. <ale...@gm...>]

If gds32.dll is not found then fbclient.dll is loaded by default too.

On 16.10.2017 18:06, Jorge Andres Brugger wrote:
> Thanks Alexander!
> The use of gds32 is related to keeping support to interbase? (I would 
> prefer fbclient.dll to be the default library, as I usually dont 
> intall gds32 with my programs).
> I would also happy if the default value for quoted identifiers is "NO" 
> (I.m not sure why someone will prefer quoted identififiers over 
> non-quoted ones)
> Regards!
>
> 2017-10-14 9:18 GMT-03:00 Alexander Potapchenko 
> <ale...@gm... 
> <mailto:ale...@gm...>>:
>
>     Jorge,
>
>     You can see all default values in new DSN Windows dialog
>     Client will be gds32.dll, Driver is not used now.
>
>
>     On 13.10.2017 20:34, Jorge Andres Brugger wrote:
>>     I can write a connectoin string like
>>     "DRIVER=Firebird/InterBase(r)
>>     driver;UID=SYSDBA;PWD=masterkey;DBNAME=server:database" and works.
>>     But there are several configurable parameters, acording to odbc
>>     driver docs:
>>
>>     *Verbose keyword* 	*Short form*
>>       Database Account 	*UID* or *USER*
>>       Password 	*PWD* or *PASSWORD*
>>       Role 	*ROLE*
>>       Data Source Name 	*DSN*
>>       Driver 	*DRIVER*
>>       Database 	*DBNAME* or *DATABASE*
>>       Client 	*CLIENT*
>>       Character Set 	*CHARSET* or *CHARACTERSET*
>>       Set read only 	*READONLY*
>>       Set nowait 	*NOWAIT*
>>       Dialect 	*DIALECT*
>>       Set quoted identifier 	*QUOTED*
>>       Set sensitive identifier 	*SENSITIVE*
>>       Set auto quoted identifier 	*AUTOQUOTED*
>>       File DSN 	*FILEDSN*
>>       Save DSN 	*SAVEDSN*
>>
>>
>>     It not defined explicitly, what are the default values for each
>>     attribute? (I´m interested particularly in those which admit
>>     "Y/N" values.
>>     Thanks!
>>
>>
>>     ------------------------------------------------------------------------------
>>     Check out the vibrant tech community on one of the world's most
>>     engaging tech sites, Slashdot.org!http://sdm.link/slashdot
>>
>>
>>     _______________________________________________
>>     Firebird-odbc-devel mailing list
>>     Fir...@li...  <mailto:Fir...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel  <https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel>
>
>
>     -- 
>     Alexander Potapchenko
>     Team leader
>     LASP Technologies, http://www.lasptech.ru
>
>     ------------------------------------------------------------------------------
>     Check out the vibrant tech community on one of the world's most
>     engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>     _______________________________________________
>     Firebird-odbc-devel mailing list
>     Fir...@li...
>     <mailto:Fir...@li...>
>     https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>     <https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel>
>
>
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel


-- 
Alexander Potapchenko