Re: RadiusNt with Oracle

Mitchell B. Wagers ( (no email) )
Wed, 28 Jan 1998 09:27:13 -0800

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
>
>