(RADIATOR) AddressAllocator and SQL

[Vangelis Kyriakakis]

Hello,

     we are trying to use AddressAllocator with Microsoft SQL and Sybase.
     In both situations the default FindQuery
select TIME_STAMP,YIADDR,SUBNETMASK,DNSSERVER from RADPOOL where 
POOL='%0' and STATE=0 order by TIME_STAMP

      tries to allocate a lot of addresses and finally returns an error 
"Too many simultaneous address requests"

     In Microsoft SQL I can use the following query:

select top 1 TIME_STAMP,YIADDR,SUBNETMASK,DNSSERVER from RADPOOL where 
POOL='%0' and STATE=0 order by TIME_STAMP

     and it works fine, trying once to allocate an IP. But this query 
doesn't work with Sybase. What can I use instead of this? Do I do 
something wrong with default query?

               Regards
                     Vangelis
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.