RE: RadiusNt with Oracle

Britt-Webb Erik ( (no email) )
Thu, 29 Jan 1998 10:03:08 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BD2C9D.19749400
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

PLEASE REMOVE ME FROM YOUR LIST!!

Erik Britt-Webb
Booz-Allen & Hamilton
britt-webb_erik@bah.com
212-551-6070

> -----Original Message-----
> From: listserver [mailto:mwagers@ocsnet.net]
> Sent: Thursday, January 29, 1998 3:01 AM
> To: 'RadiusNT@iea-software.com'
> Subject: RE: RadiusNt with Oracle
>
>
>
>
> RadiusNT Digest for 28 Jan 1998
> Topics covered in this issue include:
> 1: Re: RadiusNt with Oracle
> by "Flemming Eriksen" <FE@DGnet.dk>
> 2: Installing RadiusNT v 2.2
> by "Wlodzimierz Mozol" <wlodekm@ubique.com.pl>
> 3: RE: RadiusNt with Oracle
> by Mitch Wagers <mwagers@ocsnet.net>
> 4: Re: RadiusNt with Oracle
> by "Flemming Eriksen" <FE@DGnet.dk>
> 5: RE: Installing RadiusNT v 2.2
> by "Wlodzimierz Mozol" <wlodekm@ubique.com.pl>
> 6: Radius Problem
> by Tom Bilan <Tom@tdi.net>
> 7: Re: Radius Problem
> by "Dale E. Reed Jr." <daler@iea.com>
> 8: RadiusNT 2.2 is not running properly as a service
> by "David W. Kornitz" <David.Kornitz@ZDG.com>
> 9: Re: Concurrency
> by Greg Lowthian <greg@isat.com>
> 10: Re: RadiusNt with Oracle
> by "Dale E. Reed Jr." <daler@iea.com>
> 11: Re: RadiusNt with Oracle
> by "Mitchell B. Wagers" <mwagers@ocsnet.net>
> 12: Restricting login hours
> by Greg Lowthian <greg@isat.com>
> 13: Re: Restricting login hours
> by "Dale E. Reed Jr." <daler@iea.com>
> 14: Re: RadiusNT 2.2 is not running properly as a service
> by "Dale E. Reed Jr." <daler@iea.com>
> 15: Re: RadiusNT SAM authentication
> by Michael Lohmann <michael@nettrade.com.au>
> 16: Re: Restricting login hours
> by "Ed Miller" <emiller@del.net>
> 17: Re: Concurrency
> by Greg Lowthian <greg@isat.com>
> 18: RE: RadiusNT 2.2 is not running properly as a service
> by "David W. Kornitz" <David.Kornitz@ZDG.com>
> 19: Ascend and ISDN
> by iml@interconnect.net
> 20: Re: Restricting login hours
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 21: Re: Ascend and ISDN
> by "Mitchell B. Wagers" <mwagers@ocsnet.net>
> 22: Re: Ascend and ISDN
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 23: Re: RadiusNT 2.2 is not running properly as a service
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 24: RE: Generic Domain for Proxy requests
> by Mourad Dahoumane <mdahoumane@interway.lu>
> 25: RE: Generic Domain for Proxy requests
> by Jason Hodges <jason.hodges@sprint.com.au>
> 26: Server IP
> by iml@interconnect.net
> 27: Re: Ascend and ISDN
> by iml@interconnect.net
> 28: Problem with Calls Online... Sometimes disappear eventhough client
is
> online.
> by "Rudy Komsic" <rudyk@cyberglobe.net>
> 29: Re: Problem with Calls Online... Sometimes disappear eventhough
> client is online.
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 30: Re: Ascend and ISDN
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 31: Re: Ascend and ISDN
> by iml@interconnect.net
> 32: Re: Generic Domain for Proxy requests
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 33: Re: Restricting login hours
> by David Harris <dharris@stargate.1starnet.com>
> 34: Re: RadiusNt with Oracle
> by "Flemming Eriksen" <FE@DGnet.dk>
> 35: Re: Restricting login hours
> by "Dale E. Reed Jr." <daler@iea-software.com>
> 36: RE: RadiusNt with Oracle
> by Mitch Wagers <mwagers@ocsnet.net>
>
>
>
>
> --------------------------------------------------------------------------
> 1 Message:0001 1
> --------------------------------------------------------------------------
>
>
>
> Message-ID: <00ac01bd2bdb$76808bd0$14e426c0@fe.DGnet.dk>
> From: "Flemming Eriksen" <FE@DGnet.dk>
> To: <RadiusNT@iea-software.com>
> Subject: Re: RadiusNt with Oracle
> Date: Wed, 28 Jan 1998 11:57:01 +0100
>
>
>
> Options Registry ?
> Oracle is running on a Unix Server, RadiusNT access Oracle thrue
> ODBC/SQL*Net.
> Oracle Customer Support telling me that "GetDate()" is not Standard SQL
> (ISO??)
> Is it possible to change RadiusNT's "GetDate()" to "GetDate" ?
> Flemming
>
> >Flemming Eriksen wrote:
> >>
> >> I am about to convert access database to Oracle, but inserting into
> CALLS
> is
> >> not possible.
> >> The problem is access use "GetDate()" and in Oracle I can't create a
> >> function that dosn't have a value inside "()".
> >>
> >> Do somebody have know what to do?
> >
> >You can add 16 to the Options Registry entry to have it act
> >like MS Access. I've been playing around with Oracle here and
> >trying to get RadiusNT to work with in (albeit 2.5). If people
> >think MS SQL Server is difficult to understand, they should
> >run from Oracle. Now I know what Oracle Admins get big bucks! :)
> >
> >--
> >Dale E. Reed Jr. (daler@iea.com)
> >_________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.iea-software.com
> >
> > ----------------------------------------------------------
> > RadiusNT Mailing List lists@iea-software.com
> >
>
>
>
>
> --------------------------------------------------------------------------
> 2 Message:0002 2
> --------------------------------------------------------------------------
>
>
>
> From: "Wlodzimierz Mozol" <wlodekm@ubique.com.pl>
> To: <radiusnt@iea-software.com>
> Subject: Installing RadiusNT v 2.2
> Date: Wed, 28 Jan 1998 12:02:24 +0100
> Message-ID: <01bd2bdc$36a93420$0e0b88c3@ubq1.ubique.com.pl>
>
>
>
> This is a multi-part message in MIME format.
> ------=_NextPart_000_0048_01BD2BE4.986D9C20
> Content-Type: text/plain;
> charset="iso-8859-2"
> Content-Transfer-Encoding: quoted-printable
> I tried to install RadisuNT v2.2 on NT 3.51 server, but installation =
> fails during self-registering of MFC40.DLL, does version 2.2 allow to =
> install on NT 3.51 ?
> =20
> -------------------------------------------------------------------------=
> -----------------------------------------------------
> Wlodzimierz Mozol President tel./fax +48-91-889516; =
> +48-91-890556
> Ubique Connexions mobile: +48-601-747101
> ul. Boh. Getta Warsz. 24 e-mail: =
> ubique@ubique.com.pl
> 70-302 Szczecin, Poland www: =
> http://www.ubique.com.pl
> ------=_NextPart_000_0048_01BD2BE4.986D9C20
> Content-Type: text/html;
> charset="iso-8859-2"
> Content-Transfer-Encoding: quoted-printable
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
> <HTML>
> <HEAD>
> <META content=3Dtext/html;charset=3Diso-8859-2 =
> http-equiv=3DContent-Type>
> <META content=3D'"MSHTML 4.71.2016.0"' name=3DGENERATOR>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV>
> <DIV><FONT color=3D#000000 face=3DArial size=3D2>I tried to install =
> RadisuNT v2.2 on=20
> NT 3.51 server, but installation fails during self-registering of =
> MFC40.DLL,=20
>
> does version 2.2 allow to install on NT 3.51 ?</FONT></DIV>
> <DIV><FONT color=3D#000000 face=3DArial =
> size=3D2></FONT>&nbsp;</DIV></DIV>
> <DIV><FONT color=3D#000000 face=3DArial=20
> size=3D2>----------------------------------------------------------------=
> --------------------------------------------------------------<BR>Wlodzim=
> ierz=20
> Mozol=20
> President&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
> p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
> tel./fax +48-91-889516; +48-91-890556<BR>Ubique=20
> Connexions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
> sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
> p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
> mobile: +48-601-747101<BR>ul. Boh. Getta Warsz.=20
> 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
> ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
> =20
> e-mail: <A =
> href=3D"mailto:ubique@ubique.com.pl">ubique@ubique.com.pl</A><BR>70-302=20
> Szczecin,=20
> Poland&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
> nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
> bsp;=20
> www: <A=20
> href=3D"http://www.ubique.com.pl">http://www.ubique.com.pl</A></FONT></DI=
> V></BODY></HTML>
> ------=_NextPart_000_0048_01BD2BE4.986D9C20--
>
>
>
>
> --------------------------------------------------------------------------
> 3 Message:0003 3
> --------------------------------------------------------------------------
>
>
>
> Message-ID: <01BD2BA1.0A0E4BC0@cyclops.ocsnet.net>
> From: Mitch Wagers <mwagers@ocsnet.net>
> To: "'RadiusNT@iea-software.com'" <RadiusNT@iea-software.com>
> Subject: RE: RadiusNt with Oracle
> Date: Wed, 28 Jan 1998 03:58:48 -0800
>
>
>
> They told you that isn't standard SQL? If you are talking about "SELECT
> GETDATE()," it's standard where I come from! Now, if you try a statement
> just as "GETDATE()," that will most likely fail because SQL doesn't
> understand GETDATE without SELECT or some other Action identifier. In
fact,
> I'll check the SQL book right now! Alrighty, Oracle is not correct...I
> don't see how they can claim to support SQL if they don't know SQL's
> requirements! Here's what it says in the SQL Server 6.5 Developer Book:
> GETDATE
> The GETDATE function produces the current date and time in SQL Server
> Internal format for datetime values. GETDATE takes the NULL parameter ().
> To find the current system date and time:
> SELECT GETDATE()
> ----------------------------------------------
> July 29 1995 2:50 PM
> And so on....It says it "takes the null parameter ()," which in my
> understanding of most of the SQL books, *needs* to be there to be fully
> compatible. Oracle customer support is wrong in this case, don't ya
think?
> :) I apologize if I sound a bit heated, it's a been a comparable day with
> a couple other companies.
> ----------
> From: Flemming Eriksen
> Sent: Wednesday, January 28, 1998 2:57 AM
> To: RadiusNT@iea-software.com
> Subject: Re: RadiusNt with Oracle
> Options Registry ?
> Oracle is running on a Unix Server, RadiusNT access Oracle thrue
> ODBC/SQL*Net.
> Oracle Customer Support telling me that "GetDate()" is not Standard SQL
> (ISO??)
> Is it possible to change RadiusNT's "GetDate()" to "GetDate" ?
> Flemming
>
> >Flemming Eriksen wrote:
> >>
> >> I am about to convert access database to Oracle, but inserting into
> CALLS
> is
> >> not possible.
> >> The problem is access use "GetDate()" and in Oracle I can't create a
> >> function that dosn't have a value inside "()".
> >>
> >> Do somebody have know what to do?
> >
> >You can add 16 to the Options Registry entry to have it act
> >like MS Access. I've been playing around with Oracle here and
> >trying to get RadiusNT to work with in (albeit 2.5). If people
> >think MS SQL Server is difficult to understand, they should
> >run from Oracle. Now I know what Oracle Admins get big bucks! :)
> >
> >--
> >Dale E. Reed Jr. (daler@iea.com)
> >_________________________________________________________________
> > IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> > Internet Solutions for Today | http://www.iea-software.com
> >
> > ----------------------------------------------------------
> > RadiusNT Mailing List lists@iea-software.com
> >
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>

------=_NextPart_000_0005_01BD2C9D.19749400
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"

eJ8+IggPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAAM4HAQAdAAoAAwAAAAQABAEB
BJAGAMABAAABAAAADgAAAAMAFQwBAAAACwAPDgAAAAADAP4PBgAAAAIB/w8BAAAAUQAAAAAAAACB
Kx+kvqMQGZ1uAN0BD1QCAAABAFJhZGl1c05UQGllYS1zb2Z0d2FyZS5jb20AU01UUABSYWRpdXNO
VEBpZWEtc29mdHdhcmUuY29tAAAAAB4AATABAAAAGgAAAFJhZGl1c05UQGllYS1zb2Z0d2FyZS5j
b20AAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAGgAAAFJhZGl1c05UQGllYS1zb2Z0d2Fy
ZS5jb20AAAACAQswAQAAAB8AAABTTVRQOlJBRElVU05UQElFQS1TT0ZUV0FSRS5DT00AAB4A9l8B
AAAAGgAAAFJhZGl1c05UQGllYS1zb2Z0d2FyZS5jb20AAAACAfdfAQAAAFEAAAAAAAAAgSsfpL6j
EBmdbgDdAQ9UAgAAAQBSYWRpdXNOVEBpZWEtc29mdHdhcmUuY29tAFNNVFAAUmFkaXVzTlRAaWVh
LXNvZnR3YXJlLmNvbQAAAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAAAgMAADACAAAA
B2UBA5AGANwEAAAsAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAALACsAAAAAAAMA
LgAAAAAAAwA2AAAAAAAeAHAAAQAAABkAAABSRTogUmFkaXVzTnQgd2l0aCBPcmFjbGUAAAAAAgFx
AAEAAAAbAAAAAb0sjBZcwjhhRphxEdGjVwBgCBz+VQAOr+ggAAIBHQwBAAAAHQAAAFNNVFA6QlJJ
VFQtV0VCQl9FUklLQEJBSC5DT00AAAAACwABDgAAAABAAAYOAKo8/cYsvQECAQoOAQAAABgAAAAA
AAAAKs5r3ZSS0RGl1gCAx10yv8KAAAALAB8OAQAAAAMABhAAAAAAAwAHEAAAAAAeAAgQAQAAAAQA
AABYKf0AAwAQEJj7GQIDABEQ5AQAAB4AQhABAAAAKgAAADw4NjI1NjU5Qi4wMDJFNjY4NS4wMEBj
aGljYWdvLnZqaW5mby5jb20+AAAAAwCAEP////8DAAFuIAAAAAsAAYAIIAYAAAAAAMAAAAAAAABG
AAAAAAOFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADACSACCAGAAAAAADA
AAAAAAAARgAAAABShQAAxxIAAAsAJYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAngAgg
BgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADACiACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAA
AB4AMIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguNQADADGACCAGAAAAAADAAAAA
AAAARgAAAAABhQAAAAAAAB4ASYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAe
AEqACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgBLgAggBgAAAAAAwAAAAAAA
AEYAAAAAOIUAAAEAAAABAAAAAAAAAB4AUYAIIAYAAAAAAMAAAAAAAABGAAAAAICFAAABAAAACQAA
AEJBSCBJTUFQAAAAAB4AUoAIIAYAAAAAAMAAAAAAAABGAAAAAIGFAAABAAAAIQAAADAwMDAwMDA5
AWJyaXR0LXdlYmJfZXJpa0BiYWguY29tAAAAAAsAU4AIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAAB
AAAACwBWgAsgBgAAAAAAwAAAAAAAAEYAAAAAAIgAAAAAAAALAFiACyAGAAAAAADAAAAAAAAARgAA
AAAFiAAAAAAAAAIB+A8BAAAAEAAAACrOa92UktERpdYAgMddMr8CAfoPAQAAABAAAAAqzmvdlJLR
EaXWAIDHXTK/AgH7DwEAAAB+AAAAAAAAADihuxAF5RAaobsIACsqVsIAAFBTVFBSWC5ETEwAAAAA
AAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lORE9XU1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29m
dFxPZmZpY2VcOC41XE91dGxvb2tcb3V0bG9vay5wc3QAAAADAP4PBQAAAAMADTT9NwAAAgF/AAEA
AAAxAAAAMDAwMDAwMDAyQUNFNkJERDk0OTJEMTExQTVENjAwODBDNzVEMzJCRjg0RTcyMDAwAAAA
AMLE

------=_NextPart_000_0005_01BD2C9D.19749400--