Oninit cdi / Archive
Talk to an expert →

C-SDK: Connection with DBDATE-Parameter

Posted in 2009

Topics: Connectivity: ODBC / JDBC / .NET, Internationalization & Character Sets

Martin Thole — — source: Usenet: comp.databases.informix

When opening a connection, you can specify a lot of parametesr: Server, Database, Host, UID, DBLOCALE ... But can we set the environment variables (from SETNET32) from the appliction ? How can we set DBDATE oder DBMONEY ? Example: DSN=IFXODBC;SERVER=ifx_vmsles;Host=vmsles11;Database=obserwer;UID=obs;PWD=xxxxt;PROTOCOL=olsoctcp;SERVICE=9088; USESERVERDBLOCALE;CURB=1;SCUR=1;ICUR=1;OAC=1;OPTOFC=1;RKC=1 works fine. But when we added "DBDATE=DMY4." it doesn't change the global settings from SETNET32 ? Thanks Martin Thole ------------------------------------------------------------------------------------ OBS GmbH L'tticher Stra'e 218 52074 Aachen Tel. 0241/71018 Fax 0241/78539 Email: info@o-b-s.de Web: www.o-b-s.de ---------------------------------------------------------------------

↪ replying to Martin Thole
Art Kagel — — source: Usenet: comp.databases.informix

DBDATE is picked up from the user's environment, so on Windows you can set them from setnet32 or in the environment before starting the application. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 18, 2009 at 3:57 AM, Martin Thole <mth@o-b-s.de> wrote: > When opening a connection, you can specify a lot of parametesr: Server, > Database, Host, UID, DBLOCALE ... > > But can we set the environment variables (from SETNET32) from the > appliction > ? > How can we set DBDATE oder DBMONEY ? > > > Example: > > DSN=IFXODBC;SERVER=ifx_vmsles;Host=vmsles11;Database=obserwer;UID=obs;PWD=xxxxt;PROTOCOL=olsoctcp;SERVICE=9088; > USESERVERDBLOCALE;CURB=1;SCUR=1;ICUR=1;OAC=1;OPTOFC=1;RKC=1 > works fine. > > But when we added "DBDATE=DMY4." it doesn't change the global settings from > SETNET32 ? > > > Thanks > > Martin Thole > > > ------------------------------------------------------------------------------------ > OBS GmbH > Lütticher Straße 218 > 52074 Aachen > Tel. 0241/71018 > Fax 0241/78539 > Email: info@o-b-s.de > Web: www.o-b-s.de > --------------------------------------------------------------------- > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >

↪ replying to Art Kagel
Martin Thole — — source: Usenet: comp.databases.informix

> DBDATE is picked up from the user's environment, so on Windows you can > set them from setnet32 or in the environment before starting the > application. Yes, we know setnet32 and use this util since many years. But the disadvantage is, that every user can change his settings. Therefore we would prefer to set this environment variables by the application. Martin "Art Kagel" <art.kagel@gmail.com> schrieb im Newsbeitrag news:mailman.394.1261133135.6236.informix-list@iiug.org... DBDATE is picked up from the user's environment, so on Windows you can set them from setnet32 or in the environment before starting the application. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 18, 2009 at 3:57 AM, Martin Thole <mth@o-b-s.de> wrote: When opening a connection, you can specify a lot of parametesr: Server, Database, Host, UID, DBLOCALE ... But can we set the environment variables (from SETNET32) from the appliction ? How can we set DBDATE oder DBMONEY ? Example: DSN=IFXODBC;SERVER=ifx_vmsles;Host=vmsles11;Database=obserwer;UID=obs;PWD=xxxxt;PROTOCOL=olsoctcp;SERVICE=9088; USESERVERDBLOCALE;CURB=1;SCUR=1;ICUR=1;OAC=1;OPTOFC=1;RKC=1 works fine. But when we added "DBDATE=DMY4." it doesn't change the global settings from SETNET32 ? Thanks Martin Thole ------------------------------------------------------------------------------------ OBS GmbH L'tticher Stra'e 218 52074 Aachen Tel. 0241/71018 Fax 0241/78539 Email: info@o-b-s.de Web: www.o-b-s.de --------------------------------------------------------------------- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Martin Thole
Joerg Volz — — source: Usenet: comp.databases.informix

We set the Environment during start-up of the application in the registry before we open any connection. Jörg Volz --------------------------------------------- ________________________________ Von: informix-list-bounces@iiug.org im Auftrag von Martin Thole Gesendet: Fr 18.12.2009 15:17 An: informix-list@iiug.org Betreff: Re: C-SDK: Connection with DBDATE-Parameter > DBDATE is picked up from the user's environment, so on Windows you can > set them from setnet32 or in the environment before starting the > application. Yes, we know setnet32 and use this util since many years. But the disadvantage is, that every user can change his settings. Therefore we would prefer to set this environment variables by the application. Martin "Art Kagel" <art.kagel@gmail.com> schrieb im Newsbeitrag news:mailman.394.1261133135.6236.informix-list@iiug.org... DBDATE is picked up from the user's environment, so on Windows you can set them from setnet32 or in the environment before starting the application. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 18, 2009 at 3:57 AM, Martin Thole <mth@o-b-s.de> wrote: When opening a connection, you can specify a lot of parametesr: Server, Database, Host, UID, DBLOCALE ... But can we set the environment variables (from SETNET32) from the appliction ? How can we set DBDATE oder DBMONEY ? Example: DSN=IFXODBC;SERVER=ifx_vmsles;Host=vmsles11;Database=obserwer;UID=obs;PWD=xxxxt;PROTOCOL=olsoctcp;SERVICE=9088; USESERVERDBLOCALE;CURB=1;SCUR=1;ICUR=1;OAC=1;OPTOFC=1;RKC=1 works fine. But when we added "DBDATE=DMY4." it doesn't change the global settings from SETNET32 ? Thanks Martin Thole ------------------------------------------------------------------------------------ OBS GmbH Lütticher Straße 218 52074 Aachen Tel. 0241/71018 Fax 0241/78539 Email: info@o-b-s.de Web: www.o-b-s.de --------------------------------------------------------------------- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list IT Handel und Beratung Jörg Volz Bernhard-Früh-Str. 7 77855 Achern GERMANY Tel: +49 (0)7841-681651 Fax: +49 (0)7841-681654 Mobil: +49 (0)170-2989757 VAT-ID: DE201383541 http://www.it-volz.de