Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

C-SDK: Connection with DBDATE-Parameter

19 views
Skip to first unread message

Martin Thole

unread,
Dec 18, 2009, 3:57:54 AM12/18/09
to
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: in...@o-b-s.de
Web: www.o-b-s.de
---------------------------------------------------------------------


Art Kagel

unread,
Dec 18, 2009, 5:45:08 AM12/18/09
to Martin Thole, inform...@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 (a...@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 <m...@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: in...@o-b-s.de
Web:   www.o-b-s.de
---------------------------------------------------------------------



_______________________________________________
Informix-list mailing list
Inform...@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list


Martin Thole

unread,
Dec 18, 2009, 9:17:55 AM12/18/09
to
> 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....@gmail.com> schrieb im Newsbeitrag
news:mailman.394.12611331...@iiug.org...

Art


Thanks

Martin Thole

------------------------------------------------------------------------------------
OBS GmbH
L�tticher Stra�e 218

Joerg Volz

unread,
Dec 18, 2009, 9:58:29 AM12/18/09
to Martin Thole, inform...@iiug.org
We set the Environment during start-up of the application in the registry before we open any connection.
 
 
Jörg Volz
 
---------------------------------------------


Von: informix-l...@iiug.org im Auftrag von Martin Thole
Gesendet: Fr 18.12.2009 15:17
An: inform...@iiug.org
Betreff: Re: C-SDK: Connection with DBDATE-Parameter

Lütticher Straße 218


52074 Aachen
Tel. 0241/71018
Fax  0241/78539
Email: in...@o-b-s.de
Web:   www.o-b-s.de
---------------------------------------------------------------------



_______________________________________________
Informix-list mailing list
Inform...@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

 

Habichtsberg, Reinhard

unread,
Dec 21, 2009, 4:16:08 AM12/21/09
to inform...@iiug.org
May be it's possible to use GPO to prevent users to modify setnet32
configurations and the registry?
0 new messages