RE: RadiusNt with Oracle

Mitch Wagers ( mwagers@ocsnet.net )
Thu, 29 Jan 1998 00:01:21 -0800

Ok, my bad then. :)

----------
From: Flemming Eriksen
Sent: Wednesday, January 28, 1998 11:53 PM
To: RadiusNT@iea-software.com
Subject: Re: RadiusNt with Oracle

NO, Oracle

Flemming

>I guess I'm a bit lost, are you running Microsoft SQL Server 6.5? I did
>assume that you were, and if that's the case and Oracle claims to support
>that installation, then it is their problem and they do need to comply with
>Microsoft's format because that's what they are supporting. If I claim
>that my ActiveX plugin supports Citrix clients, then well, I have to
>support Citrix, not ANSI. Maybe Dale can shed some light here since he's
>been working with RadiusNT and Oracle lately????
>
>So, Are you running Microsoft SQL Server <>6.5?
>
>At 02:51 PM 1/28/98 +0100, you wrote:
>>Sorry BUT
>>
>>Oracle clames that this is a MS standard, and NOT ANSI standard.
>>In Oracle is it not possible to create functions with "NULL parameter ()".
>>It is possible to create a "GetDate" function, but it must be called
without
>>"()",
>>SELECT GETDATE, will then return the right value.
>>
>>I think I have a BIG problem here.
>>
>>Flemming
>>
>>
>>
>>>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
>>>
>>>
>>>
>>
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>>
>>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>

----------------------------------------------------------
RadiusNT Mailing List lists@iea-software.com

begin 600 WINMAIL.DAT
M>)\^(A<(`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$
MD 8`. $```$````,`````P``, (````+``\.``````(!_P\!````40``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````%)A9&EU<TY40&EE82US;V9T=V%R92YC
M;VT`4TU44 !2861I=7-.5$!I96$M<V]F='=A<F4N8V]M`````!X``C !````
M!0```%--5% `````'@`#, $````:````4F%D:75S3E1 :65A+7-O9G1W87)E
M+F-O;0````,`%0P!`````P#^#P8````>``$P`0```!P````G4F%D:75S3E1
M:65A+7-O9G1W87)E+F-O;2<``@$+, $````?````4TU44#I2041)55-.5$!)
M14$M4T]&5%=!4D4N0T]-```#```Y``````L`0#H!`````@'V#P$````$````
M`````A8]`02 `0`9````4D4Z(%)A9&EU<TYT('=I=&@@3W)A8VQE`&T(`06
M`P`.````S@<!`!T````!`!4`! `-`0$@@ ,`#@```,X'`0`=`````0`&``0`
M_@`!"8 !`"$````T-38Q,SA#,C<Q.3A$,3$Q03,U-S P-C P.#%#1D4U-0#7
M!@$#D 8`9 L``!0````+`",```````,`)@``````"P`I```````#`"X`````
M``,`-@``````0 `Y`"!L8Q:,++T!'@!P``$````9````4D4Z(%)A9&EU<TYT
M('=I=&@@3W)A8VQE``````(!<0`!````%@````&]+(P67,(X84:8<1'1HU<`
M8 @<_E4``!X`'@P!````!0```%--5% `````'@`?# $````3````;7=A9V5R
M<T!O8W-N970N;F5T```#``80RHZ_Z0,`!Q!5# ``'@`($ $```!E````3TLL
M35E"04142$5..BDM+2TM+2TM+2TM1E)/33I&3$5-34E.1T5224M314Y314Y4
M.E=%1$Y%4T1!62Q*04Y505)9,C@L,3DY.#$Q.C4S4$U43SI2041)55-.5$!)
M14$M4T]&5 `````"`0D0`0```-4)``#1"0``818``$Q:1G7:FX2B_P`*`0\"
M%0*D`^0%ZP*#`% 3`U0"`&-H"L!S973N,@8`!L,"@S(#Q@<3`H,B,P]Z:&5L
M`R!$;.IG`H,T$PU]"H (SPG9XCL7GS(U-0* "H$-L<$+8&YG,3 S%" +"@L2
M\@P!8P! ($]K+ `@;7D@8F%D(()T%/!N+B Z*0J%00J+;&DQ.# "T6GP+3$T
M- WP#- ?DPM9;#$V"J #8'0%D 5 +5\AMPJ'(&L,,"$V1@-A.@\BOB$V#((D
M0&QE;6U1"X!G($4%$&L1\&Z_(E\C;09@`C DGR6K5PF HFX'D&1A>1R@2@!P
M)G4*P!S0,C@<H#$Y!#DX+/ Q.C4S(,Q032=_(VU4;RF_):L"4AT`:75S3E1
MH0B082US;P& =PK -&4N!:!M+=\HCG5B[FHA<2__,0QE-= QU05 ]P/P'3 <
M<'(`T": ';\>PSPS-B W%<(,`2$V3D\_'* XWPK!)G8Y/ J%/DD,(&<*4 01
M22=M()9A'. XD" 7,'-T'* ),O$@>0A@(')U;O,#`"136D%`$# ,K$&`!11
M3 92=@20(#8NJ#4_($ `(#'P9#\6VF$$$'4'@!TA805 05+J=P2094#Q;AT0
M!I!$\^8G!" =,2!C1)!!,$7RESQT1P`+86U&L6\@1+#\<' 703\610,+@$#0
M!T#Y"V!T:0(@'* =,D8@2=']1K-I!< A,0)@)I!%XQTQ_1S09$B0*\ )@$AR
M,S$+4+\<T#B"/Q9"%T:A`A!R`,!U!4!B!9!A,A!$Y$:A=_]%$DRC01)(M2;!
M'7! `$9 KS^02!-)*QS!02& :4,@=EA+T I 9PN 2*8$($.[.) %$'A(`0B0
M`C!S2K7_19 5$!R@/Y 1P$,@2'$_%C=(M56U'*!N(5 3<$Y3^DE2<4TL`% `
M%3 '0$;R/U41%/ =$#*@1-$>\&=H[P5 %/!1H@N 8T$P%/!&H.\_%E `5N(%
ML&LFPCB#,=;G1UI*414`>3]@43\6/Q8\4V\<H <003]"3R \ECY#8F">005
M,#(M<%<<8"VP+/ O+, O+2$KNC :P# <H$53(4(Z/Q;%88%R+)%"551GUV?7
M_T>H!X)%`QTP2U%+44!0!>'_2A%&``L11=0\,%\@6<)L!_HN9]=)`Z!'I6MB
M!4!9@OM(X 00:4P136,7H& !3X ?8F!440(@4-$XDB).53Y,0M *L6JA(6 %
MP"@IOB)N"4LS;^]'07'P1Q(`FUJ0(6 B<0<<H&)U2='_4_$R$$_B1P$5$ F
M"H4X@E,(8$D7/B)S`2QGV$4(3$5#7R!'151$^$%411R@`_ 5$4K3%Z"^= AP
M`Z!&T@406^)V!T#/"E!N"&X8:S)N:U=F0%#X0DE'2]=<(GUO:$ ]O;=I:8+O
M:$!43+)(@&P=$.-B$DFD<VXG!4!L%D*B_T.21D!B$D$22B%>$P&@>,'?<?!Z
M9(0(>M5S`"QV`#B0?T:AAC=0\%PR4M%;@@-2(?%#H$YO=QR@1C&%0RR1OT!0
M2A$A8 > `C"$"&IW0O]$D'5QB=E%`WMC!&!W41[P_FM@(4^ "W #(% &0K),
M\/\'D(7QA AB8 2!;!-ZQGAV_P8`>G0%L5MS(5!<(50S`B#_1B -L (P!I (
MD1UP;J *A>^1H"& ><@_@"<5$1&P!9#O?O!&TD*R!N!O?O!\M%F \G>,<4%L
M?+,L$6[868+7!:$7H"& +IV@280(3/#_A?,)X%> C+!,E%KB2!-(>>]"HT8S
M3,.%\FN;44*B7/BS:$ 7H'%U2[".`W.,<>Y(1:%0QD"!<RP`:W%\5%M"O!4P
M94,@%S!P0S%"_YJQ9\B#^7K5A N49W$62]+\9'5<H$:U"' 7H (P0]#_=2-,
M<@=QI8)"N)C9`C $D;\'0$^&3Y&LPZUC?1-S4G'_E'8!D)%01K1R' J%<P!N
M"-^#^DB0'V!,=*Q'<Z5@C?'_K,RGWX1B>FQS`+?_A'$AN$^\#[T?(C>$<4IU
M3>$R;CDL\J;09<$P+:BH6T'_1@$RH)70'6"=HJ4FB)&R"/\L8!41<FJ*45#P
M8N XL%4!_QS DR]%\2;",K"0U,<1FBKE5I$J32)S*DAR6F&6<O]P4UIA<1 5
M$,6)3:)*84P1_U)Q1Z9W05N!E?%8E4M19W$_)M&EDTM11Q(<H)Z$>6&_"H5^
MLV1W:$ =D$.B84C@^Q<P5/!Z;R%2LC*@D\% 1?\4\& !;(&*@T!17:) 4,M#
M_SR <#(K\7@9A C40DC 1^'_EF3+0P,`L3' /[M+A @D5+\F?[BH*8,KGRRI
M9<$W$W#_P"DOTC'?,NVY`C5V-[\\;/VH6T\%,'%CXM!4\$#0+)&_T$GD^6[G
M8E:7`4!050,`[U800O0<H%ZX8ZO1!"!'I0<=,&)0Y$E/1$)#+]U"L2H'P)V0
MYU]#S)8U8/]8I& 1'O#;8436=89S`9RVAE.&280(*$E33V!0_;HI26]3=#L1
MP!J@8?#@%O]&H?"*2(%UB.:OVF.![H/YWX0(^3<F]F=N^MP^T2) ,?N(8TUS
M;D,ACR'JU*S1#E#_1R)(@3QT=J5*`/_1VU(+@--7Z&A 0T%R,%.$".9 __WK
M;ZK8&?Z!JC)+YFN2ZM3_4$+PBD7S;K=2T2Q0A@%T]O_]ZZKW10-,\(7C?S5]
M$TGB[Y<Q<?!S"_V^1$B1B_&:H/YD'-!7DZ(C4/1(D$SPT$G]^OI98B%:XAT`
M'1 A`$AR_T;2Y9\I@2R12(%7DT"!F)&_^PF1,FO25$#JXE)R)U>Q^UV3&V%Y
MB!/-T-)BXZE<%/^4,?L)C6';4DB!]8 F`%ZW[TB!7>+CE%4!*%J@4 ! @?XR
M0W"T`%*#IU"G0.0Z29'??M)KX4*Y2U'@,&:7D*Q0_FS_0Y/(2K.?D%L@>,"%
M$/_["6)1C",\95)QC*%#L1&8^4>E063;06N@'8) </P@?W; F?"D$=#P$I_[
M8]GJ/MU:DT67T.+034%*E\%R\+OQ\-L0<N"2,R(IZE\N[S\O_S$/,>O["4.@
M,Z-)17Y!KA#@]5=17)!2<3.B?/=#H. 666!%S-%:H&R&7R#X1D%1!(J7X:]"
M'9%AD'^Q$'%4L"*U8-UA-7-7@'1 =' Z+R]W.O N_^"O*@_^8[U//J\_O]F?
M_I#O7K=:,)' VU),YD$SI4-6^U9 2A!SX)\\/_HOA#4]G_])/TI/0,]![T+_
M1 ]%'T;?_Z@\4A](+U2_5<]+7TQ_38__3I]/KU*?80=3SU[?7^]6_O]8#UD?
M6B];/I@59CQ=WVB/_VF?5OUB#V,?9"];/9@5LZ+$9%P84#,V,+.@H &0;EQF
M,G% <S)PT5?\TA> 9I9]F! `<P`````#`! 0``````,`$1 `````0 `',. ]
M70V,++T!0 `(,. ]70V,++T!'@`]``$````%````4D4Z( `````#``TT_3<`
#`!U!
`
end